View excel in Address Format

A

amerifax

Board Regular
Joined
Dec 17, 2008
Messages
247
View excel in Address Format

In dBase IV you can use F2 to view a row of fields like an address formate.

Is there a hot key to use in excel that will display the rows like a column of data for each row?

Bob
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
If you mean the Browse vs. Edit screens (I don't know dbase, but I just googled it) then I don't believe what you're after exists in Excel. You could create a simple user form with fields linked to your data table and then browse through the records that way, though.
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question Question
Column with Min/Average values at the end of Pivot Table
Replies
0
Views
161
Nurces
N
T
  • Question Question
Moving address list to columns from rows
Replies
3
Views
90
Sufiyan97
Sufiyan97
R
  • Solved
SEPARATE LARGE COLUMN INTO 4 COLUMNS
2
Replies
11
Views
206
Peter_SSs
Peter_SSs
A
  • Question Question
Excel file on SharePoint used at the same time
Replies
1
Views
145
ExcelToDAX
E
S
  • Question Question
VBA : Reflection Workspace extract all screen/pages
Replies
0
Views
127
Samantha27
S

Forum statistics

Threads
1,224,586
Messages
6,179,713
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top