To view this PDF file, your phone must have a PDF reader application.
Move the next sheet between Excel worksheet in the same Excel documentĬreate a formula to sum all of the above cellĬlick on the download button below to download the Microsoft Excel Shortcut Keys PDF. Page Up Move the previous sheet between Excel worksheet in the same Excelīeing up print dialog box to being printing Selects the current region around the active cell.īring out the print dialog box to being prating Switches between showing Excel formulas or their values in cells. Puts a strikethrough all cells in the highlighted section.Ĭhanges between displaying cell values or formulas in the worksheet. Underlines all cells in highlighted section. Puts italics all cells in the highlighted section. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color. Pastes everything copied onto the clipboard.Īfter a name is created, F3 will paste names. While the arrow keys are used to navigate around the worksheet.
Underlines all cells in the highlighted section. A Few Indispensable Keyboard Shortcuts for Moving Quickly Around Excel 1) CTRL + Arrow Key.
Highlights all text to the right of the cursor.Įxtends the highlighted area up one cell.Įxtends the highlighted area down one cell.Įxtends the highlighted area left one character.Įxtends the highlighted area right one character.Ĭhanges the format of the selected cells.īolds all cells in the highlighted section.Ĭuts all cells in the highlighted section. Highlights all text to the left of the cursor. In a single column, highlights all cells above that are selected. Move to last cell with text on the worksheet. Then press Ctrl+R to fill them with the contents of the original cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Fills the cell to the right with the contents of the selected cell. Can fill to the right multiple cells in a column.Puts italics on all cells in the highlighted section.įill right. Select cell with data and highlight to select appropriate number of cells to the right to fill. Keyboard shortcuts in Excel are commonly accessed by using the ALT, Ctrl, Shift, Function key and Window key. Miscellaneous Shortcut Keys Opens a Workbook, CTRL + O COMMAND + O Reverts to the Home tab, Alt + H Saves all of the data in the worksheet, CTRL + S. Then press Ctrl + D.įill to the right = Ctrl + R.
Select (highlight) cell with data and desired number of cells below it. For use in cut and paste.įill down = Ctrl + D. Alt + Enter: To insert a new line character in a cell without moving to another cell. Ctrl + X: To cut selected cells’ contents and move them to Clipboard. Ctrl + V: To paste content from Clipboard into selected cells. First, let’s take a look at some general keyboard shortcuts for manipulating workbooks, getting help, and a few other interface-related actions. For use in cut and paste.Ĭut data = Ctrl + X. Some of the important shortcut keys for MS Excel are: Ctrl + C: To copy the selected cell’s content to Clipboard.
The left apostrophe key is located to the left of the number 1 on many keyboards.Ĭopy to clipboard = Ctrl + C. Toggle between cell values and formulas = Ctrl + `. May be pressed multiple times to undo multiple actions.Įdit cell contents inside the cell = Double-click in a cell or Click + F2 Undo the last action = Ctrl + Z or Alt + Backspace. Also to remove squiggly lines after a Copy.