| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Renumbering a list of numbers | Excel Discussion (Misc queries) | |||
| renumbering of rows | Excel Discussion (Misc queries) | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| Automatic Sequential renumbering within formulas | Excel Worksheet Functions | |||
Linear Mode
