Remove Duplicates & Spaces in Sheets
Google Sheets has new features that allow you to very easily remove duplicates and extra spaces from cells without using a formula or script. It’s pretty awesome! Remove Duplicates We’ll start by taking a look at the ‘remove duplicates’ feature. Removing duplicates hasn’t been that hard up to this point, but now it’s super simple.…
Read MoreUsing Indents in Google Docs
Indentation in Google Docs is super easy, and there are a few ways to do it. This article will show you how.
Read MoreFreezing Rows in Google Sheets
Freeze as many rows or columns as you want in Google Sheets. Find out how in this article.
Read MoreAdding Page Numbers In Google Docs
You can add page numbers in Google Docs easily using the header and footer options.
Read MoreHow to Change Margins in Google Docs
Find out how to easily change the top, bottom, left and right margins in your Google Document.
Read MoreAdd An Account to Google Backup & Sync
Need to sync more than one Google Drive account to your computer? This article will show you how to do that!
Read MoreEdit Form Responses In Google Forms
Do you need to have someone edit form responses AFTER they’ve already submitted them? What if they closed the form and need to edit later? If this is something you’re dealing with, then this article is where you need to be! Edit Form Responses After They’ve Been Submitted I recently had a student ask me…
Read MoreQuickly Move Cell Ranges in Google Sheets
There’s no need for using copy/paste when moving your data in Google Sheets. You can simply select a range of cells and drag them to a new location, retaining all formatting. Moving Cell Ranges This example shows some data that isn’t in the best order. It would probably be better to have the “First” name column…
Read MoreTranspose Data In Google Sheets
Sometimes we end up with data in a column then later realize that it needs to be in a row, or vice versa. This is called transposing. Fortunately, Google Sheets makes it very easy to quickly transpose your data. How to Transpose Data This example shows weekdays listed down one column, and names of people…
Read MoreGmail Out-of-Office Auto Reply
When you’re on vacation, out of the office for any reason where you won’t be answering emails, it’s always a good idea to set up an auto reply so that people know you’re gone and when to expect you back. This way you (hopefully) won’t be bombarded by emails that you will have to sift…
Read More