numbering rows that are not hidden

G

Guest

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.
 
J

Jim Rech

You'd have to insert a temporary new column A and run your numbers down it.

--
Jim
|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.
 

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