cosmicbta.blogg.se

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 + `. 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. Working With Data in CellsĬancel action or selection = ESC. Especially useful when inserting rows or columns. 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. To look for a shortcut, use Ctrl + F to keyword search this webpage.To select multiple cells, click in the first cell, hold the mouse button, and drag across the other cells. Some shortcut descriptions refer to a "selected" cell.Just hold down one key while pressing the other key. The + in the description means "and" - not the + key.Read our disclosure policy to learn more. ○ This tutorial contains affiliate links.