F1 (Windows) or Fn F1 (macOS): Full or compact formula help (when you type a formula).Ctrl Shift Enter (Windows/Chrome OS) or Cmd Shift Enter (macOS): Insert an array formula (when you input a formula, type “=” first).Ctrl ~: Show all formulas in the sheet.These shortcuts come in handy when you type formulas in your spreadsheet: Ctrl Alt Shift M (Windows/Chrome OS) or Ctrl Cmd Shift M (macOS): Move focus out of the spreadsheet.Alt Shift K (Windows/Chrome OS) or Option Shift K (macOS): Display a list of all sheets.Alt Down/Up Arrow (Windows/Chrome OS) or Option Down/Up Arrow (macOS): If you have more than one sheet in the current file, use this shortcut to move to the next or previous sheet.Ctrl Backspace ( Windows/Chrome OS) or Cmd Backspace (macOS): Scroll back to the active cell.Ctrl End (Windows), Ctrl Search Right Arrow (Chrome OS), or Cmd Fn Right Arrow (macOS): Move to the end of the sheet.Ctrl Home (Windows), Ctrl Search Left Arrow (Chrome OS), or Cmd Fn Left Arrow (macOS): Move to the beginning of the sheet (A1).End (Windows), Search Right Arrow (Chrome OS), or Fn Right Arrow (macOS): Move to the end of a row.Home (Windows), Search Left Arrow (Chrome OS), or Fn Left Arrow (macOS): Move to the beginning of a row.Ctrl Up/Down Arrow (Windows/Chrome OS) or Ctrl Option Up/Down Arrow (macOS): Move to the first or last cell with data in a column.Ctrl Left/Right Arrow (Windows/Chrome OS) or Ctrl Option Left/Right Arrow (macOS): Move to the first or last cell with data in a row.Left/Right/Up/Down Arrow: Move one cell to the left, right, up, or down.You can move around your spreadsheet quickly without touching your mouse! With these helpful shortcuts, you can zip between rows and columns: Ctrl \ (Windows/Chrome OS) or Cmd \ (macOS): Clear all formatting from the selected cells.Ctrl Shift 6 (Windows/Chrome OS/macOS): Format as an exponent.Ctrl Shift 5 (Windows/Chrome OS/macOS): Format as a percentage.Ctrl Shift 4 (Windows/Chrome OS/macOS): Format as currency.Ctrl Shift 3 (Windows/Chrome OS/macOS): Format as a date.Ctrl Shift 2 (Windows/Chrome OS/macOS): Format as time.Ctrl Shift 1 (Windows/Chrome OS/macOS): Format as a decimal.Alt Shift 6 (Windows/Chrome OS) or Option Shift 6 (macOS): Remove a border from the selected cells.Alt Shift 7 (Windows/Chrome OS) or Cmd Shift 7 (macOS): Apply an outer border to the selected cells.Ctrl (Windows/Chrome OS) or Cmd (macOS): Insert the current date.Ctrl Shift R (Windows/Chrome OS) or Cmd Shift R (macOS): Right align a cell.Ctrl Shift L (Windows/Chrome OS) or Cmd Shift L (macOS): Left align a cell.Ctrl Shift E (Windows/Chrome OS) or Cmd Shift E (macOS): Center align a cell.Ctrl U (Windows/Chrome OS) or Cmd U (macOS): Underline.Ctrl I (Windows/Chrome OS) or Cmd I (macOS): Italicize.Ctrl B (Windows/Chrome OS) or Cmd B (macOS): Bold.These are the shortcuts you use to do things like italicize or bold text, or format cell data to exponents: ![]() Google Sheets has heaps of shortcuts you can use to format cells. Ctrl Alt Shift H (Windows/Chrome OS) or Cmd Option Shift H (macOS): Open the spreadsheet’s revision history.Shift F11 (Windows Only): Insert a new sheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |