software

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

Hi GS1

Datagt;Filter..Autofilter

Or Datagt;Filter..Show all--
Regards Ron de Bruin
www.rondebruin.nlquot;GS1quot; gt; wrote in message ...
gt; My filter appears to be stuck. I filtered a column for a date, then changed
gt; the date. Howerever i cannot now change back to show the whole spreadsheet.
gt;
gt; Can anyone help?
gt;
gt; Thanks Graham
Ron,
Yes i tried this but all thats left is a tiny fraction of the spread
sheet..........

quot;Ron de Bruinquot; wrote:

gt; Hi GS1
gt;
gt; Datagt;Filter..Autofilter
gt;
gt; Or Datagt;Filter..Show all
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;GS1quot; gt; wrote in message ...
gt; gt; My filter appears to be stuck. I filtered a column for a date, then changed
gt; gt; the date. Howerever i cannot now change back to show the whole spreadsheet.
gt; gt;
gt; gt; Can anyone help?
gt; gt;
gt; gt; Thanks Graham
gt;
gt;
gt;

ctrl home

--
Don Guillett
SalesAid Software

quot;GS1quot; gt; wrote in message
...
gt; Ron,
gt; Yes i tried this but all thats left is a tiny fraction of the spread
gt; sheet..........
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt;gt; Hi GS1
gt;gt;
gt;gt; Datagt;Filter..Autofilter
gt;gt;
gt;gt; Or Datagt;Filter..Show all
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Regards Ron de Bruin
gt;gt; www.rondebruin.nl
gt;gt;
gt;gt;
gt;gt; quot;GS1quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; My filter appears to be stuck. I filtered a column for a date, then
gt;gt; gt; changed
gt;gt; gt; the date. Howerever i cannot now change back to show the whole
gt;gt; gt; spreadsheet.
gt;gt; gt;
gt;gt; gt; Can anyone help?
gt;gt; gt;
gt;gt; gt; Thanks Graham
gt;gt;
gt;gt;
gt;gt;
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

quot;GS1quot; wrote:

gt; Ron,
gt; Yes i tried this but all thats left is a tiny fraction of the spread
gt; sheet..........
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt; gt; Hi GS1
gt; gt;
gt; gt; Datagt;Filter..Autofilter
gt; gt;
gt; gt; Or Datagt;Filter..Show all
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Regards Ron de Bruin
gt; gt; www.rondebruin.nl
gt; gt;
gt; gt;
gt; gt; quot;GS1quot; gt; wrote in message ...
gt; gt; gt; My filter appears to be stuck. I filtered a column for a date, then changed
gt; gt; gt; the date. Howerever i cannot now change back to show the whole spreadsheet.
gt; gt; gt;
gt; gt; gt; Can anyone help?
gt; gt; gt;
gt; gt; gt; Thanks Graham
gt; gt;
gt; gt;
gt; gt;