I need help renumbering the spreadsheet.
 

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?

I need help renumbering the spreadsheet.
 

Unhide those hidden rows.

Select row 6 then CTRL + click on row 5900

FormatRowUnhide.

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

Select again and FormatRowHeight enter 13 or similar.

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


Gord Dibben MS Excel MVP

On Thu, 19 Jul 2007 09:54:01 -0700, jtb331235
wrote:

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?

I need help renumbering the spreadsheet.
 

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

"Gord Dibben" wrote:

Unhide those hidden rows.

Select row 6 then CTRL + click on row 5900

FormatRowUnhide.

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

Select again and FormatRowHeight enter 13 or similar.

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


Gord Dibben MS Excel MVP

On Thu, 19 Jul 2007 09:54:01 -0700, jtb331235
wrote:

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?