Posts Tagged ‘Google Sheets’

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

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

Remove Duplicate Items In Google Sheets

Google Sheets Tips - Header - Remove Duplicates with UNIQUE

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 UNIQUE This example displays a list of items with some of them being duplicate entries. Using the UNIQUE function will…

Read More

Formatting Sentences With Functions In Google Sheets

Google Sheets Tips - Header - Format Proper Sentences

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? Formatting sentences can be done with a combination of functions. This article will show you how. Making It Happen Formatting…

Read More

Conditional Date Formatting in Sheets

Google Sheets Tips - Header - Conditional Formatting Based on Date

I’ve had this question come up a lot over time. How do I make a cell change to red or green based on the date? Fortunately, conditional date formatting is pretty easy with Google Sheets. The example below shows a list of days, and tasks for each day. Right now they’re all grey. We want to…

Read More

Google Sheets Custom Date Format

Google Sheets Tips - Header - Custom Date Format

Dates can be displayed in many formats in your spreadsheet. This article will show you how to set up a custom date format to your liking. Adding Dates to a Spreadsheet When you first enter a date into your spreadsheet, Google Sheets will usually recognize it as a date and format it accordingly. Unless you’ve…

Read More

Insert Images Into Google Sheets

Google Sheets Tips - Header - Insert Images Into Spreadsheet

There is more than one way to insert images into a spreadsheet.  This article shows you how to insert images, and how to use the IMAGE function to embed your image directly into a cell. One Method For Inserting Images The first method is to use the “Insert” menu, and select “Image”. This will open a…

Read More

Creating a Dropdown List In Google Sheets

Google Sheets Tips - Header - Create Drop Down List Menu

Why Create a Dropdown List? You can use dropdown menus to make sure people are only able to enter certain values into a cell, or you can use them to make your life easier when you’re using a cell to regularly check data in your spreadsheet. Creating a dropdown list in Google Sheets is very easy. …

Read More