speedsitediamond.blogg.se - Mac keyboard commands for google sheets

Mac keyboard commands for google sheets windows 7#
Mac keyboard commands for google sheets mac#

Ctrl + End (Windows), Ctrl + Search + Right Arrow (Chrome OS): For moving towards the end of the sheet.

Ctrl + Home (Windows), Ctrl + Search + Left Arrow (Chrome OS): Moving at the top of the sheet (A1).

End Button (Windows), Search + Right Arrow (Chrome OS): Going to the end of a row.

Home Button (Windows), Search + Left Arrow (Chrome OS): Going to the origin of a row.

Ctrl + Up/Down Arrow: For moving to the first or last cell (which has data) in a column.

Ctrl + Left/Right Arrow: To move to the first or last cell (which has data) in a row.

Left/Right/Up/Down Arrow: Move one cell to the left, right, up, or down.

Without touching your mouse, you can quickly move around in the spreadsheet through the shortcuts mentioned below.

Mac keyboard commands for google sheets windows 7#

Ctrl +\ (Windows/Chrome OS) or Cmd +\ (Mac OS): If you want to clear all formats from the selected cells.Īlso read: Every Windows 7 shortcut you must know To move around the spreadsheet.Ctrl + Shift + 6 (Windows/Chrome OS/Mac OS): Format as an exponent.Ctrl + Shift + 5 (Windows/Chrome OS/Mac OS): Format as a percentage.Ctrl + Shift + 4 (Windows/Chrome OS/Mac OS): Format as currency.Ctrl + Shift + 3 (Windows/Chrome OS/Mac OS): Format as a date.Ctrl + Shift + 2 (Windows/Chrome OS/Mac OS): Format as time.Ctrl + Shift + 1 (Windows/Chrome OS/Mac OS): Format as a decimal.Alt + Shift + 6 (Windows/Chrome OS) or Option + Shift + 6 (Mac OS): Getting rid of a border from the selected cells.Alt + Shift + 7 (Windows/Chrome OS) or Cmd + Shift + 7 (Mac OS): Applying an outer border to the cells which are selected.Ctrl + (Windows/Chrome OS) or Cmd + (Mac OS): For putting current date.Ctrl + Shift + R (Windows/Chrome OS) or Cmd + Shift + R (Mac OS): To align a cell in right.Ctrl + Shift + L (Windows/Chrome OS) or Cmd + Shift + L (Mac OS): To align a cell in left.Ctrl + Shift + E (Windows/Chrome OS) or Cmd + Shift + E (Mac OS): To align a cell in center.Ctrl + U (Windows/Chrome OS) or Cmd + U (Mac OS): Underlines the contents of the selected cell.Ctrl + I (Windows/Chrome OS) or Cmd + I (Mac OS): Italicises the contents of the selected cell.Ctrl + B (Windows and Chrome OS) or Cmd + B (Mac OS): Formats the contents of the selected cell to Bold.

The shortcuts mentioned below will help you to perform functions like italicising or bold text, or format cell data to exponents.

Mac keyboard commands for google sheets mac#

Cmd + Option + Shift + H: This takes you to the revision history of the spreadsheetĪlso read: Slack keyboard shortcuts for Windows, Linux and Mac Format Cells.

Cmd + H: Find and replace content in the sheet.

Cmd + F: When you want to find something in the sheet.

Shift + Space: When you want to select the entire row.

Cmd + Space: When you want to select the entire column.

Cmd + Shift + V: Past the values of the clipboard can be accessed.

Cmd + V: for pasting Clipboard contents to the sheet.

Cmd + X: This helps you to cut the selected cells to the Clipboard.

Cmd + C: This helps for copying the selected cells to the Clipboard.

Ctrl + Alt + Shift + H: This takes you to the revision history of the spreadsheet.

Shift + F11: Find and replace content in the sheet.

Ctrl + H: Find and replace in the sheet.

Ctrl + F: When you want to find something in the sheet.

Shift + Space: When you want to select the entire row.

Ctrl + Space: When you want to select the entire column.

Ctrl + Shift + V: Past the values of the clipboard can be accessed.

Ctrl + V: for pasting clipboard contents to the sheet.

Ctrl + X: This helps you to cut the selected cells to the Clipboard.

Ctrl + C: This helps for copying the selected cells to the Clipboard.

The shortcuts mentioned are available for Windows/Chrome OS and macOS. The shortcuts mentioned below will help you to perform everyday actions, like copying cells or selecting rows or columns. It is to be noted that this isn’t the complete list but includes those shortcuts which are generally used and will help you do your work quicker. The article contains a list of keyboard shortcuts that will help you with Google Sheets. No one would like to choose the long method when they have shortcuts available to them.