How to set up AutoFilters?

M

MS Suzanne

I want to set-up Auto Filters in columns in Excel worksheets (Excel version
2003). This function will allow me to sort for entries in the column that
match the filter. Once selected, all other entries are temporarily hidden.
The worksheet indicates this option by adding a drop-down arrow to each
column header. Yesterday I sorted my data and lost these arrows and I'd like
to restore them.
 
D

David McRitchie

Try selecting all cells Ctrl+A for everyone else, but since
you are on Excel 2003 you would have to use Ctrl+Shift+SpaceBar
then use Data, FILTER, Auto Filter

To remove the arrows again Data, FILTER, uncheck Auto Filter-

For more help on Filtering see Debra Dalgleish's pages at
http://www.contextures.com/tiptech.html -- this is her index
 
Top