If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
my row numbers jump from 93 to 279. Why?
I have a spreadsheet of information. I have 93 battery jobs. The worksheet
skips some numbers even though I come up with the right amount. The end of my data ends at 93, but jumps to 279, so I can't add data and have the correct number I don't understand how row numbers can be missing and I still end up with the right number of rows. I cannot get the worksheet to start again at 94 so I can add more data and keep track of it. |
#2
|
|||
|
|||
my row numbers jump from 93 to 279. Why?
Rows can be hidden on a worksheet.
One way to unhide them: Data|Filter|Show All If that isn't available, you can select all of column A. Then click on Format|Row|Unhide Clare wrote: I have a spreadsheet of information. I have 93 battery jobs. The worksheet skips some numbers even though I come up with the right amount. The end of my data ends at 93, but jumps to 279, so I can't add data and have the correct number I don't understand how row numbers can be missing and I still end up with the right number of rows. I cannot get the worksheet to start again at 94 so I can add more data and keep track of it. -- Dave Peterson |
#3
|
|||
|
|||
my row numbers jump from 93 to 279. Why?
Have you hidden the 'missing' rows?
Highlight (click on the row numbers) 93 through 279 and click FormatRowUnhide Regards. Bill Ridgeway Computer Solutions "Clare" wrote in message ... I have a spreadsheet of information. I have 93 battery jobs. The worksheet skips some numbers even though I come up with the right amount. The end of my data ends at 93, but jumps to 279, so I can't add data and have the correct number I don't understand how row numbers can be missing and I still end up with the right number of rows. I cannot get the worksheet to start again at 94 so I can add more data and keep track of it. |
Thread Tools | |
Display Modes | |
|
|