Okay, here we go, showing my ignorance again: What the heck is or are
Google Sheets? 😊
Jan
On 9/17/19, David Goldfield <david.goldfield@xxxxxxxxxxx> wrote:
How-To Geek - Tuesday, September 17, 2019 at 11:23 AMYou are invited to visit the moderator's Web site at WWW.DavidGoldfield.Info
All the Best Google Sheets Keyboard Shortcuts
No one likes to do things the hard way, which is why we have keyboard
shortcuts! We’re going to look at the shortcuts you can use in Google Sheets
to save yourself some time.
By no means is this a complete list of all keyboard shortcuts available in
Sheets<https://www.howtogeek.com/425040/the-beginners-guide-to-google-sheets/>.
We’ve limited our list to those that are more generally useful. There are
plenty more you can explore if you can’t find what you’re looking for in
this guide.
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<https://support.google.com/docs/answer/181110>.
General Program Actions
These keyboard shortcuts make it easier to perform common actions, like
copying cells or selecting rows or columns:
* Ctrl+C (Windows/Chrome OS) or Cmd+C (macOS): Copy the selected cells
to the Clipboard.
* Ctrl+X (Windows/Chrome OS) or Cmd+X (macOS): Cut the selected cells to
the Clipboard.
* Ctrl+V (Windows/Chrome OS) or Cmd+V (macOS): Paste the contents of the
Clipboard to the sheet.
* Ctrl+Shift+V (Windows/Chrome OS) or Cmd+Shift+V (macOS): Paste only
the values of the Clipboard.
* Ctrl+Space (Windows/Chrome OS) or Cmd+Space (macOS): Select the whole
column.
* Shift+Space (Windows/Chrome OS) or Shift+Space (macOS): Select the
whole row.
* Ctrl+A (Windows/Chrome OS) or Cmd+A (macOS): Select all of the cells.
* Ctrl+Z (Windows/Chrome OS) or Cmd+Z (macOS): Undo an action.
* Ctrl+Y (Windows/Chrome OS) or Cmd+Y (macOS): Redo an action.
* Ctrl+F (Windows/Chrome OS) or Cmd+F (macOS): Find in the sheet.
* Ctrl+H (Windows/Chrome OS) or Cmd+H (macOS): Find and replace in the
sheet.
* Shift+F11 (Windows Only): Insert a new sheet.
* Ctrl+Alt+Shift+H (Windows/Chrome OS) or Cmd+Option+Shift+H (macOS):
Open the spreadsheet’s revision history.
Format Cells
Google Sheets has heaps of shortcuts you can use to format cells. These are
the shortcuts you use to do things like italicize or bold text, or format
cell data to exponents:
* Ctrl+B (Windows/Chrome OS) or Cmd+B (macOS): Bold.
* Ctrl+I (Windows/Chrome OS) or Cmd+I (macOS): Italicize.
* Ctrl+U (Windows/Chrome OS) or Cmd+U (macOS): Underline.
* Ctrl+Shift+E (Windows/Chrome OS) or Cmd+Shift+E (macOS): Center align
a cell.
* Ctrl+Shift+L (Windows/Chrome OS) or Cmd+Shift+L (macOS): Left align a
cell
* Ctrl+Shift+R (Windows/Chrome OS) or Cmd+Shift+R (macOS): Right align a
cell.
* Ctrl+; (Windows/Chrome OS) or Cmd+; (macOS): Insert the current date.
* Alt+Shift+7 (Windows/Chrome OS) or Cmd+Shift+7 (macOS): Apply an outer
border to the selected cells.
* Alt+Shift+6 (Windows/Chrome OS) or Option+Shift+6 (macOS): Remove a
border from the selected cells.
* Ctrl+Shift+1 (Windows/Chrome OS/macOS): Format as a decimal.
* Ctrl+Shift+2 (Windows/Chrome OS/macOS): Format as time.
* Ctrl+Shift+3 (Windows/Chrome OS/macOS): Format as a date.
* Ctrl+Shift+4 (Windows/Chrome OS/macOS): Format as currency.
* Ctrl+Shift+5 (Windows/Chrome OS/macOS): Format as a percentage.
* Ctrl+Shift+6 (Windows/Chrome OS/macOS): Format as an exponent.
* Ctrl+\ (Windows/Chrome OS) or Cmd+\ (macOS): Clear all formatting from
the selected cells.
Move Around a Spreadsheet
You can move around your spreadsheet quickly without touching your mouse!
With these helpful shortcuts, you can zip between rows and columns:
* Left/Right/Up/Down Arrow: Move one cell to the left, right, up, or
down.
* 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.
* 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.
* Home (Windows), Search+Left Arrow (Chrome OS), or Fn+Left Arrow
(macOS): Move to the beginning of a row.
* End (Windows), Search+Right Arrow (Chrome OS), or Fn+Right Arrow
(macOS): Move to the end of a row.
* Ctrl+Home (Windows), Ctrl+Search+Left Arrow (Chrome OS), or
Cmd+Fn+Left Arrow (macOS): Move to the beginning of the sheet (A1).
* Ctrl+End (Windows), Ctrl+Search+Right Arrow (Chrome OS), or
Cmd+Fn+Right Arrow (macOS): Move to the end of the sheet.
* Ctrl+Backspace (Windows/Chrome OS) or Cmd+Backspace (macOS): Scroll
back to the active cell.
* 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.
* Alt+Shift+K (Windows/Chrome OS) or Option+Shift+K (macOS): Display a
list of all sheets.
* Ctrl+Alt+Shift+M (Windows/Chrome OS) or Ctrl+Cmd+Shift+M (macOS): Move
focus out of the spreadsheet.
Use Formulas
These shortcuts come in handy when you type formulas in your spreadsheet:
* Ctrl+~: Show all formulas in the sheet.
* Ctrl+Shift+Enter (Windows/Chrome OS) or Cmd+Shift+Enter (macOS):
Insert an array formula (when you input a formula, type “=” first).
* F1 (Windows) or Fn+F1 (macOS): Full or compact formula help (when you
type a formula).
* F9 (Windows) or Fn+F9 (macOS): Toggle formula result previews (when
you type a formula).
Add or Change Rows and Columns on a PC
If you want to duplicate a cell’s data into a selected range, hide or delete
columns or rows, follow the shortcuts below.
Because Google likes to make things complicated, there are some
browser-specific commands for these keyboard shortcuts if you use Chrome. If
you are, just follow the commands, and then add the “Chrome” shortcut to
complete the browser-specific commands:
* Ctrl+D: Duplicate the data from the first column of the selected range
down.
* Ctrl+R: Duplicate the data from the first row of the selected range to
the right.
* Ctrl+Enter: Duplicate the data from the first cell of the selected
range into the other cells.
* Ctrl+Alt+9: Hide rows.
* Ctrl+Shift+9: Unhide rows.
* Ctrl+Alt+0: Hide columns.
* Ctrl+Shift+0: Unhide columns.
* Alt+I, then R (Chrome) or Alt+Shift+I, then R (Other browsers): Insert
rows above.
* Alt+I, then W (Chrome) or Alt+Shift+I, then W (Other browsers): Insert
rows below.
* Alt+I, then C (Chrome) or Alt+Shift+I, then C (Other browsers): Insert
columns to the left.
* Alt+I, then O (Chrome) or Alt+Shift+I, then O (Other browsers): Insert
columns to the right.
* Alt+E, then D (Chrome) or Alt+Shift+E, then D (Other browsers): Delete
rows.
* Alt+E, then E (Chrome) or Alt+Shift+E, then E (Other browsers): Delete
columns.
Add or Change Rows and Columns on macOS
If you use a Mac, follow these shortcuts to add, remove, or change rows and
columns in Google Sheets:
* Cmd+D: Duplicate the data from the first column of the selected range
down.
* Cmd+R: Duplicate the data from the first row of selected range to the
right.
* Cmd+Enter: Duplicate the data from the first cell of the selected
range into the other cells.
* Cmd+Option+9: Hide a row.
* Cmd+Shift+9: Unhide a row.
* Cmd+Option+0: Hide a column.
* Cmd+Shift+0: Unhide a column.
* Ctrl+Option+I, then R: Insert rows above.
* Ctrl+Option+I, then W: Insert rows below.
* Ctrl+Option+I, then C: Insert columns to the left.
* Ctrl+Option+I, then O: Insert columns to the right.
* Ctrl+Option+E, then D: Delete rows.
* Ctrl+Option+E, then E: Delete columns.
Access the Menus on a PC
You can use the following shortcuts on a PC to access each menu item. Note
that most are slightly different in Chrome:
* Alt+F (Chrome) or Alt+Shift+F (Other browsers): Access the File menu.
* Alt+E (Chrome) or Alt+Shift+E (Other browsers): Access the Edit menu.
* Alt+V (Chrome) or Alt+Shift+V (Other browsers): Access the View menu.
* Alt+I (Chrome) or Alt+Shift+I (Other browsers): Access the Insert
menu.
* Alt+O (Chrome) or Alt+Shift+O (Other browsers): Access the Format
menu.
* Alt+T (Chrome) or Alt+Shift+T (Other browsers): Access the Tools
menu.
* Alt+H (Chrome) or Alt+Shift+H (Other browsers): Access the Help menu.
* Alt+A (Chrome) or Alt+Shift+A (Other browsers): Access the
Accessibility menu (present when screen reader support is enabled).
* Shift+Right-click: Show your browser’s context menu (by default,
Google Sheets overrides your browser’s context menu with its own).
* Ctrl+Shift+F: Switch to Compact mode (hide the menus).
Access the Menus on macOS
You can use the following shortcuts on a Mac to access each menu item:
* Ctrl+Option+F: Open the File menu.
* Ctrl+Option+E: Open the Edit menu.
* Ctrl+Option+V: Open the View menu.
* Ctrl+Option+I: Open the Insert menu.
* Ctrl+Option+O: Open the Format menu.
* Ctrl+Option+T: Open the Tools menu.
* Ctrl+Option+H: Open the Help menu.
* Ctrl+Option+A: Open the Accessibility menu (present when screen reader
support is enabled).
* Cmd+Option+Shift+K: Open the Input Tools menu (available in all
documents that contain non-Latin languages).
* Cmd+Shift+F: Switch to Compact mode (hide the menus).
* Shift+Right-click: Show the browser’s context menu (by default, Google
Sheets overrides your browser’s context menu with its own).
Access Microsoft Excel Keyboard Shortcuts
Google<https://gsuiteupdates.googleblog.com/2019/05/new-sheets-features-may.html.>
As of May 2019, Google allows you to use familiar keyboard shortcuts from
other well-known spreadsheet programs. You do have to enable this option,
but here’s how:
From your Google Sheets spreadsheet, click Help > Keyboard shortcuts.
Alternatively, press Ctrl+/ (Windows/Chrome OS) or Cmd+/ (macOS).
At the bottom of the window, toggle-on “Enable compatible spreadsheet
shortcuts.”
That’s all there is to it! All the shortcuts you’ve learned are now
available in Google Sheets. To see a complete list, click “View compatible
shortcuts” next to the toggle switch.
________________________________
Hopefully, all these shortcuts will make your work a lot easier! If you
didn’t find the one you need, head over to the Google support
page<https://support.google.com/docs/answer/181110> for more.
https://www.howtogeek.com/440067/all-the-best-google-sheets-keyboard-shortcuts/
David Goldfield
Assistive Technology Specialist
Feel free to visit my Web site
WWW.DavidGoldfield.info<http://WWW.DavidGoldfield.info>
