I need help renumbering the spreadsheet.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jtb331235 - 19 Jul 2007 17:54 GMT

I have a spreadsheet that has the line numbers out of sequence. (1-6 then
5900-6000). How can I get the spreadsheet to renumber the lines in sequence
from 1-1000?

Reply to this Message

Gord Dibben - 19 Jul 2007 21:24 GMT

Unhide those hidden rows.

Select row 6 then CTRL + click on row 5900

Format>Row>Unhide.

If this doesn't work, maybe the rows heights are set to 0

Select again and Format>Row>Height enter 13 or similar.

Or are the rows hidden because you have a filter applied?

Gord Dibben MS Excel MVP

>I have a spreadsheet that has the line numbers out of sequence. (1-6 then
>5900-6000). How can I get the spreadsheet to renumber the lines in sequence
>from 1-1000?

Reply to this Message

jtb331235 - 23 Jul 2007 14:38 GMT

Thanks. The spreadsheet was sent to m by another person. I didn't realize
that there were 'hidden' rows.

> Unhide those hidden rows.
>
[quoted text clipped - 13 lines]
> >5900-6000). How can I get the spreadsheet to renumber the lines in sequence
> >from 1-1000?

Reply to this Message