Home |
Search |
Today's Posts |
#1
|
|||
|
|||
column headers
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? -- mtn_leisure |
#2
|
|||
|
|||
Your question is incomprehensible. Could you please reword it? Youve
written it as though were sitting there next to you. Be specific and include an example if youre having trouble putting it in to words. "mtn_leisure" wrote: 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? -- mtn_leisure |
#3
|
|||
|
|||
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! -- mtn_leisure "marty" wrote: Your question is incomprehensible. Could you please reword it? Youve written it as though were sitting there next to you. Be specific and include an example if youre having trouble putting it in to words. "mtn_leisure" wrote: 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? -- mtn_leisure |
#4
|
|||
|
|||
I'm sorry for my harsh words. I was simply asking for more information.
Marty "mtn_leisure" wrote: 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! -- mtn_leisure "marty" wrote: Your question is incomprehensible. Could you please reword it? Youve written it as though were sitting there next to you. Be specific and include an example if youre having trouble putting it in to words. "mtn_leisure" wrote: 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? -- mtn_leisure |
#5
|
|||
|
|||
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. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "mtn_leisure" wrote in message ... 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? -- mtn_leisure |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In MS Excel, how do I change the column ref headers from numbers . | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
how can I change the a,b,c, column headers in excel to names | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |