How do I set up headers for columns without using a row?

C

Cloud

I need to make a list of names, addresses...etc, title the column but not use
row 1 so that there is an acurrate count when viewing the spreadsheet.
 
A

Alex

Mr/Mrs Cloud

Type your column header e.g. NAMES in row 1, e.g. cell A1. Then place all
your names in column A. Then highlight the entire column and select
<Insert><Name><Create...> and select <Top Row> from the selections. This will
apply a header to the column e.g. NAMES.

Then when you want to count all the entries in NAMES you can use...

=COUNTA(NAMES)

and this will give the correct answer. Just replicate the above for all your
columns.

Does this answer your query? If not, do take the time to reply and I will
assist further.

Alex
 
R

RagDyer

Use ColumnA as your numbering reference.
You can narrow it down to perhaps a width of "5".

Enter your labels in Row1, starting in B1.
You can leave A1 blank.
In A2 enter
1
In A3 enter
2
Now, select *both* A2 and A3, and using the "fill" handle, drag down to
increment as far as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I need to make a list of names, addresses...etc, title the column but not
use
row 1 so that there is an acurrate count when viewing the spreadsheet.
 
Top