hidden rows

J

Jessie

I have a manager here who has somehow hidden and locked
rows on his excel spreadsheet. He said that all he did
was the row-hide command. All the row numbers below the
hidden rows are now blue instead of black. The worksheet
has not been protected, and the panes are not frozen. Any
ideas? Thanks.
 
S

Stephen Dunn

The blue row numbers are the clue that Autofilter has been turned on. To
turn it off go to Data>Filter>Autofilter.
 
A

Anon

Or another filter:
Data > Filter > Show All

Stephen Dunn said:
The blue row numbers are the clue that Autofilter has been turned on. To
turn it off go to Data>Filter>Autofilter.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidden text in tables causes empty rows 0
Excel - viewing hidden rows 2
unhide row does not unhide the hidden rows 4
Hiding/Exposing Rows based on a cell value 10
Hiding/Unhiding Rows Automatically 1
Cannot shift objects off sheet 2
hide row based on cell value 2
Copying worksheets with formulas in hidden columns 2

Top