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.
Fit text to cell 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)
