Excel | |||||
Microsoft ExcelExcel Worksheet Keys and Keyword Shortcuts | |||||
| Microsoft Excel
Quick guide of tips and tricks for Excel. Keyword shortcuts to format, navigation, selection, data, formula and other functions. | |||||
| Keyboard shortcuts for Microsoft Excel | |||||
Keys for Formatting How to format cells, rows and columns? Keystroke = Function [Ctrl]B = Bold the selection [Ctrl]I = Italicize the selection [Ctrl]U = Underline the selection [Ctrl]5 = Strike through the selection [Alt] and ' = Open the Style dialog box [Ctrl]1 = Open the Format Cells dialog box [Ctrl][Shift]~ = Apply General format [Ctrl][Shift]$ = Apply Currency format [Ctrl][Shift]% = Apply percentage format [Ctrl][Shift]# = Apply Date format [Ctrl][Shift]@ = Apply Time format [Ctrl][Shift]! = Apply Number format [Ctrl][Shift]^ = Apply Exponential number format [Ctrl][Shift]& = Apply an outline border to selection [Ctrl][Shift] and _ = Remove outline border from selection | Navigation [Ctrl][Page Down] Move to the next worksheet in a workbook [Ctrl][Page Up] Move to the previous worksheet in a workbook = [Ctrl][F6] Cycle between open workbooks Arrow keys = Move one cell up, down, left, or right [Ctrl] and an arrow key = Move to the edge of the data region = [Home] = Move to the beginning of a row = [Ctrl][Home] = Move to the beginning of a worksheet = [Ctrl][End] = Move to the end of the used portion of a worksheet = [F6] = Move between panes in a split worksheet = [Ctrl][Backspace] = Display the active cell = [Enter = ]Move down a cell in a selected range = [Shift][Enter] = Move up a cell in a selected range = [Shift][Tab] = Move one cell to the left in a selected range = [Ctrl] and [.] (period) = Move from corner cell to corner cell in a selected range = | Selection Selection techniques Select a row = [Shift][Spacebar] Select a column = [Ctrl][Spacebar] Select an entire worksheet = [Ctrl]A Select from current cell(s) to the beginning of the row = [Shift][Home] Select from current cell(s) to last used cell in row = [Shift][End][Enter] Select from current cell(s) to the beginning of the worksheet = [Ctrl][Shift][Home] Select from current cell(s) to the end of the used portion of a worksheet = [Ctrl][Shift][End] Select the data region surrounding the active cell = [Ctrl] and * Select all cells that contain a comment = [Ctrl][Shift]O Select cells that a selected formula directly references = [Ctrl] and [ Select formulas that directly reference the active cell = [Ctrl] and ] | Workbook Workbook basics Open a workbook = [Ctrl]O Create a new workbook = [Ctrl]N Save a workbook = [Ctrl]S Open the Save As dialog box = [F12] Print a workbook = [Ctrl]P Close a workbook = [Ctrl]W Insert a new worksheet = [Shift][F11] Hide selected rows = [Ctrl]9 Display hidden rows in selection = [Ctrl][Shift]9 Hide selected columns = [Ctrl]0 Display hidden columns in selection = [Ctrl][Shift]0 Open the Find tab of the Find And Replace dialog box = [Ctrl]F Open the Replace tab of the Find And Replace dialog box = [Ctrl]H Run a spelling check on a worksheet or selected text = [F7] | Data Working with data. Import and export files. Complete an entry and move to the next cell = [Enter] Insert a new line within a cell = [Alt][Enter] Enable editing within a cell = [F2] Fill selected cells with an entry you type = [Ctrl][Enter] Fill data down through selected cells = [Ctrl]D Fill data through selected cells to the right = [Ctrl]R Create a name = [Ctrl][F3] Insert a hyperlink = [Ctrl]K Insert the current date = [Ctrl] and ; (semicolon) Insert the current time = [Ctrl] and : (colon) Cut the selected text or objects to the Clipboard = [Ctrl]X Copy the selected text or objects to the Clipboard = [Ctrl]C Paste the contents of the Clipboard = [Ctrl]V Repeat last action = [Ctrl]Y Undo last edit = [Ctrl]Z Delete from the insertion point to the end of the line = Ctrl][Delete] Add blank cells = [Ctrl][Shift]+ Delete selected cells = [Ctrl]- (hyphen) Create a chart from a range of data = [F11] | Formula Formula shortcuts Begin a formula = = Enter a formula as an array = [Ctrl][Shift][Enter] Display the Insert Function dialog box (Paste Function in Excel ) = [Shift][F3] Paste a defined name into a formula = [F3] Insert a SUM AutoSum formula = [Alt]= Display the Function Arguments dialog box = Type a function in the Formula bar and press [Ctrl]A Copy the value from the cell above the current cell into the current cell = [Ctrl][Shift] and " Copy a formula from the cell above the current cell into the current cell = [Ctrl] and ' Toggle between display of formulas and cell values = [Ctrl] and ` Calculate values for sheets in all open workbooks = [F9] Calculate values for the current worksheet = [Shift][F9] Cancel an entry you're making in a cell or in the formula bar = [Esc] |