Remove Duplicates & Spaces in Sheets

Google Sheets Remove Duplicates & Whitespace

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 More

Windows Mouse Arrow Spinning Blue Circle Fix

Microsoft - Spinning Blue Circle - Header

Are you sick of the blue spinning wheel that keeps showing up next to your mouse pointer on Windows 10? This article will show you how to make the spinning blue circle go away! Get Rid of the Spinning Blue Circle of Death Recently I noticed that my mouse arrow had a blue spinning wheel…

Read More

Edit Form Responses In Google Forms

Google Forms Tips - Edit Responses

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 More

Quickly Move Cell Ranges in Google Sheets

Google Sheets Tips - Move Cell Ranges Header

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 More

Transpose Data In Google Sheets

Google Sheets Tips - Transpose Header

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 More