| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbering rows that are not hidden
I have a spreadsheet with hidden rows. I want to number the rows that are
NOT hidden, so that I have a count of the rows that are visable. Example: Rows 1-10 are hidden, but 11-20 are visable. I want row 11, to actually show as row 1. I only really need this for printing purposes. Is there any way to do this? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numbering rows that are not hidden
You'd have to insert a temporary new column A and run your numbers down it.
-- Jim "sscheirer" wrote in message ... |I have a spreadsheet with hidden rows. I want to number the rows that are | NOT hidden, so that I have a count of the rows that are visable. | | Example: | | Rows 1-10 are hidden, but 11-20 are visable. I want row 11, to actually | show as row 1. | | I only really need this for printing purposes. Is there any way to do this? | | Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Did I stump everyone? Counter that ignores hidden rows | Excel Discussion (Misc queries) | |||
| Numbering of Grouped Rows | Excel Discussion (Misc queries) | |||
| Can't See Rows (not hidden) | Excel Discussion (Misc queries) | |||
| Can't See Rows (not hidden) | Excel Discussion (Misc queries) | |||
| Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) | |||
Linear Mode
