excel filter

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - filter

Excel - filter

resolvedResolved · Low Priority · Version 2010

Antje has attended:
Upgrade to Office 2010 course

Excel - filter

Hi,
I'm just in the process of customizing my Quick Access Toolbar in Excel and would like to add the command that could be found under Data/Filter/Show all in 2003. Where can I find this in 2010, please? I have looked under All Commands, but no luck.
Many thanks.

RE: Excel - filter

Hi Antje, thanks for your query and welcome to the forum. If you're trying to add the "remove filter" option to the Quick Access toolbar, you'll might find it's been renamed. In the Customise box, change from Popular Commands to "Data Tab". Scroll down the list until you find Clear and add that cross to the right hand pane. That should remove any filters from tables that have an autofilter switched on.

Hope this helps,

Anthony


 

Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips


Server loaded in 0.08 secs.