First, select cells to graph, then use shortcut. First, select cells to graph, then use shortcut.Ĭreate chart in new worksheet = F11. Open Print window = Ctrl + P or Ctrl + F2 Working with Excel Worksheets and Workbooks Click in first cell, press and hold Ctrl key while clicking in other cells to be selected. Select non-adjacent cells = Ctrl + Click. Click in first cell, press and hold the Shift key, and click in last cell to be selected. Can also click the top left square of the worksheet to select all spreadsheet cells. Insert date and time = Ctrl + press the spacebar Ctrl + Shift + : Can fill to the right multiple cells in a column.ĭisplay Find and Replace (find tab) = Ctrl + Fĭisplay Find and Replace (replace tab) = Ctrl + H Select cell with data and highlight to select appropriate number of cells to the right to fill. 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. For use in cut and paste.Ĭut data = Ctrl + X. 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 + `.
KEYBOARD SHORTCUT EXCEL SHIFT CELLS DOWN SERIES
May be pressed multiple times to undo multiple actions.Įdit cell contents inside the cell = Double-click in a cell or Click + F2 &0183 &32 Use SHIFT+DOWN ARROW to highlight where you want the series to go must include the filled-in cells. Undo the last action = Ctrl + Z or Alt + Backspace. Also to remove squiggly lines after a Copy. Working With Data in CellsĬancel action or selection = ESC.
Especially useful when inserting rows or columns. &0183 &32 If I have a formula I want to fill down in a cell, say down to row 500, I can either double-click on the bottom right corner or go for a keyboard shortcut. Move to bottom right corner of worksheet = Ctrl + End Move to beginning of worksheet = Ctrl + Home Useful for finding cursor on large worksheet. (That's a shortcut.!)Ĭonfirm entry and move up = Shift + EnterĬonfirm entry and move left = Shift + Tabįind active cell = CTRL + Backspace.
You can change the direction of movement after pressing ENTER or SHIFT+ENTER: To left within the selected range (or up if only one column is selected) Right within the selected range (or down if only one column is selected) Previous pane in a worksheet that has been split Next pane in a worksheet that has been split (Window menu, Split
KEYBOARD SHORTCUT EXCEL SHIFT CELLS DOWN PLUS
keyboard.įor keyboard shortcuts in which you press two or more keys together, the keys to press are separated by a plus sign,įor shortcuts in which you press keys one after the other, the keys to press are separated by a comma,Ĭell on the worksheet, in the bottom-most used row of the rightmost used Keys on other layouts may not correspond exactly to the keys on a U.S. Keys for Moving and Scrolling on WorksheetsĪll shortcut keys are based on the U.S. Working with Databases and Lists] įor Working with PivotTables and PivotCharts] [ Keys for Workbooks] [ Keys for Printing and Previewing Spreadsheet Moving between Worksheet Panes, Worksheets, and Excel Shortcut Keys: Keys for Moving and Scrolling on a Worksheet
0 kommentar(er)
