giftprofiles.blogg.se - Mac shortcuts for excel

#MAC SHORTCUTS FOR EXCEL ZIP#

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.

#MAC SHORTCUTS FOR EXCEL ZIP#

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: To open a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows and Chrome OS), Cmd + / (macOS) If you want to see the complete list, check out the Google Sheets support page.