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!

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!