ExcelBanter - how can I view the entire worksheet when the row numbers are blue

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how can I view the entire worksheet when the row numbers are blue (https://www.excelbanter.com/excel-worksheet-functions/6902-how-can-i-view-entire-worksheet-when-row-numbers-blue.html)

carrie

how can I view the entire worksheet when the row numbers are blue

The row numbers on the left jump from 1 to 212 and then again to 300, and
they are blue. It is almost like they are hidden, but they are not. I tried
to unhide them already and it did not work. How can I view the whole
worksheet?

Dave R.

Datafiltershow all.

"carrie" wrote in message
...
The row numbers on the left jump from 1 to 212 and then again to 300, and
they are blue. It is almost like they are hidden, but they are not. I
tried
to unhide them already and it did not work. How can I view the whole
worksheet?

Gord Dibben

Carrie

Sounds like a filtered sheet.

DataFilterShow All.

Gord Dibben Excel MVP

On Mon, 22 Nov 2004 09:51:24 -0800, carrie
wrote:

The row numbers on the left jump from 1 to 212 and then again to 300, and
they are blue. It is almost like they are hidden, but they are not. I tried
to unhide them already and it did not work. How can I view the whole
worksheet?

All times are GMT +1. The time now is 04:48 PM.