Translate English to Arabic Google-Translate-Chinese (Simplified) BETA Translate English to Arabic Translate English to Arabic Translate English to Croatian Translate English to Czech Translate English to danish Translate English to Dutch Translate English to Finnish Translate English to French Translate English to German Translate English to Greek Translate English to Hindi  Translate English to Italian Google-Translate-English to Japanese BETA Translate English to Korean BETA Translate English to Norwegian Translate English to Polish Translate English to Portuguese Translate English to Romanian Translate English to Russian Translate English to Russian BETA Translate English to Spanish

Excel Keyboard Shortcuts

Excel Keyboard Shortctus (239 Shortcuts)

 
Shortcuts for selecting cells, rows and columns and objects
1CTRL+SPACEBARSelect the entire column
2SHIFT+SPACEBARSelect the entire row
3CTRL+ASelect the entire worksheet
4SHIFT+BACKSPACEWith multiple cells selected, select only the active cell
5CTRL+SHIFT+SPACEBARWith an object selected, select all objects on a sheet
6CTRL+6Alternate between hiding objects, displaying objects, and displaying placeholders for objects
7CTRL+SHIFT+*Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable report, select the entire PivotTable report
8CTRL+/Select the array containing the active cell
9CTRL+SHIFT+OSelect all cells that contain comments
10CTRL+\In a selected row, select the cells that do not match the value in the active cell
11CTRL+SHIFT+|In a selected column, select the cells that do not match the value in the active cell
12CTRL+[Select all cells directly referenced by formulas in the selection
13CTRL+SHIFT+{Select all cells directly or indirectly referenced by formulas in the selection
14CTRL+]Select cells that contain formulas that directly reference the active cell
15CTRL+SHIFT+}Select cells that contain formulas that directly or indirectly reference the active cell
16ALT+;Select the visible cells in the current selection
17F8Turn extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection
18SHIFT+F8Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range
19SHIFT+ARROW KEYSExtend the selection by one cell
20CTRL+SHIFT+ARROW KEYSExtend the selection to the last nonblank cell in the same column or row as the active cell
21SHIFT+HOMEExtend the selection to the beginning of the row
22CTRL+SHIFT+HOMEExtend the selection to the beginning of the worksheet
23CTRL+SHIFT+ENDExtend the selection to the last used cell on the worksheet (lower-right corner)
24SHIFT+PAGE DOWNExtend the selection down one screen
25SHIFT+PAGE UPExtend the selection up one screen
26END+SHIFT+ARROW KEYSExtend the selection to the last nonblank cell in the same column or row as the active cell
27END+SHIFT+HOMEExtend the selection to the last used cell on the worksheet (lower-right corner)
28END+SHIFT+ENTERExtend the selection to the last cell in the current row. This key sequence does not work if you have turned on transition navigation keys (Tools menu, Options command, Transition tab)
29SCROLL LOCK+SHIFT+HOMEExtend the selection to the cell in the upper-left corner of the window
30SCROLL LOCK+SHIFT+ENDExtend the selection to the cell in the lower-right corner of the window
 
Excel Shortcuts for entering, editing, formatting and calculating data
31ENTERComplete a cell entry and select the cell below
32ALT+ENTERStart a new line in the same cell
33CTRL+ENTERFill the selected cell range with the current entry
34SHIFT+ENTERComplete a cell entry and select the previous cell above
35TABComplete a cell entry and select the next cell to the right
36SHIFT+TABComplete a cell entry and select the previous cell to the left
37ESCCancel a cell entry
38ARROW KEYSMove one character up, down, left, or right
39HOMEMove to the beginning of the line
40F4 or CTRL+YRepeat the last action
41CTRL+SHIFT+F3Create names from row and column labels
42CTRL+DFill down
43CTRL+RFill to the right
44CTRL+F3Define a name
45CTRL+KInsert a hyperlink
46CTRL+;Enter the date
47CTRL+SHIFT+:Enter the time
48ALT+ARROW DOWNDisplay a drop-down list of the values in the current column of a range
49CTRL+ZUndo the last action
50ALT+0162Enters the cent character
51ALT+0163Enters the pound sterling character
52ALT+0165Enters the yen symbol
53ALT+0128Enters the euro symbol
 
Shortcuts to enter and calculate formulas in Excel
54=Start a formula
55F2Move the insertion point into the Formula Bar when editing in a cell is turned off
56BACKSPACEIn the Formula Bar, delete one character to the left
57ENTERComplete a cell entry from the cell or Formula Bar
58CTRL+SHIFT+ENTEREnter a formula as an array formula. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER
59ESCCancel an entry in the cell or Formula Bar
60SHIFT+F3In a formula, display the Insert Function dialog box
61CTRL+AWhen the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box
62CTRL+SHIFT+AWhen the insertion point is to the right of a function name in a formula, insert the argument names and parentheses
63F3Paste a defined name into a formula
64ALT+=Insert an AutoSum formula with the SUM function
65CTRL+SHIFT+"Copy the value from the cell above the active cell into the cell or the Formula Bar
66CTRL+'Copies a formula from the cell above the active cell into the cell or the Formula Bar
67CTRL+`Alternate between displaying cell values and displaying formulas
68F9Calculate all worksheets in all open workbooks
69SHIFT+F9Calculate the active worksheet
70CTRL+ALT+F9Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
71CTRL+ALT+SHIFT+F9Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated
 
Keys for editing data and working with Excel cells
72F2Edit the active cell and position the insertion point at the end of the cell contents
73ALT+ENTERStart a new line in the same cell
74BACKSPACEEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents
75DELETEDelete the character to the right of the insertion point, or delete the selection
76CTRL+DELETEDelete text to the end of the line
77F7Display the Spelling dialog box
78SHIFT+F2Edit a cell comment
79ENTERComplete a cell entry and select the next cell below
80CTRL+ZUndo the last action
81ESCCancel a cell entry
82CTRL+SHIFT+ZWhen the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction
83CTRL+CCopy the selected cells
84CTRL+XCut the selected cells
85CTRL+VPaste copied cells
86DELETEClear the contents of the selected cells
87CTRL+-Delete the selected cells
88CTRL+SHIFT++Insert blank cells
 
Shortcuts to format Excel data
89ALT+'Display the Style dialog box
90CTRL+1Display the Format Cells dialog box
91CTRL+SHIFT+~Apply the General number format
92CTRL+SHIFT+$Apply the Currency format with two decimal places (negative numbers in parentheses)
93CTRL+SHIFT+%Apply the Percentage format with no decimal places
94CTRL+SHIFT+^Apply the Exponential number format with two decimal places
95CTRL+SHIFT+#Apply the Date format with the day, month, and year
96CTRL+SHIFT+@Apply the Time format with the hour and minute, and AM or PM
97CTRL+SHIFT+!Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values
98CTRL+BApply or remove bold formatting
99CTRL+IApply or remove italic formatting
100CTRL+UApply or remove underlining
101CTRL+5Apply or remove strikethrough
102CTRL+9Hide the selected rows
103CTRL+SHIFT+(Unhide any hidden rows within the selection
104CTRL+0Hide the selected columns
105CTRL+SHIFT+)Unhide any hidden columns within the selection
106CTRL+SHIFT+&Apply the outline border to the selected cells
107CTRL+SHIFT+_Remove the outline border from the selected cells
 
Excel Help Task Pane Shortcuts
108F1Display the Help task pane
109F6Switch between the Help task pane and the active application
110TABSelect the next item in the Help task pane
111SHIFT+TABSelect the previous item in the Help task pane
112ENTERPerform the action for the selected item
113ARROW DOWNARROW UPIn a Table of Contents, select the next and previous item, respectively
114ARROW RIGHTARROW LEFTIn a Table of Contents, expand and collapse the selected item, respectively
115ALT+ARROW LEFTMove back to the previous task Pane
116ALT+ARROW RIGHTMove forward to the next task Pane
117CTRL+SPACEBAROpen the menu of Pane options
118CTRL+F1Close and reopen the current task pane
119ARROW RIGHTExpand a +/- list
120ARROW LEFTCollapse a +/- list
 
Excel Shortcuts for the Help window
121TABSelect the next hidden text or hyperlink, or Show All or Hide All at the top of a topic
122SHIFT+TABSelect the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web site article
123ENTERPerform the action for the selected Show All, Hide All, hidden text, or hyperlink
124ALT+ARROW LEFTMove back to the previous Help topic.
125ALT+ARROW RIGHTMove forward to the next Help topic
126CTRL+PPrint the current Help topic
127ARROW UPARROW DOWNScroll small amounts up and down, respectively, within the currently-displayed Help topic
128PAGE UP and PAGE DOWNScroll larger amounts up and down, respectively, within the currently-displayed Help topic
129ALT+UChange whether the Help window appears connected to (tiled) or separate from (untiled) the active application
130SHIFT+F10Display a menu of commands for the Help window; requires that the Help window have active focus (click an item in the Help window)
 
Shortcuts to access and use task panes
131F6Move to a task pane
132CTRL+TABWhen a menu or toolbar is active, move to a task pane. (You may need to pressCTRL+TAB more than once.)
133TAB or SHIFT+TABWhen a task pane is active, select the next or previous option in the task pane
134CTRL+SPACEBARDisplay the full set of commands on the task pane menu
135ARROW DOWN or ARROW UPMove among choices in a selected submenu; move among certain options in a group of options
136SPACEBAR or ENTEROpen the selected menu, or perform the action assigned to the selected button
137SHIFT+F10Open a shortcut menu open a drop-down menu for the selected gallery item
138HOME or ENDWhen a menu or submenu is visible, select the first or last command on the menu or submenu
139PAGE UP or PAGE DOWNScroll up or down in the selected gallery list
140CTRL+HOME orCTRL+ENDMove to the top or bottom of the selected gallery list
 
Access and use menus and toolbars with Shortcuts in Excel
141F10 or ALTSelect the menu bar or close an open menu and submenu at the same time
142TAB or SHIFT+TABWhen a toolbar is selected, select the next or previous button or menu on the toolbar
143CTRL+TAB orCTRL+SHIFT+TABWhen a toolbar is selected, select the next or previous toolbar
144ENTEROpen the selected menu, or perform the action for the selected button or command
145SHIFT+F10Display the shortcut menu for the selected item
146ALT+SPACEBARDisplay the Control menu for the Excel window
147ARROW DOWN or ARROW UPWhen a menu or submenu is open, select the next or previous command
148ARROW LEFT or ARROW RIGHTSelect the menu to the left or right. When a submenu is open, switch between the main menu and the submenu
149HOME or ENDSelect the first or last command on the menu or submenu
150ESCClose an open menu. When a submenu is open, close only the submenu
151CTRL+ARROW DOWNDisplay the full set of commands on a menu
152CTRL+7Show or hide the Standard toolbar
 
Use Excel dialog boxes with Shortcuts
153TABMove to the next option or option group
154SHIFT+TABMove to the previous option or option group
155CTRL+TAB orCTRL+PAGE DOWNSwitch to the next tab in a dialog box
156CTRL+SHIFT+TAB orCTRL+PAGE UPSwitch to the previous tab in a dialog box
157ARROW KEYSMove between options in an open drop-down list, or between options in a group of options
158SPACEBARPerform the action for the selected button, or select or clear the selected check box
159ALT+LETTERSelect an option, or select or clear a check box of underlined LETTER option
160ALT+ARROW DOWNOpen the selected drop-down list
161ENTERPerform the action for the default command button in the dialog box (the button with the bold outline, often the OK button)
162ESCCancel the command and close the dialog box
 
Working with Excel edit boxes within dialog boxes
163HOMEMove to the beginning of the entry
164ENDMove to the end of the entry
165ARROW LEFT or ARROW RIGHTMove one character to the left or right
166CTRL+ARROW LEFTMove one word to the left
167CTRL+ARROW RIGHTMove one word to the right
168SHIFT+ARROW LEFTSelect or unselect one character to the left
169SHIFT+ARROW RIGHTSelect or unselect one character to the right
170CTRL+SHIFT+ARROW LEFTSelect or unselect one word to the left
171CTRL+SHIFT+ARROW RIGHTSelect or unselect one word to the right
172SHIFT+HOMESelect from the insertion point to the beginning of the entry
173SHIFT+ENDSelect from the insertion point to the end of the entry
 
Use the Open, Save As, and Insert Picture dialog boxes
174ALT+1Go to the previous folder
175ALT+2Up One Level button: open the folder up one level above the open folder
176ALT+3Search the Web button: close the dialog box and open your Web search page
177ALT+4Delete button: delete the selected folder or file
178ALT+5Create New Folder button: create a new folder
179ALT+6Views button: switch among available folder views
180ALT+7 or ALT+LTools button: show the Tools menu
181SHIFT+F10Display a shortcut menu for a selected item such as a folder or file
182TABMove between options or areas in the dialog box
183F4 or ALT+IOpen the Look in list
184F5Refresh the file list
 
Keys for workbooks and worksheets
185CTRL+P orCTRL+SHIFT+F12Display the Print dialog box
186SHIFT+F11 orALT+SHIFT+F1Insert a new worksheet
187CTRL+PAGE DOWNMove to the next sheet in the workbook
188CTRL+PAGE UPMove to the previous sheet in the workbook
189SHIFT+CTRL+PAGE DOWNSelect the current and next sheet. To cancel selection of multiple sheets, press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP
190SHIFT+CTRL+PAGE UPSelect the current and previous sheet
191ALT+O H RRename the current sheet (Format menu, Sheet submenu, rename)
192ALT+E MMove or copy the current sheet (Edit menu, Move or Copy Sheet command)
193ALT+E LDelete the current sheet (Edit menu, Delete Sheet command)
194ARROW KEYSMove one cell up, down, left, or right
195CTRL+ARROW KEYSMove to the edge of the current data region
196HOMEMove to the beginning of the row
197CTRL+HOMEMove to the beginning of the worksheet
198CTRL+ENDMove to the last cell on the worksheet, in the bottom-most used row of the rightmost used column
199PAGE DOWNMove down one screen
200PAGE UPMove up one screen
201ALT+PAGE DOWNMove one screen to the right
202ALT+PAGE UPMove one screen to the left
203F6Switch to the next pane in a worksheet that has been split (Window menu, Split command)
204SHIFT+F6Switch to the previous pane in a worksheet that has been split
205CTRL+BACKSPACEScroll to display the active cell
206F5Display the Go To dialog box
207SHIFT+F5Display the Find dialog box
208SHIFT+F4Repeat the last Find action (same as Find Next)
209TABMove between unlocked cells on a protected worksheet
 
Excel Shortkeys to move within a selected range
210ENTERMove from top to bottom within the selected range
211SHIFT+ENTERMove from bottom to top within the selected range
212TABMove from left to right within the selected range. If cells in a single column are selected, move down
213SHIFT+TABMove from right to left within the selected range. If cells in a single column are selected, move up
214CTRL+PERIODMove clockwise to the next corner of the selected range
215CTRL+ALT+ARROW RIGHTIn nonadjacent selections, switch to the next selection to the right
216CTRL+ALT+ARROW LEFTSwitch to the next nonadjacent selection to the left
 
Use the Border tab in the Format Cells dialog box
217CTRL+1display this dialog box
218ALT+TApply or remove the top border
219ALT+BApply or remove the bottom border
220ALT+LApply or remove the left border
221ALT+RApply or remove the right border
222ALT+HIf cells in multiple rows are selected, apply or remove the horizontal divider
223ALT+VIf cells in multiple columns are selected, apply or remove the vertical divider
224ALT+DApply or remove the downward diagonal border
225ALT+UApply or remove the upward diagonal border
 
Working with the AutoFilter
226ALT+ARROW DOWNIn the cell that contains the drop-ARROW DOWN, displays the AutoFilter list for the current column
227ALT+ARROW UPCloses the AutoFilter list for the current column
228ARROW DOWNSelects the next item in the AutoFilter list
229ARROW UPSelects the previous item in the AutoFilter list
230HOMESelects the first item (All) in the AutoFilter list
231ENDSelects the last item in the AutoFilter list
232ENTERFilters the range based on the item selected from the AutoFilter list
 
Show, hide, and outline data
233ALT+SHIFT+ARROW RIGHTGroups rows or columns
234ALT+SHIFT+ARROW LEFTUngroups rows or columns
235CTRL+8Displays or hides the outline symbols
236CTRL+9Hides the selected rows
237CTRL+SHIFT+(Unhides any hidden rows within the selection
238CTRL+0Hides the selected columns
239CTRL+SHIFT+)Unhides any hidden columns within the selection

Source:



Free Web Hosting with Website Builder

0 comments: