ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Filtered worksheet is frozen (https://www.excelbanter.com/excel-programming/344474-filtered-worksheet-frozen.html)

Cheer-Phil-ly

Filtered worksheet is frozen
 
I have a worksheet that has 3303 rows that apparently has been filtered so
that only rows 1231 thru 2368 are showing. I need to see the whole
worksheet, rows 1 thru 3303.

I have tried to clear this filter using several methods but nothing works...
it seems to be stuck. Does anyone have any insight to this issue?

Dave Peterson

Filtered worksheet is frozen
 
I bet the freeze panes was applied in the wrong spot.

Window|unfreeze panes

Then try scrolling up.

Cheer-Phil-ly wrote:

I have a worksheet that has 3303 rows that apparently has been filtered so
that only rows 1231 thru 2368 are showing. I need to see the whole
worksheet, rows 1 thru 3303.

I have tried to clear this filter using several methods but nothing works...
it seems to be stuck. Does anyone have any insight to this issue?


--

Dave Peterson

Cheer-Phil-ly

Filtered worksheet is frozen
 
Finally figured it out... sheet not filter, rather rows were hidden. Easy to
fix. Thanks anyway!

"Cheer-Phil-ly" wrote:

I have a worksheet that has 3303 rows that apparently has been filtered so
that only rows 1231 thru 2368 are showing. I need to see the whole
worksheet, rows 1 thru 3303.

I have tried to clear this filter using several methods but nothing works...
it seems to be stuck. Does anyone have any insight to this issue?



All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com