Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop numbering rows for Titles
Hello,
I would like counting of the rows to start at row 5, instead of row 1, because it is just titles that do not need to be counted, in other words, there is no data until row 5. How do I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop numbering rows for Titles
What does "counting" mean? How do you use the count?
-- Kind regards, Niek Otten Microsoft MVP - Excel "Volunteer_Atwork" wrote in message ... Hello, I would like counting of the rows to start at row 5, instead of row 1, because it is just titles that do not need to be counted, in other words, there is no data until row 5. How do I do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop numbering rows for Titles
I'm guessing that you mean you want the row numbering to start on row 5.
Excel doesn't work that way. You can show the row numbers or hide them. But there's nothing stopping you from putting your own index numbers in column A (insert a new column A if you want). Then you can put whatever you want in those cells. Volunteer_Atwork wrote: Hello, I would like counting of the rows to start at row 5, instead of row 1, because it is just titles that do not need to be counted, in other words, there is no data until row 5. How do I do this? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop numbering rows for Titles
You cannot remove rows and start a new row 1 anywhere you wish.
If you want to see 1 in row 5 and 2 in row 6............ In A5 enter =ROW()-4 Drag/Copy down as far as you wish. Turn off Display of row and column headings. But that would be visual only. Row 5 is still row 5 Gord Dibben MS Excel MVP On Thu, 4 Mar 2010 11:05:01 -0800, Volunteer_Atwork wrote: Hello, I would like counting of the rows to start at row 5, instead of row 1, because it is just titles that do not need to be counted, in other words, there is no data until row 5. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Column as fixed labels - or titles for rows | Setting up and Configuration of Excel | |||
Copy Titles in a long list of rows | Excel Discussion (Misc queries) | |||
Autoformat numbering...how to stop it | Excel Discussion (Misc queries) | |||
How do I do numbering of rows in Excel when there are blank rows? | Excel Discussion (Misc queries) | |||
How do I stop axis titles from overlapping with negative chart da. | Charts and Charting in Excel |