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
Excel does not have any shortcut keys for aligning text. See related links for all shortcut keys for Excel 2007.
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.
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.
It can indicate a table or that AutoFilter is on.
you can assign shortcut key to application by right clicking and choose properties then under shortcut key assign something you will remember
Filter and its associated command Autofilter.
That depends on the application. Commonly it is the F5 key, like in Word and Excel. Ctrl-G can be used as the shortcut.
Ctrl-D
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.)
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.
Filter and its associated command Autofilter.
sales