![]() Quickly Create a new Google Sheet Method 1Ĭreate a new Google Sheet instantly by typing sheet.new in your web browser: This technique also works for freezing columns! 6. Let go when you’ve reached the row level you want to freeze (in this case, just the top row): Hover over the bottom of the column heading letters until you see the hand icon, like this:Ĭlick and hold down your mouse button, and then drag the thick line down: Traditionally, you freeze panes through the View > Freeze menu, but there is another quicker way. It’s really useful because you can keep your column headings in view as you move about your data. You’re effectively anchoring them in place. Quickly drag the column header row down to freeze panes.įreeze panes is a useful and simple technique to lock the top row (or rows) of your spreadsheet, so that they remain in view even as you scroll down your datasets. Link to important calculation cells so they can be easily accessed.Create a “table of contents” for your Sheet.Add a Home button to every tab in your Sheet so you can quickly get back to the first tab.Here’s a few examples of how you could use this: Choose either “Sheets in this spreadsheet” or “Select a range of cells to link”.Right click on the cell that you want to turn into a clickable hyperlink.You don’t even have to write any formulas yourself. You can add hyperlinks to different tabs or even directly to individual cells within your Google Sheets. Create hyperlinks within your Google SheetsĬreate hyperlinks within your Google Sheets to make it easier to find information. As you start typing, Google will auto-suggest email addresses from your contacts list.Ĥ. You tag someone in a comment very easily by typing a “+” or in the comment box, and then adding the email address of the person you want to notify. It’s way easier than trying to explain something via email! You can then tag specific people in each comment if you wish, which means they’ll receive an alert that they’ve been mentioned in a comment.įor example, you might tag Jenny in Finance to ask her to check if your calculation is correct. You add a comment by right-clicking a cell and choosing Insert comment, or through the menu Insert > Comment You can alert someone to a specific comment in a Google Sheet by adding their email address. Here you can decide what should trigger a notification and how they should be delivered (immediately or a daily summary):Ĭomments are one of the killer collaboration features embedded in Google Sheets. You’ll find it under this menu: Tools > Notification rules… Stay informed of changes to a Google Sheet by setting Notification Rules to send you an email. Stay informed of changes to a Google Sheet Today, I challenge you to use keyboard shortcuts!Ĭlick here for the Google Documentation for shortcuts. This quirk only works cell to cell, not cell to range though.) If you type some text into a cell and then hit F4 in a different cell before doing anything else, it’ll copy that same text to the new cell. (Note, this will also copy-paste static values, but not formulas. PC/Chromebook: Ctrl + Alt + R Quickly repeat your previous action in a new cell PC/Chromebook: Ctrl + H Open the drop-down menu on filtered cell PC/Chromebook: Ctrl + Select all the data in a table PC/Chromebook: Ctrl + \ Insert the current date in a cell Here are my top shortcuts: Clear All Formatting in a cell or range To see all of the available shortcuts, go to Help > Keyboard shortcuts It might feel clumsy at first, but persevere and it’ll pay off in spades as you become more efficient in your work. Use keyboard shortcuts to work more efficiently. ![]() Let’s kick off this post with one of the all-time top Google Sheet productivity tips: 1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |