answersLogoWhite

0

Ctrl+Shift+L (or)

Alt + D + F + F

That will open the Data>filter>autofilter

Display the AutoFilter list for the current column Select the cell that contains the column label, and then press

ALT + DOWN ARROW

Close the AutoFilter list for the current column

ALT + UP ARROW

Select the next item in the AutoFilter list

DOWN ARROW

Select the previous item in the AutoFilter list

UP ARROW

Select the first item (All) in the AutoFilter list

HOME

Select the last item in the AutoFilter list

END

Filter the list by using the selected item in the AutoFilter list

ENTER

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What is text alignment shortcut key justified?

Excel does not have any shortcut keys for aligning text. See related links for all shortcut keys for Excel 2007.


What are the steps to start Microsoft excel?

Create a shortcut key by right clicking on the excel icon on the desktop or from the folder menu and click properties. Define your shortcut key. Can do from the keyboard once this is done.


Is there a shortcut key for fractions?

Not in Excel. Excel does not use fractions. If you need to use fractions, then turn them into decimals. You can represent 1/2 in excel with the formula =1/2.


Does a filter arrow on a column indicate that it is an Excel table?

It can indicate a table or that AutoFilter is on.


Another option to launch the Microsoft Excel?

you can assign shortcut key to application by right clicking and choose properties then under shortcut key assign something you will remember


What excel feature locates rows in a table that meet a criteria?

Filter and its associated command Autofilter.


Function key for go to?

That depends on the application. Commonly it is the F5 key, like in Word and Excel. Ctrl-G can be used as the shortcut.


What is the shortcut key in Microsoft Excel to copy a formula from the cell above instead of dragging it?

Ctrl-D


What shortcut key do you press to unfreeze column and row titles?

There is no shortcut key to do this, but you can press Alt + W + F + F in Excel 2007 to access menu options to toggle between freeze and unfreeze panes. (I do not remember if this same sequence works with Excel 2003; you might just have to press F one time in Excel 2003.)


What is a shortcut menu in excel?

If you right-click on the mouse or hit the shortcut menu key on your keyboard, a menu appears with common commands that are used or are relevant at the time depending on what you are doing. This menu is known as a shortcut menu.


What excel feature can be used to easily locate rows in a table?

Filter and its associated command Autofilter.


When working with a workbook of data on sales representatives and their office location which of the tasks can excel's autofilter heop you to perform?

sales