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

[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!

 

[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?".