![]() 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.Ctrl+H (Windows/Chrome OS) or Cmd+H (macOS): Find and replace in the sheet.Ctrl+F (Windows/Chrome OS) or Cmd+F (macOS): Find in the sheet.Ctrl+Y (Windows/Chrome OS) or Cmd+Y (macOS): Redo an action.Ctrl+Z (Windows/Chrome OS) or Cmd+Z (macOS): Undo an action.Ctrl+A (Windows/Chrome OS) or Cmd+A (macOS): Select all of the cells.Shift+Space (Windows/Chrome OS) or Shift+Space (macOS): Select the whole row.Ctrl+Space (Windows/Chrome OS) or Cmd+Space (macOS): Select the whole column.Ctrl+Shift+V (Windows/Chrome OS) or Cmd+Shift+V (macOS): Paste only the values of the Clipboard.Ctrl+V (Windows/Chrome OS) or Cmd+V (macOS): Paste the contents of the Clipboard to the sheet.Ctrl+X (Windows/Chrome OS) or Cmd+X (macOS): Cut the selected cells to the Clipboard.Ctrl+C (Windows/Chrome OS) or Cmd+C (macOS): Copy the selected cells to the Clipboard.These keyboard shortcuts make it easier to perform common actions, like copying cells or selecting rows or columns:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |