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

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!

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

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

"Kristine" wrote:

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!