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!