possible to have a view of column with field names?

  • Thread starter Thread starter stef
  • Start date Start date
S

stef

XL 2002 Sp3

U know how u can go Insert|Name|Paste|Paste List and paste the list of
names u have defined with their values, etc.

can u do the same for columns fields so that u have the column
denomination (A, B or C, etc.) and column header (field u define in 1st
cell of each column on 1st row in table) appear in a vertical list of 2
columns, say:

After operation u wd have:
A1=A
B1=first name

B1=B
B2=last name

etc.

Tx
 
There's no built-in feature that will list the column headings for you.
You could copy the headings, then select a cell where you want the
vertical list to start
Choose Edit>Paste Special
Select Values, and check the box for Transpose, then click OK

Add the column letters to the left of the list of headings.
 
Deb,
I've of course already done that, b4 posting here.
I was hoping for an easier way, especially if one has 100 columns.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation and drop-down list using IF, AND and what else? 8
Access Question: Access 2010 – how do I update Unbound fields from a Combo Box (total 3 columns)? 0
why won't text-to-columns work here? 6
VBA - retrieve data on last create named range from previous inserted named range 0
Macro that copies values from column A (from formula) to B (paste value) 1
Rows To Columns & Hyperlink to Email Address 0
How to setup database to make transactions (transfers) between two bank accounts 0
Creating list based on Values from a second column 1

Back
Top