column headers

G

Guest

I need to enter the column headers on the top line, but I do NOT need them to
occupy the "Row 1" numbered position. How do I use the top line for headers
and start the numbers for rows on the second row, starting at #1 on row 2?
 
G

Guest

Your question is incomprehensible. Could you please reword it? You’ve
written it as though we’re sitting there next to you. Be specific and
include an example if you’re having trouble putting it in to words.
 
G

Guest

Marty, why don't you go back to playing with your sister.
I'll just wait until a more intelligent person (who can understand the
question) replys to my post.
OR, maybe "mommy" will give some money to go get an icecream and get off the
internet!
 
D

David McRitchie

Move your columns over by inserting a column before column A.
Select column A, Insert menu, insert column

in cell A2 place the following formula
=ROW()-1
then fill down using the fill handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm

Advantage of using a formula is that you can sort your data and
still have the correct number on the row. The disadvantage for you
in doing any of this is that the number you would see on a printed page
is not the actual row number.
 

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

Top