View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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