Joe Buchmann

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 l […]

Indentation in Google Docs is super easy, and there are a few ways to do it. This article will show you how.

Setting up an indent

I have a document open with some random text that I want to add indentation […]

You can freeze as many rows or columns as you want in Google Sheets. Here’s how:

In the menu, click on: View > Freeze

Choose one of the options for either rows or columns:

1 row2 rowsUp to current […]

You can add page numbers in Google Docs easily using the header and footer options.

In the menu click Insert > Header & page number > Page number

Then choose one of the four placement options:

Upper […]

Margins are the empty space at the top, bottom, left and right of your document. They are generally used to position your page content where you would like to see it print on paper.

When you create a new […]

Need to sync more than one Google Drive account to your computer? This article will show you how to do that!

Backup & Sync is an amazing tool that allows you to synchronize your cloud files to your desktop […]

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 […]

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 y […]

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 […]

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 […]

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 […]

Have you ever had a list where you needed to remove duplicates to only see one occurrence of each item? This article will show to remove duplicate items using the UNIQUE function.
Remove Duplicate Items With […]

I find that it’s really nice to see what’s in a message without opening it separately. Fortunately, Gmail has a built-in way to do this. It’s the Gmail Preview Pane, and all you need to do is turn it on.
How […]

Would you like to compose your gmail messages in a floating window instead of having it stuck down in the corner? This article will show you how you can open and compose Gmail messages In floating […]

The PROPER function works great for names since it capitalizes the first letter of every word, but it doesn’t work for formatting sentences. What if you only want to capitalize the first letter of sentences? […]