Google Sheets

Google Sheets Is Adding Colorful “Chips”

Spreadsheets are useful for a lot of things, and among those uses, there’s project/task managing. Google Sheets is one of the most easily accessible and useful spreadsheet services, and now, it’s getting a little friendlier f…

Arol Wright Dec 9th, 2022

How to Create a Combo Chart in Google Sheets

Picking out the best chart for effectively displaying related data isn’t always easy. Using a combo chart in Google Sheets, you can take advantage of two charts combined for the ideal visual.

Sandy Writtenhouse Nov 27th, 2022

How to Add a Trendline in Google Sheets

If you want a simple visual to help your audience see the direction of the data in your chart, consider a trendline. You can add different types of trendlines in Google Sheets and customize their appearance….

Sandy Writtenhouse Nov 25th, 2022

How to Make a Timeline Chart in Google Sheets

When you want to display an easy-to-read visual for items in chronological order, consider a Timeline chart. In Google Sheets, you simply enter the dates and numeric data, and you’ll have a line graph with zoom options….

Sandy Writtenhouse Oct 30th, 2022

How to Create a Waterfall Chart in Google Sheets

If you want to show how positive or negative values affect a starting value, you can create a waterfall chart in Google Sheets. You can then view the data sequentially or stacked for the most effective visual. We’ll show you …

Sandy Writtenhouse Oct 23rd, 2022

How to Add or Subtract Time in Google Sheets

Want to add, subtract, or find the difference (duration) between two times? If so, Google Sheets makes it super easy to do just that, no function required. We’ll show you how.

Mahesh Makvana Oct 21st, 2022

How to Convert an Excel Sheet to Google Sheets

Want to be able to work on your spreadsheets on the web? If so, convert all your Microsoft Excel spreadsheets to Google Sheets. After you complete this simple process, other people can edit your spreadsheets and you can use S…

Mahesh Makvana Oct 14th, 2022

13 Google Sheets Date and Time Functions You Need to Know

When you use a spreadsheet for things where the timing is essential, you likely include dates and times. Google Sheets offers a collection of functions for formatting, converting, and calculating dates and times to help with …

Sandy Writtenhouse Oct 14th, 2022

How to Convert Google Sheets to PDF

To share something you track in a spreadsheet like company financials, club information, or a team roster, you can use a PDF instead of a spreadsheet. We’ll show you a couple of ways to convert Google Sheets to a PDF….

Sandy Writtenhouse Oct 8th, 2022

How to Create Custom Functions in Google Sheets

While Google Sheets provides you with hundreds of functions, it also allows you to create your own. Before, you could only do this using Apps Script. Now, there’s a user-friendly tool in your spreadsheet called Named Functi…

Sandy Writtenhouse Oct 7th, 2022

How to Use XLOOKUP in Google Sheets

The XLOOKUP function in Google Sheets gives you an easy way to find the data you’re looking for quickly. XLOOKUP doesn’t have the same limitations as VLOOKUP and HLOOKUP, enabling you to perform lookups in any direction….

Sandy Writtenhouse Oct 5th, 2022

Google’s Best Collaboration Tools in Docs, Sheets, and Slides

Google’s suite of productivity apps includes some of the most useful collaboration tools. You can work on a document together in real-time, add and resolve comments, assign tasks, and much more in Google Docs, Sheets, and Sli…

Sandy Writtenhouse Oct 2nd, 2022

How to Import Data With Google Sheets Functions

You may want to work with data in your spreadsheet that resides elsewhere. Using a set of Google Sheets functions, you can import data from a CSV file, RSS feed, web page, or another spreadsheet.

Sandy Writtenhouse Sep 21st, 2022

How to Automatically Highlight Values in Google Sheets

An easy way to make numbers stand out in Google Sheets is with conditional formatting. You can automatically apply formatting like a bold font or cell color when certain values meet your criteria.

Sandy Writtenhouse Sep 2nd, 2022

How to Use the SEQUENCE Function in Google Sheets

Filling sequential data in Google Sheets is easy using the fill feature. But if you want to increase or decrease the numbers in your series or fill all cells in an array, consider the SEQUENCE function….

Sandy Writtenhouse Aug 29th, 2022

How to Fix a Formula Parse Error in Google Sheets

There’s nothing worse than working on a formula in your spreadsheet only to receive an error instead of a result. Here, we’ll look at the formula parse errors you may see in Google Sheets and how to fix them….

Sandy Writtenhouse Aug 28th, 2022

6 Effective Ways to Use Explore in Google Sheets

The Explore feature works differently in Google Sheets than in Google Docs. You can use it to get useful details about your data to help you analyze it. You can also use pieces that the tool provides in your spreadsheet….

Sandy Writtenhouse Aug 15th, 2022

How to Use INDEX and MATCH in Google Sheets

When you have a large amount of data in your spreadsheet, looking up specific data can take time. VLOOKUP is a handy function but has its limits. Instead, you can use INDEX and MATCH in Google Sheets.

Sandy Writtenhouse Aug 12th, 2022

3 Ways to Clean Up Your Google Sheets Data

Sometimes when you import data or work with others on a spreadsheet, data can get messy. You may have duplicates, inconsistent data, or extra spaces. Google Sheets offers a few features to help you clean up your data….

Sandy Writtenhouse Aug 4th, 2022

How to Make and Share a Household Budget in Google Sheets

If you want to create a budget and share it with your housemates, Google Sheets is a great option. Use a template or make a budget from scratch and then share it so you can all work on it together.

Sandy Writtenhouse Aug 1st, 2022

7 Google Sheets Features to Boost Your Productivity

Saving time, performing tasks easily, working efficiently, and maximizing output are all parts of productivity. With these several Google Sheets features, you can boost your productivity and work more effectively on your spre…

Sandy Writtenhouse Jul 18th, 2022

How to Hide and Unhide Sheet Tabs in Google Sheets

When you have a workbook with many sheets, it can feel tedious to scroll between them. In Google Sheets, you can hide your sheet tabs to see only those you need. Then, unhide them when the time comes to view them again….

Sandy Writtenhouse Jul 15th, 2022

How to Insert Multiple Rows in Google Sheets

If you need several more rows in your spreadsheet, don’t waste time adding one row at a time. Google Sheets offers a few ways to add multiple rows, even between your existing rows, in your spreadsheets. We’ll show you how….

Mahesh Makvana Jul 4th, 2022

How to Translate Languages in Google Sheets

When not everyone you work with speaks the same language natively, you may need to use a translator. In Google Sheets, you can translate languages so that collaborating or reviewing spreadsheets is a bit easier….

Sandy Writtenhouse Jun 24th, 2022

How to Count Cells With Text in Google Sheets

Using Google Sheets’ COUNTA and COUNTIF functions, you can count cells that contain any text, specific text, or partially matching text. This is a great way to find the non-blank cells in your spreadsheets, and we’ll show you…

Mahesh Makvana Jun 23rd, 2022

Complete Guidesby How-To Geek

Our Latest Product Roundups

Reader Favorites

More from How-To Geek

Latest Geek News

Reader Favorites

More from How-To Geek

Latest Reviews

Across LifeSavvy Media

Complete Guides
by How-To Geek