ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   my filter is stuck ! (https://www.excelbanter.com/excel-worksheet-functions/82167-my-filter-stuck.html)

GS1

my filter is stuck !
 
My filter appears to be stuck. I filtered a column for a date, then changed
the date. Howerever i cannot now change back to show the whole spreadsheet.

Can anyone help?

Thanks Graham

Ron de Bruin

my filter is stuck !
 
Hi GS1

DataFilter..Autofilter

Or DataFilter..Show all


--
Regards Ron de Bruin
http://www.rondebruin.nl


"GS1" wrote in message ...
My filter appears to be stuck. I filtered a column for a date, then changed
the date. Howerever i cannot now change back to show the whole spreadsheet.

Can anyone help?

Thanks Graham




GS1

my filter is stuck !
 
Ron,
Yes i tried this but all thats left is a tiny fraction of the spread
sheet..........

"Ron de Bruin" wrote:

Hi GS1

DataFilter..Autofilter

Or DataFilter..Show all


--
Regards Ron de Bruin
http://www.rondebruin.nl


"GS1" wrote in message ...
My filter appears to be stuck. I filtered a column for a date, then changed
the date. Howerever i cannot now change back to show the whole spreadsheet.

Can anyone help?

Thanks Graham





Don Guillett

my filter is stuck !
 
ctrl+home

--
Don Guillett
SalesAid Software

"GS1" wrote in message
...
Ron,
Yes i tried this but all thats left is a tiny fraction of the spread
sheet..........

"Ron de Bruin" wrote:

Hi GS1

DataFilter..Autofilter

Or DataFilter..Show all


--
Regards Ron de Bruin
http://www.rondebruin.nl


"GS1" wrote in message
...
My filter appears to be stuck. I filtered a column for a date, then
changed
the date. Howerever i cannot now change back to show the whole
spreadsheet.

Can anyone help?

Thanks Graham







GS1

my filter is stuck !
 
Hey Ron, You just saved my life...........thanks i can go home from work now,
thought i was gonna be here all weekend. have a good weekend

"GS1" wrote:

Ron,
Yes i tried this but all thats left is a tiny fraction of the spread
sheet..........

"Ron de Bruin" wrote:

Hi GS1

DataFilter..Autofilter

Or DataFilter..Show all


--
Regards Ron de Bruin
http://www.rondebruin.nl


"GS1" wrote in message ...
My filter appears to be stuck. I filtered a column for a date, then changed
the date. Howerever i cannot now change back to show the whole spreadsheet.

Can anyone help?

Thanks Graham






All times are GMT +1. The time now is 08:55 AM.

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