| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh advanced filter | Excel Discussion (Misc queries) | |||
| Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
| How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
| Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
