Last Updated on February 24, 2024 by Jake Sheridan Struggling to keep your Google Sheets tidy? In this tutorial you will learn how to hide (+ unhide) rows, columns, tabs & cells. 22 Tips for Text Formatting in Google Sheets Trim Characters in Google Sheets 1. Remove a specific amount of characters from the left side To remove a certain number of characters from the left of a string, we can use the RIGHT function to return a string up to a specific character starting from the last character. We’ll use the LEN function to find the character position on where to begin our string. Use the foll ..read more

In this tutorial, you will learn how to make a table chart in Google Sheets. How To Make A Table Chart In Google Sheets Table charts are a great way to visualize data in Google Sheets. This type of chart can help you quickly compare values across different categories. For example, you may have a table of sales data that you want to display as a table chart. A table chart can help you quickly identify which products are the most popular. Table charts also support sorting, allowing users to quickly access the highest or lowest entries based on a particular metric or column. In this guide, we wil ..read more

In this tutorial, you will learn how to highlight duplicate cells in Google Sheets. How To Highlight Duplicate Cells In Google Sheets Highlighting duplicate cells can be a great way to quickly identify and fix errors in your data. For example, you may have a list of names, and you want to make sure that no two names in the list are the same. One way to highlight duplicate cells is by using the conditional formatting feature. This feature allows you to set up rules that will color a cell a certain way if the values meet specific criteria. In this guide, we will show you how to use conditional f ..read more

In this tutorial, you will learn how to zoom in on Google Sheets. How to Zoom In on Google Sheets When working with a large spreadsheet in Google Sheets, it can be helpful to zoom in and out to get a better view of the data. This can be particularly helpful when you want to focus on a specific area of your sheet, or you want to view a larger portion of your sheet. In this guide, we will show you how to zoom in and out on your Google Sheet to get a better view of your data. We’ll also show you how to use the built-in zoom feature found in your browser to increase the size of the Google Sheets i ..read more

In this tutorial, you will learn how to use the TRIMMEAN function in Google Sheets. How to Use the TRIMMEAN Function in Google Sheets The TRIMMEAN function in Google Sheets is a statistical tool that can be used to calculate the mean of a dataset while excluding a certain percentage of the data from the calculation. This is useful if you have outliers in your dataset that you would like to exclude from the mean calculation. The TRIMMEAN function includes a percent argument, which will allow the user to set the percentage of data points to exclude from the top and bottom of the set. In this gui ..read more

In this tutorial, you will learn how to use sort with Google Sheets query. How to Use Sort with Google Sheets Query The Google Sheets QUERY function is an incredibly powerful tool that allows you to quickly analyze and manipulate large datasets. One useful feature of the QUERY function is the ability to sort the data in your dataset. This can be a great way to see the most recent data, or to organize data by certain criteria. In this guide, we will show you how to use the ORDER BY keyword in your query text when using the QUERY function. We will also explain how to change the sorting from asce ..read more

In this tutorial, you will learn how to use importxml in Google Sheets. How To Use IMPORTXML in Google Sheets If you’re looking for a way to import data from the web into a Google Sheet, one tool you might consider is the IMPORTXML function. While it may sound intimidating at first, it’s actually quite easy to use. The IMPORTXML function uses the XQuery language to extract particular information from a webpage. Whether you’re looking for stock prices, weather information, or news headlines, you can use IMPORTXML to scrape the data you need. In this guide, we will show you how to use IMPORTXML ..read more

In this tutorial, you will learn how to make a timeline chart in Google Sheets. How To Make A Timeline Chart In Google Sheets Timeline charts in Google Sheets are a helpful way to visualize changes in value over time in an interactive visualization. Google Sheets makes it incredibly easy to create timeline charts that can be customized and shared with others. In this guide, we will show you how to make a timeline chart in Google Sheets. How to Add a Timeline Chart in Google Sheets Here’s our step-by-step guide on how to add a timeline chart in Google Sheets. Step 1 First, select the data you w ..read more

In this tutorial, you will learn how to insert a background image in Google Sheets. How To Insert a Background Image in Google Sheets Adding a background image to a spreadsheet can be a great way to make your data stand out or add some creativity to your spreadsheet. Google Sheets makes it easy to insert a background image into your spreadsheet. In this guide, we will show you how to insert a background image in Google Sheets by using the Insert menu. How to Add a Background Image in Google Sheets Here’s our step-by-step guide on how to add a background image in Google Sheets. Step 1 First, se ..read more

In this tutorial, you will learn how to calculate retained earnings in Google Sheets. How To Calculate Retained Earnings in Google Sheets Retained earnings are an essential financial metric that businesses use to measure their financial health. It is calculated by subtracting the cumulative dividends that have been paid to shareholders from the cumulative net income of the company. Suppose you currently have retained earnings amounting to $1000. During the month of December, your business was able to earn a net profit of $8,000. Your company decides to share $3000 of the profit to their shareh ..read more