Google Sheets is becoming a popular choice for those who are transitioning from MS products to the Google workspace, where all things are collaborative and collected in a single space for easy sharing and management. Sheets is a program that uploads to the cloud and offers real-time sharing and collaboration for teams who need more dynamic tools than the average spreadsheet offers.Â
The good news is that like other spreadsheet programs, Google Sheets has plenty of shortcuts to make things even easier. You donât have to be an accounting whiz, either, because anyone can use the shortcuts that are available to improve their productivity and get more done in less time.Â
According to Google, you can generate the list of keyboard shortcuts in the Sheets program by pressing âCtrl/Cmd + /â depending on whether youâre using a PC or Mac. Youâll also have the choice to select PC, Mac, or Chrome OS shortcuts, as well as available shortcuts for Android, iPhone, and iPad. In this guide specifically, weâll cover 10 Sheets shortcuts for desktop/computer use.
This shortcut is going to select the column of the cell that is currently highlighted. To make formatting changes or calculations, this is a great shortcut to keep on hand.Â
This shortcut selects the entire row, instead of the column, allowing you to highlight a full set of data for various formatting, copying, and other needs.Â
This is one of the more universal shortcuts, but itâs one that we like to keep on every list that we can: select all. Using this shortcut will allow you to select all of the cells in the current sheet without having to click and drag or worry about missing part of the content.Â
This is a shortcut that everyone should have in their mind, for almost every piece of software out there today. Itâs the universal button for âwhoops!â and allows you to go back and undo the last thing that you did. You can continue to press the button to undo previous actions, but it will only go so far back in certain programs, including Sheets.Â
This one weâre giving you as a bonus because we canât just include one formatting shortcut when theyâre this easy. Pressing âCtrl + Shiftâ and any of the numbers one through six will result in automatic formatting of the cell to:
1 â Decimal
2 â Time
3 â Date
4 â Currency
5 â Percentage
6 â Exponent
If any of this needs to be undone, you can use the last shortcut (âCtrl + Zâ) or simply press âCtrl + \â to clear all the formatting in the cell or the entire sheet, depending on what you have selected.Â
Pressing the âHomeâ button will take you back to the beginning of the row thatâs selected on the current sheet. This is a handy way to move back to the start without having to scroll around and try to find what you need.Â
This shortcut will take you to the beginning of the entire sheet. When youâre 200 rows in and have lots of complex data, scrolling back to the top could be a nightmare. Just press these two buttons, and youâll be there in no time.Â
You can use this shortcut to insert the time into a spreadsheet column, such as when you need timestamps to track work or data entry. Select the cell, press the keys, and the current time will populate in the cell.Â
This is similar to the last shortcut, but it allows you to insert the current date. Select a cell, press the shortcut, and watch as the current date populates within the cell, saving you typing it out all the time.Â
This shortcut inserts a new Sheet in the current window, allowing you to create a new spreadsheet without closing or losing the first one. Itâs faster than going to the menu to select a new sheet and it will allow you to keep working without missing a beat.Â
These are all helpful shortcuts to have on hand that can improve your efficiency with Google Sheets and keep you moving. You can share them with your coworkers and colleagues, and find a full list of them in the Google support doc for Sheets. Feel free to browse through them and choose the ones that you find most useful because there are certainly plenty to choose from. These are just some of the most common that are found when people search for shortcuts online, so theyâre the ones we chose to share.Â
Google is all about efficiency, so be sure to explore all the ways that you can use their shortcuts to get through your work faster, on Sheets, and in all the other Google tools that you use. You might be surprised at just how quickly you can improve your day-to-day workflow with just a few simple adjustments.Â
While youâre making improvements, why not consider adding a 24/7 answering service to your repertoire? When you choose to partner with the virtual receptionists at Smith.ai, youâll get that and access to things like lead intake and qualification, appointment scheduling, and live website chat. If youâre still working on the marketing aspect, we can even assist with outreach campaigns.Â
Ask us about our customized strategies to help you conquer your communications and more, as well as how we can streamline your admin services. Thereâs nothing that we canât do to help your business be more efficient.Â
To learn more, schedule a consultation to discuss what the 24/7 virtual receptionists at Smith.ai can do to help your business. You can also reach out to us at hello@smith.ai with questions or to get additional information.Â
â