listi.net

Listi.net

             



Excel Short cut keys



Excel Shortcut keys

 KeyMeaning
Ctrl+1Format Dialog box
Ctrl+!0.00 format
Ctrl+2Bold
Ctrl+@Time format hh:mm Am
Ctrl+3Italic
Ctrl+#mm-MMM-yy
Ctrl+4Underscore
Ctrl+$$0.00
Ctrl+5Strikethrough
Ctrl+%Percent
Ctrl+6Hides/Show Graphics
Ctrl+^Expoent format
Ctrl+7Standard Toolbar
Ctrl+&Border
Ctrl+8Show/hide Outline symbols
Ctrl+*Select Current Region
Ctrl+9Hide Selected Rows
Ctrl+(Unhide hidden rows within selection
Ctrl+0Hide selected Columns
Ctrl+)Unhided hidden columns with selection
Ctrl+-Delete dialog
Ctrl+_Removes Border from selected Cells
Ctrl+=None
Ctrl+{backspace}Scroll to display the active cell
Ctrl+F1 
Ctrl+F3Define Name Dialog
Ctrl+Shift+F3Create names from cell text
Ctrl+F4Close ?
Shift+F4One empty cell to left or up if at beginning
None+F5Goto dialog
Ctrl+F5Normal from Maximized
Ctrl+Shift+F5None
Ctrl+F6Switch to other Excel windows
Ctrl+Shift+F6Switch to other Excel windows move in reverse of F6
Ctrl+F7Move workbook window
Ctrl+Shift+F7????
Ctrl+F8Resize width
Ctrl+Shift+F8?????
Ctrl+F9Minimize window
Ctrl+Shift+F9?
F10Go to menu
Ctrl+F10Maximize
Ctrl+Shift+F10Go to menu, if on menu brings up popup menu
Ctrl+F11Add sheet with name "Macro" allows you to run the commands as a macro
Ctrl+Shift+F11?
Ctrl+F12Open dialog
Ctrl+Shift+F12Print Dialog
Ctrl+EscWindows Start Button
Ctrl+Shift+EscTaskMgr
Ctrl+WClose ?
Ctrl+Shift+WWord Wrap (User defined)
Ctrl+ENone
Ctrl+Shift+ENo
Ctrl+RFill cell to Right
Ctrl+Shift+RNone
Ctrl+TNone
Ctrl+Shift+TNone
Ctrl+U Underscore
Ctrl+Shift+U Unassigned?
Ctrl+IItalic
Ctrl+Shift+IIn a selected column, select the cells that don?t match the value in the active cell
Ctrl+OOpen dialog
Ctrl+Shift+OSelect cells with comments
None+Esc"Close Dialog
Exit Edit mode"
Ctrl+PPrint Dialog
Ctrl+Shift+PChange Font Size
Ctrl+=?
Ctrl++Insert cells dialog
Ctrl+Backspace?
Ctrl+Shift+Backspace 
Ctrl+[Select only cells that are directly referred to by formulas in the selection
Ctrl+{Select all cells that are directly or indirectly referred to by formulas in the selection
Ctrl+]Select only cells with formulas that refer directly to the active cell
Ctrl+}Select all cells with formulas that refer directly or indirectly to the active cell
Ctrl+\Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell.
Ctrl+|Select cells in a column that don't match the value in the active cell in that column. You must select the column starting with the active cell.
Ctrl+ASelect All
Ctrl+Shift+A Insert the argument names and parentheses for a function after you type a function name in a formula
Ctrl+BBold
Ctrl+Shift+B 
Ctrl+CCopy
Ctrl+Shift+C 
Ctrl+DFill Down
Ctrl+Shift+D 
Ctrl+E 
Ctrl+' 
Ctrl+FFind Dialog
Ctrl+Shift+FExplorer Dialog
Ctrl+GGo to dialog
Ctrl+Shift+G?
Ctrl+HFind/Replace dialog
Ctrl+Shift+HNone
0 
Ctrl+JNone
Ctrl+Shift+JNone
Ctrl+KHyperlink dialog
Ctrl+Shift+KNone
Ctrl+L - TNone
Ctrl+Shift+LNone
Ctrl+U Underscore
Ctrl+Shift+U ?
Ctrl+VPaste
Ctrl+Sift+V 
Ctrl+WClose?
Ctrl+Shift+W 
Ctrl+XCut
ctrl+Shift+X 
Ctrl+YRepeat last action
Ctrl+ZUndo
Ctrl+, 
Ctrl+Shift+,Fill Down
Ctrl+General number format
Ctrl+`Toggle between Formula Auditing formula display and value display
Ctrl+<?
Ctrl+. (Period)Move to next corner of selected range
Ctrl+>Clear?
Ctrl+/Select current array
Ctrl+??
Ctrl+;current date
Ctrl+:Current time
Ctrl+'Copies a formula from the cell above the active cell into the cell or the Formula Bar.
Ctrl+"Copies the value from the cell above the active cell into the cell or the Formula Bar.
Ctrl+Delete"Delete text to the end of the line
Clearcontents"
Ctrl+InsertCopy
Ctrl+HomeGoes to the home cell. With freeze panes it's below the freeze point
Ctrl+Shift+HomeSelect current cell to home cell
Ctrl+Shift+InsertNone
Ctrl+Shift+DeleteNone
Ctrl+EndLast Cell
Ctrl+Shift+EndSelect from current cell to last cell
Ctrl+Page DownNext sheet
Ctrl+Page UpPrevious sheet
Ctrl+Shift+Page DownSelect current and next shet
Ctrl+Shift+Page UpSelect current and previous sheet
Ctrl+UpMove up to region boundary or next region or edge of worksheet
Ctrl+DownMove down to region boundary or next region or edge of worksheet
Ctrl+SpacebarSelect Column
Ctrl+Shift+UpSelect from current cell to region boundary
Ctrl+Shift+DownSelect from current cell to last cell to region boundary
Ctrl+Keypad 0Copy
Ctrl+ 
Ctrl+Alt+Windows Desktop 
Ctrl+Alt+F1Insert Macro sheet
Ctrl+Alt+F2Open dialog
Ctrl+Alt+F4"Close Dialog
Exit Edit mode"
Ctrl+Alt+F9Calculate full
Ctrl+Alt+DeleteWindows Security dialog
Alt+F1Insert Chart
Alt+F2Save As
Alt+F4Exit Excel
Alt+F8Macro dialog
Alt+F11VB Window
Alt+-Control Menu
Alt+WWindow menu
Alt+EEdit menu
Alt+TTools menu
Alt+IInsert menu
Alt+OFormat menu
Alt+DData menu
Alt+FFile menu
Alt+HHelp menu
Alt+;select all
Alt+'Style dialog
Alt+VView Menu
Alt+Page DownPage Left
Alt+Page UpPage right
Alt+Down arrowSelection box
Ctrl+TabSwitch to next tool bar. To get to menu press Alt
Shift+F10Open popup menu (right click)
Alt+SpacebarControl Menu
Ctrl+Shift+F12Print Dialog
Shift+F11Insert Worksheet
Alt+Shift+F1Insert Worksheet
Alt+O,H,RRename current sheet
Alt+E,MMove or copy current sheet
Alt+E,LDelete current sheet
Ctrl+Alt+Right ArrowSwitch to next region
EndEnd Mode turned off or on
End+ArrowMove by one block of data
Ctrl+\in a selected row, select values that don?t match the active cell
Shift+SpacebarSelect Row
F4Repeat last action
Ctrl+ 
Alt+;Select visible cells in current selection
Shift+F8Add another range of cesll to the selection
Shift+Arrow 
Alt+Down,Home,EnterOn Autofilter shows all
Alt+Shift+Right ArrowGroups records
Alt+Shift+Left ArrowUngroups records


blog comments powered by Disqus
Home

Sign In
Sign Up

FAQ
About
Help
Contact Us
Terms and Conditions

Tweet List

Link to us