After filtering and saving, excel will no longer display..

K

Kristine

After filtering and saving changes, excel will not display any of the rows on
the worksheet.
I've figured out how to display the rows manually 1 by 1, but when I do that
it wont scroll past row 36.
Basically I just want to bring up all the information on the worksheet. HELP!
 
A

ADB_Seeker

Three things to check:
Unhide Rows:
Select all by clicking on the small square above row 1 and left of column A
For 2003: Click on Format > Row > Unhide
For 2007: Have Home ribbon visible, click on Cells > Format > Hide &
Unhide, then select unhide rows

Unfreeze
For 2003: Click on Windows > Unfreeze
For 2007: Click on View > Window group > Unfreeze Panes (if nothing is
frozen, this option shows Freeze)

Split pane:
For 2003: Click on Windows > Remove Split
For 2007: Click on View > Window group > Split (if nothing is split,
this adds a split, which you will need to remove.)

If this post is helpful, please check Yes for "Was this post helpful to you?".
 

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

Top