![]() You can create a form by looking for the Form option within Sheets’ Insert menu, and then using the site that comes up to create any set of questions and parameters you want. Google Sheets has an easily overlooked cousin called Google Forms that lets you collect data in a survey-style form on the web and then compile the results in a spreadsheet. You can then drag down on that area to make the formula bar as large as you want.ġ1. One more click-and-drag shortcut to sear into your cerebellum: If you’re ever working with an especially long formula and could use more space to see it all, hover your mouse over the lower edge of the formula bar, directly above your spreadsheet’s first row. Whichever rows you select will always remain in place and visible at the top of your spreadsheet, no matter how far you scroll down.ħ. Freeze rows in a flash: Just hover your mouse over the bottom of the cell in any spreadsheet’s upper-left corner-that very first cell directly above “1” and to the left of “A.” When you see the hand symbol appear, click it and drag down for as many rows as you want to freeze, then let go. When you let go, the original cell’s contents will instantly appear in all of the other cells you selected.Ħ. Click that square and drag it in whatever direction you want, for as far as you need. ![]() Speaking of copying a cell’s contents, if you ever need to duplicate a cell’s data and have it appear in multiple cells above it, below it, or on either side of it, click the original cell to outline it in blue, then look for the little blue square in its lower-right corner. 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. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |