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. #Google sheets for mac apk
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |