How to set up AutoFilters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merged cells disturb autofilter indicator 2
Macro turn off AutoFilter 2
Delete options for AutoFilter? 2
Autofilter with drop down menu 1
Autofilter on rows instead of columns 6
autofilter does not hide unwanted results 2
auto filter on columns 2
Can I set a cell value to a filter selection in Excel? 5

Back
Top