Google Sheets is the best spreadsheet program to optimize workflows, improve productivity, save time, and boost your revenue. It boasts hundreds of keyboard shortcuts to take your computing and presentation skills to the next level.
Keyboard shortcuts allow you to perform various tasks quickly.
They are the best way to work smarter in Google Sheets.
Here is an ultimate guide to lifesaving Google Sheets keyboard shortcuts.
Let us discuss all Google Sheets keyboard shortcuts from various categories. Note that we will discuss keyboard shortcuts for Windows, Mac, and Chrome OS. So, make sure to read the article till the end.
Now, without any further ado, let’s begin.
How can I view Keyboard Shortcuts compatible with Google Sheets?
Google Sheets uses hundreds of combinations of keys to perform various tasks. For example, the “CTRL + C” keyboard shortcut to copy the contents of a spreadsheet.
To view all of the compatible keyboard shortcuts in Google Sheets, here are the steps:
- Open a new Google Sheet by clicking here
- Hover to the main menu
- Click on the “Help” button
- Choose the last option, named “Keyboard shortcuts“, from the popup
- A new dialog box will appear, as shown below
You will see a massive list of keyboard shortcuts divided into various categories. You will be taken to that list section when you click on any of the categories on the left side of the dialog box.
Additionally, make use of the search tool that appears at the top of the dialog box to find a keyboard shortcut to perform a specific task.
At the bottom, you will find the option to enable the compatible spreadsheet keyboard shortcuts (Read the following section to know more). Users can also view it separately by clicking the View Compatible Shortcuts button.
Note that you can also view all the keyboard shortcuts compatible with Google Sheets by pressing “CTRL + /”.
In the following section of the article, we will discuss each category of Google Sheets keyboard shortcuts and learn to make the most out of them.
What are Compatible Keyboard Shortcuts
Google Sheets doesn’t allow users to create their unique combination of keyboard shortcuts to perform various tasks. The option for custom keyboard shortcuts has been discontinued in the last few years.
But don’t worry!
Compatible Keyboard Shortcuts are your way to go.
They are nothing but the keyboard shortcuts available within the popular spreadsheet program Microsoft Excel. There are a total of 134 of them.
Few of the compatible keyboard shortcuts are alternatives to standard ones.
Here are the steps to enable compatible keyboard shortcuts:
- Open a new Google Sheet by clicking here
- Hover to the main menu and click on the “Help” button
- Select “Keyboard shortcuts” from the popup
- A new dialog box will open
- At the bottom, toggle the switch after the “Enable compatible spreadsheet shortcuts” option
- Close the dialog box by pressing the “X” button on the upper-rightmost corner of the screen
That’s it. Now, you can use the compatible keyboard shortcuts (those are similar to Microsoft Excel) in Google Sheets.
All Google Sheets Keyboard Shortcuts of 2024
Here is a list of keyboard shortcuts compatible with Google Sheets. There are a total of 122 keyboard shortcuts in this file.
Few of them are common, and most are specific to Google Sheets.
You can view the entire Google Sheets spreadsheet through the following link:
It is divided into three columns to display the keyboard shortcuts for Windows, Mac, and Chrome OS computers. While scrolling down, you will notice the light green color highlights the categories.
It is a printable Google Sheet which can be pinned to your office desk.
Let us discuss all the above shortcuts in detail in the following section of the article.
Common Action Keyboard Shortcuts in Google Sheets
The following list includes keyboard shortcuts for the most common actions in Google Sheets. For example, selecting an entire row or column, undoing the edits, finding and replacing the cell content, opening a new Google Sheet, etc.
Learning these shortcuts will surely boost your overall computing skills in Google Sheets.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Select column | Ctrl + Space | Ctrl + Space | Ctrl + Space |
| Select row | Shift + Space | Shift + Space | Shift + Space |
| Select all | Ctrl + a Ctrl + Shift + Space | ⌘ + a ⌘ + Shift + Space | Ctrl + a |
| Undo | Ctrl + z | ⌘ + z | Ctrl + z |
| Redo | Ctrl + y Ctrl + Shift + z F4 | ⌘ + y ⌘ + Shift + z Fn + F4 | Ctrl + y Ctrl + Shift + z |
| Find | Ctrl + f | ⌘ + f | Ctrl + f |
| Find and replace | Ctrl + h | ⌘ + Shift + h | Ctrl + h |
| Fill range | Ctrl + Enter | ⌘ + Enter | Ctrl + Enter |
| Fill down | Ctrl + d | ⌘ + d | Ctrl + d |
| Fill right | Ctrl + r | ⌘ + r | Ctrl + r |
| Save(every change is saved automatically in Drive) | Ctrl + s | ⌘ + s | Ctrl + s |
| Open | Ctrl + o | ⌘ + o | Ctrl + o |
| Ctrl + p | ⌘ + p | Ctrl + p | |
| Copy | Ctrl + c | ⌘ + c | Ctrl + c |
| Cut | Ctrl + x | ⌘ + x | Ctrl + x |
| Paste | Ctrl + v | ⌘ + v | Ctrl + v |
| Paste values only | Ctrl + Shift + v | ⌘ + Shift + v | Ctrl + Shift + v |
| Show common keyboard shortcuts | Ctrl + / | ⌘ + / | Ctrl + / |
| Insert new sheet | Shift + F11 | Shift + Fn + F11 | |
| Compact controls | Ctrl + Shift + f | Ctrl + Shift + f | Ctrl + Shift + f |
| Input tools on/off(available in spreadsheets in non-Latin languages) | Ctrl + Shift + k | ⌘ + Shift + k | Ctrl + Shift + k |
| Select input tools | Ctrl + Alt + Shift + k | ⌘ + Option + Shift + k | Ctrl + Alt + Shift + k |
| Tool finder (formerly Search the menus) | Alt + / | Option + / | Alt + / |
| Rename sheet | Alt + 1 | ||
| Select current region around selected cell | ⌘ + Shift + * Ctrl + Shift + * | ||
| Displays or hides the menus | ⌘ + Option + R Ctrl + Shift + F |
The keyboard shortcuts above are helpful for day-to-day operations, copying and pasting values, and selecting the entire table.
Keyboard Shortcuts to Format Cells like a Pro
Preparing an excellent report in Google Sheets starts with correctly formatting the entire spreadsheet.
Though most of the formatting tools are directly accessible via the toolbar that sits below the main menu, knowing the following keyboard shortcuts will enhance your efficiency.
The following shortcuts allow users to change the font styles quickly.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Bold | Ctrl + b | ⌘ + b ⌘ + 2 Ctrl + 2 | Ctrl + b |
| Underline | Ctrl + u | ⌘ + u ⌘ + 4 Ctrl + 4 | Ctrl + u |
| Italic | Ctrl + i | ⌘ + i ⌘ + 3 Ctrl + 3 | Ctrl + i |
| Strikethrough | Alt + Shift + 5 | ⌘ + Shift + x ⌘ + 5 Ctrl + 5 | Alt + Shift + 5 |
| Center align | Ctrl + Shift + e | ⌘ + Shift + e | Ctrl + Shift + e |
| Left align | Ctrl + Shift + l | ⌘ + Shift + l | Ctrl + Shift + l |
| Right align | Ctrl + Shift + r | ⌘ + Shift + r | Ctrl + Shift + r |
| Apply top border | Alt + Shift + 1 | Option + Shift + 1 | Alt + Shift + 1 |
| Apply right border | Alt + Shift + 2 | Option + Shift + 2 | Alt + Shift + 2 |
| Apply bottom border | Alt + Shift + 3 | Option + Shift + 3 | Alt + Shift + 3 |
| Apply left border | Alt + Shift + 4 | Option + Shift + 4 | Alt + Shift + 4 |
| Remove borders | Alt + Shift + 6 | Option + Shift + 6 | Alt + Shift + 6 |
| Apply outer border | Alt + Shift + 7 Ctrl + Shift + 7 | Option + Shift + 7 ⌘ + Shift + 7 Ctrl + Shift + 7 | Alt + Shift + 7 Ctrl + Shift + 7 |
| Insert link | Ctrl + k | ⌘ + k | Ctrl + k |
| Insert time | Ctrl + Shift + ; | ⌘ + Shift + ; | Ctrl + Shift + ; |
| Insert date | Ctrl + ; | ⌘ + ; | Ctrl + ; |
| Insert date and time | Ctrl + Alt + Shift + ; | ⌘ + Option + Shift + ; | Ctrl + Alt + Shift + ; |
| Format as decimal | Ctrl + Shift + 1 | Ctrl + Shift + 1 | Ctrl + Shift + 1 |
| Format as time | Ctrl + Shift + 2 | Ctrl + Shift + 2 | Ctrl + Shift + 2 |
| Format as date | Ctrl + Shift + 3 | Ctrl + Shift + 3 | Ctrl + Shift + 3 |
| Format as currency | Ctrl + Shift + 4 | Ctrl + Shift + 4 | Ctrl + Shift + 4 |
| Format as percentage | Ctrl + Shift + 5 | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
| Format as exponent | Ctrl + Shift + 6 | Ctrl + Shift + 6 | Ctrl + Shift + 6 |
| Clear formatting | Ctrl + \ | ⌘ + \ | Ctrl + \ |
Apart from changing the font styles, you can insert or remove borders and change the cell content formatting to time, date, currency, percentage, etc.
Note that the above keyboard shortcuts are lengthy but easy to remember.
If you are the one who is responsible for preparing the monthly and annual reports, the above shortcuts are for you.
Keyboard Shortcuts for Navigating Swiftly through the Spreadsheet
Here is a list of shortcuts that help users improve their data analysis skills by quickly navigating through the datasets.
Suppose you are giving a presentation to your colleagues, and while explaining the annual sales report, you get into the middle of the table. Now, you need to return to the table’s first row.
Instead of scrolling to the top using your mouse, simply press the “CTRL + Home” on your keyboard to immediately return to the beginning of the table.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Move to beginning of row | Home | Fn + Left Arrow | Search + Left Arrow |
| Move to beginning of sheet | Ctrl + Home | ⌘ + Fn + Left Arrow | Ctrl + Search + Left Arrow |
| Move to end of row | End | Fn + Right Arrow | Search + Right Arrow |
| Move to end of sheet | Ctrl + End | ⌘ + Fn + Right Arrow | Ctrl + Search + Right Arrow |
| Scroll to active cell | Ctrl + Backspace | ⌘ + Backspace | Ctrl + Backspace |
| Move to next sheet | Alt + Down Arrow | Option + Down Arrow MacBook: Option + Right Arrow | Ctrl + Shift + Search + Down Arrow |
| Move to previous sheet | Alt + Up Arrow | Option + Up Arrow MacBook: Option + Left Arrow | Ctrl + Shift + Search + Up Arrow |
| Display list of sheets | Alt + Shift + k | Option + Shift + k | Alt + Shift + k |
| Open hyperlink | Alt + Enter | Option + Enter | Alt + Enter |
| Open Explore | Ctrl + Alt + Shift + i | ⌘ + Option + Shift + i | Ctrl + Alt + Shift + i |
| Go to side panel | Ctrl + Alt + . Ctrl + Alt + , | ⌘ + Option + . ⌘ + Option + , | Alt + Shift + . Alt + Shift + , |
| Move focus out of spreadsheet | Ctrl + Alt + Shift + m | Ctrl + ⌘ + Shift + m | Ctrl + Alt + Shift + m |
| Move to quicksum(when a range of cells is selected) | Alt + Shift + q | Option + Shift + q | Alt + Shift + q |
| Move focus to popup(for links, bookmarks, and images) | holding Ctrl + Alt, press e then p | holding Ctrl + ⌘, press e then p | holding Ctrl + Alt, press e then p |
| Open drop-down menu on filtered cell | Ctrl + Alt + r | Ctrl + ⌘ + r | Ctrl + Alt + r |
| Open revision history | Ctrl + Alt + Shift + h | ⌘ + Option + Shift + h | Ctrl + Alt + Shift + h |
| Close drawing editor | Shift + Esc | ⌘ + Esc Shift + Esc | Ctrl + Esc Shift + Esc |
| Show “Go to range” dialog | Ctrl + G | ||
| Find and replace with Find tab selected | Ctrl + F |
The above keyboard shortcuts allow you to move through the Google Sheets spreadsheets quickly. You can also open a hyperlink within a second.
Other useful keyboard shortcuts in the above table are “CTRL + ALT + R”, which lets you open sort and filter options on a filtered cell and “SHIFT + ESC” to close a popup or dialog box.
You will be able to master the above keyboard shortcuts with practice. They will surely be helpful in the long run.
Keyboard Shortcuts to Insert and Edit Comments
Google Sheets is the top spreadsheet program for team collaboration. It comes with various tools, such as live chat and comments, to allow users to collaborate in real-time.
Here is a list of keyboard shortcuts to insert and edit comments in Google Sheets:
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Insert/edit note | Shift + F2 | Shift + F2 | Shift + Search + 2 |
| Insert/edit comment | Ctrl + Alt + m | ⌘ + Option + m | Ctrl + Alt + m |
| Open comment discussion thread | Ctrl + Alt + Shift + a | ⌘ + Option + Shift + a | Ctrl + Alt + Shift + a |
| Enter current comment | holding Ctrl + Alt, press e then c | holding Ctrl + ⌘, press e then c | holding Ctrl + Alt, press e then c |
| Move to next comment | holding Ctrl + Alt, press n then c | holding Ctrl + ⌘, press n then c | holding Ctrl + Alt, press n then c |
| Move to previous comment | holding Ctrl + Alt, press p then c | holding Ctrl + ⌘, press p then c | holding Ctrl + Alt, press p then c |
| Reply to current selected comment | R | R | R |
| Move to next selected comment | J | J | J |
| Move to previous selected comment | K | K | K |
| Resolve current selected comment | E | E | E |
| Exit current comment | U | U | U |
The above keyboard shortcuts aim to improve your communication speed. You can quickly reply, resolve or delete the selected comment.
To open the comment discussion thread, use the keyboard shortcut “CTRL + ALT + SHIFT + A”.
These handful of keyboard shortcuts are worth remembering if your team largely depends upon Google Sheets for the company data organization and analysis.
All of them are easy to remember and pretty straightforward.
Keyboard Shortcuts to Navigate through the Main Menu
Google Sheets is an easy-to-use spreadsheet program. It has a short learning curve. Anyone can master this program within a few days.
Thanks to its super intuitive user interface. Almost all of the tools and functions can be accessed quickly using the main menu and toolbar section.
In other words, you will often use the main menu to access the tools and toolbar section to format the table.
We have compiled a list of keyboard shortcuts to access the main menu in Google Sheets quickly.
Note that the following shortcuts vary depending on the browser type. They mostly remain fully compatible with the Google Chrome browser. However, in the case of others, they may vary and sometimes won’t work as expected.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| File menu | in Google Chrome: Alt + f other browsers: Alt + Shift + f | Ctrl + Option + f | Alt + f |
| Edit menu | in Google Chrome: Alt + e other browsers: Alt + Shift + e | Ctrl + Option + e | Alt + e |
| View menu | in Google Chrome: Alt + v other browsers: Alt + Shift + v | Ctrl + Option + v | Alt + v |
| Insert menu | in Google Chrome: Alt + i other browsers: Alt + Shift + i | Ctrl + Option + i | Alt + i |
| Format menu | in Google Chrome: Alt + o other browsers: Alt + Shift + o | Ctrl + Option + o | Alt + o |
| Data menu | in Google Chrome: Alt + d other browsers: Alt + Shift + d | Ctrl + Option + d | Alt + d |
| Tools menu | in Google Chrome: Alt + t other browsers: Alt + Shift + t | Ctrl + Option + t | Alt + t |
| Open insert menu | Ctrl + Alt + Shift + = Ctrl + Alt + = (with cells selected) | ⌘ + Option + = (with cells selected) | Ctrl + Alt + = (with cells selected) |
| Open delete menu | Ctrl + Alt + – (with cells selected) | ⌘ + Option + – (with cells selected) | Ctrl + Alt + – (with cells selected) |
| Form menu(present when the spreadsheet is connected to a form) | in Google Chrome: Alt + m other browsers: Alt + Shift + m | Ctrl + Option + m | Alt + m |
| Add-ons menu | in Google Chrome: Alt + n other browsers: Alt + Shift + n | Ctrl + Option + n | Alt + n |
| Help menu | in Google Chrome: Alt + h other browsers: Alt + Shift + h | Ctrl + Option + h | Alt + h |
| Accessibility menu(present when screen reader support is enabled) | in Google Chrome: Alt + a other browsers: Alt + Shift + a | Ctrl + Option + a | Alt + a |
| Sheet menu(copy, delete, and other sheet actions) | Alt + Shift + s | Option + Shift + s | Ctrl + Shift + s |
| Context menu | Ctrl + Shift + \ Shift + F10 | ⌘ + Shift + \ Shift + F10 | Ctrl + Shift + \ Shift + F10 |
With the above keyboard shortcuts, you can quickly access all the tabs from the main menu, including File, Edit, View, Insert, Format, Data and Tools. In case you are stuck somewhere, simply press the “ALT + H” button to access the Help menu.
Keyboard Shortcuts to Manipulate Rows and Columns
These are yet another set of commands for pros at Google Sheets. They allow users to insert rows and columns at desired locations quickly.
You can also delete a row or column instantly using the following shortcuts.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Insert rows above | Ctrl + Alt + Shift + = Ctrl + Alt + = (with rows selected) in Google Chrome: Alt + i, then r other browsers: Alt + Shift + i, then r | ⌘ + Option + = (with rows selected) Ctrl + Option + i, press r then r | Ctrl + Alt + = (with rows selected) Alt + i, then r |
| Insert rows below | in Google Chrome: Alt + i, then w other browsers: Alt + Shift + i, then w | Ctrl + Option + i, press r then b | Alt + i, then w |
| Insert columns to the left | Ctrl + Alt + Shift + = Ctrl + Alt + = (with columns selected) in Google Chrome: Alt + i, then c other browsers: Alt + Shift + i, then c | ⌘ + Option + = (with columns selected) Ctrl + Option + i, press c then c | Ctrl + Alt + = (with columns selected) Alt + i, then c |
| Insert columns to the right | in Google Chrome: Alt + i, then o other browsers: Alt + Shift + i, then o | Ctrl + Option + i, press c then o | Alt + i, then o |
| Delete rows | Ctrl + Alt + – (with rows selected) in Google Chrome: Alt + e, then d other browsers: Alt + Shift + e, then d | ⌘ + Option + – (with rows selected) Ctrl + Option + e, then d | Ctrl + Alt + – (with rows selected) Alt + e, then d |
| Delete columns | Ctrl + Alt + – (with columns selected) in Google Chrome: Alt + e, then e other browsers: Alt + Shift + e, then e | ⌘ + Option + – (with columns selected) Ctrl + Option + e, then e | Ctrl + Alt + – (with columns selected) Alt + e, then e |
| Hide row | Ctrl + Alt + 9 | ⌘ + Option + 9 | Ctrl + Alt + 9 |
| Unhide row | Ctrl + Shift + 9 | ⌘ + Shift + 9 | Ctrl + Shift + 9 |
| Hide column | Ctrl + Alt + 0 | ⌘ + Option + 0 | Ctrl + Alt + 0 |
| Unhide column | Ctrl + Shift + 0 | ⌘ + Shift + 0 | Ctrl + Shift + 0 |
| Group rows or columns | Alt + Shift + Right Arrow | Option + Shift + Right Arrow | Alt + Shift + Right Arrow |
| Ungroup rows or columns | Alt + Shift + Left Arrow | Option + Shift + Left Arrow | Alt + Shift + Left Arrow |
| Expand grouped rows or columns | Alt + Shift + Down Arrow | Option + Shift + Down Arrow | Alt + Shift + Down Arrow |
| Collapse grouped rows or columns | Alt + Shift + Up Arrow | Option + Shift + Up Arrow | Alt + Shift + Up Arrow |
Few keyboard shortcuts depend upon the type of browser. They vary for Google Chrome and other browsers.
Apart from inserting rows and columns, you can quickly hide as well.
At the end of the list, you will find the keyboard shortcuts to group and ungroup rows or columns.
Keyboard Shortcuts to Manipulate Formulas
Formulas or functions are at the heart of Google Sheets. There are over 400+ built-in functions in Google Sheets.
You can analyze and visualize complex datasets using these functions.
Sometimes, users need clarification about whether the cell contains a formula, number, or plain text. This is particularly true in the case of massive datasets like budget spreadsheets.
Here are the keyboard shortcuts to manipulate the cells holding the formulas in Google Sheets:
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Show all formulas | Ctrl + ~ | Ctrl + ~ | Ctrl + ~ |
| Insert array formula | Ctrl + Shift + Enter | ⌘ + Shift + Enter | Ctrl + Shift + Enter |
| Collapse an expanded array formula | Ctrl + e | ⌘ + e | Ctrl + e |
| Show/hide formula help(when entering a formula) | Shift + F1 | Shift + Fn + F1 | Shift + Search + 1 |
| Full/compact formula help(when entering a formula) | F1 | Fn + F1 | Search + 1 |
| Absolute/relative references(when entering a formula) | F4 | Fn + F4 | Search + 4 |
| Toggle formula result previews(when entering a formula) | F9 | Fn + F9 | Search + 9 |
| Resize formula bar(move up or down) | Ctrl + Up / Ctrl + Down | Ctrl + Option + Up and Ctrl + Option + Down | Ctrl + Shift + Up Arrow and Ctrl + Shift + Down Arrow |
| Toggle formula range selection(when entering a formula) | F2 Ctrl + e | F2 Ctrl + e | F2 Ctrl + e |
With the above keyboard shortcuts, you can view the cells containing the formulas, insert absolute references, resize the formula bar, and much more.
Keyboard Shortcuts for Screen Reading
A screen reader is used to announce the location and content of the cell. In simple words, a screen reader converts text into spoken words.
It is made for people with cognitive impairment and motor disabilities.
| Task Description | Windows | Mac | Chrome OS |
|---|---|---|---|
| Turn on screen reader support | Ctrl + Alt + z | ⌘ + Option + z | Ctrl + Alt + z |
| Enable braille support | Ctrl + Alt + h | ⌘ + Option + h | Ctrl + Alt + h |
| Read column | Ctrl + Alt + Shift + c | ⌘ + Option + Shift + c | Ctrl + Alt + Shift + c |
| Read row | Ctrl + Alt + Shift + r | ⌘ + Option + Shift + r | Ctrl + Alt + Shift + r |
Using the above shortcuts, you can access the screen reader support and ask the program to read a column or row based on the selected cell.
FAQs
Q. How do you create custom keyboard shortcuts in Google Sheets?
As of 2024, Google Sheets has turned off the option to let users create unique keyboard shortcuts to perform the given tasks.
In other words, users can’t create custom keyboard shortcuts.
You must stick to the built-in keyboard shortcuts or enable the Compatible Spreadsheet Shortcuts. We have discussed Compatible Keyboard Shortcut and their usage at the beginning of this article.
Q. What is the shortcut to create a new Google Sheet?
Unfortunately, no keyboard shortcut exists to create brand-new Google Sheets.
If you want to add a new sheet within Google Sheets, use the “SHIFT + F11” keyboard shortcut.
To create a new Google Sheet, there is one shortcut URL, as shown below.
You can simply open your browser, click on the address bar, type “sheets.new“, and press the “Enter” key on your keyboard.
A new Google Sheet will be created and stored on your drive.
Q. Why are there fewer keyboard shortcuts in Google Sheets than in Microsoft Excel?
Keyboard Shortcuts in Google Sheets differ from traditional spreadsheet programs like Microsoft Excel.
This is because Google Sheets is a web-based spreadsheet program. When you press a keyboard shortcut, it is most likely to mess up with the browser’s keyboard shortcuts.
It is a considerable limitation of Google Sheets as a spreadsheet software.
However, a few standard keyboard shortcuts like CTRL + C and CTRL + V are there. Google Sheets uses a set of alternatives for the rest of the most commonly used keyboard shortcuts. All of them are mentioned above in this article.
Q. What is the keyboard shortcut for sum in Google Sheets?
In contrast to Microsoft Excel, which uses “ALT + =” to find the sum of the selected range, Google Sheets lacks a keyboard shortcut to find the sum.
The quickest way to find the sum is to click on the cell where the selected range ends and type “=s“. When you do this, Google Sheets automatically identifies that you wish to find the sum and auto-completes the formula by including the selected range.
The above method works like a charm in most of the cases.
Q. Can you set hotkeys in Google Sheets?
As discussed in the first FAQ, users cannot create custom keyboard shortcuts in Google Sheets.
They are supposed to use the built-in shortcuts and compatible spreadsheet shortcuts that resemble Microsoft Excel keyboard shortcuts.
That being said, if you are looking to assign a hotkey to Macros, then it’s easy.
Go to the “Extensions” tab from the main menu, select “Macros”, and then click on Manage Macros from the popup. Select the desired Macro and assign a specific keyboard shortcut.
It is the best way of automating repetitive tasks. Onwards, you can perform that lengthy operation using a few keys on your keyboard.
Q. What is the keyboard shortcut to the Find and Replace tool in Google Sheets?
You may be used to pressing the “CTRL + F” key to open the Find and Replace tool in Microsoft Excel.
But note that when it comes to Google Sheets, after using the same keyboard shortcut, a small popup is displayed on the upper-rightmost corner of the spreadsheet, which allows you to search for a specific keyword.
To open the Find and Replace tool, you need to press “CTRL + H” on your keyboard.
It will instantly display a popup, as shown above.
Google Sheets offers a powerful Find and Replace tool. It can perform a comprehensive search based on the match cases and regular expressions.
Note that it also allows you to search within formulas and hyperlinks.
Conclusion
While using any computer application, keyboard shortcuts are crucial for the users.
They help users improve their productivity and boost business revenue in the long run.
I hope you learned everything about Google Sheets keyboard shortcuts. In reality, not all of them are going to be helpful to you. But the more you know, the better you become at organizing data.
With practice, you will master most of them and take your computing or data analysis skills to the next level.
Don’t forget to explore our blog for more tips and tricks to use Google Sheets like a pro.