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…
-
-
Freezing Rows in Google Sheets
Freeze as many rows or columns as you want in Google Sheets. Find out how in this article.
-
Quickly 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…
-
Transpose 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…
-
Remove Duplicate Items In Google Sheets
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…
-
Formatting Sentences With Functions In Google Sheets
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…
-
Conditional Date Formatting in Sheets
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?…
-
Google Sheets 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…
-
Insert Images Into Google Sheets
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…
-
Creating a Dropdown List In Google Sheets
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…
