#Google sheets shortcuts series#

If you want the shortcut to always be performed on the same specific cells, select “Use absolute references” otherwise, select “Use relative references.” Then perform whatever actions you want to record. Open the Tools menu, select Macros, and then select Record macro.

#Google sheets shortcuts series#

You can even create your own personalized shortcut within Sheets to perform a complex series of custom actions with a single command. With the right combination of keys, you can format any cell or selection of cells however you want, without having to dig around in menus. Google Sheets’ fast-formatting shortcuts are also worth remembering. Sheets has plenty of keyboard shortcuts, but one series that’s especially worth noting is the collection of commands that quickly insert the current date and/or time wherever you want: Hit Ctrl or Cmd and the semicolon key to add the date, Ctrl or Cmd along with Shift and the semicolon key to add the time, and Ctrl or Cmd along with Alt and Shift and the semicolon key to add the date and time together.ģ. (You can also type “sheets.new” or “spreadsheet.new,” if you prefer.)Ģ. As long as you’re already signed into your Google account, that’ll start a new spreadsheet for you, no matter where you are on the web. Instead, just type “sheet.new” directly into your browser’s address bar. The next time you need to create a new spreadsheet, save yourself the trouble of opening up the main Google Sheets site and clicking through the commands there. While some of these items will also work in the Sheets’ mobile apps, the instructions below are all for the service’s web version.