Auto Filter

Hi,

I have just turned on Auto Filter so that I can sort the names in a
column in alphabetical order. I was able to do this, but wondered is
there a way to get them back to what they were prior to filtering? I
know you can uncheck the auto filter which takes away the filtering
options and the drop down lists that appear to the top of each column,
but is there a way to revert back to the way it was before filtering?

Any help would be appreciated.

Seraya

In article <17e21c00.0403171555.3382f7c2.RemoveThis@posting.google.com>,
officelink.RemoveThis@iinet.net.au (Seraya) wrote:

 > Hi,
 >
 > I have just turned on Auto Filter so that I can sort the names in a
 > column in alphabetical order. I was able to do this, but wondered is
 > there a way to get them back to what they were prior to filtering? I
 > know you can uncheck the auto filter which takes away the filtering
 > options and the drop down lists that appear to the top of each column,
 > but is there a way to revert back to the way it was before filtering?
 >
 > Any help would be appreciated.
 >
 > Seraya

After the sort and before you do anything else, you can try undo, cmd-z.
Otherwise close the window and don't save, to revert to the prior state
(assuming it was saved in the first place).


--
Harvey Products makers of Dinghy Dogs�
The Boater's Best Friend
<a style='text-decoration: underline;' href="http://www.dinghydogs.com" target="_blank">http://www.dinghydogs.com</a>
Remove thefrown to email me<!-- ~MESSAGE_AFTER~ -->