When you’re finished, click the Save button in the macro-recording panel, and you’ll be able to give your new shortcut a name and assign it to any available key combination for future activation.ĥ. You could do something like set a specific sort of formatting for a cell’s contents (bolded white text with the Open Sans font and a dark-gray background, for instance) or you could manipulate data in a more involved manner, like copying a cell’s contents and then erasing that cell and pasting the contents one cell over to the left. 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.
#HOW TO ESCAPE FULL SCREEN MODE ON GOOGLE SHEETS 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.
0 kommentar(er)
