Google Sheets

Google Sheets can have up to 5 million cells. It’s definitely overwhelming, but it can accommodate all the numbers you want to crunch and the formulas you want to use. Now, what if you need to prepare and print a report with the data and some calculations? 

Spreadsheets are not only for data analysis. More often than not, you will need to present the data together with some charts and graphs in printed form.

And, in most cases, making it as legible as possible might be a challenging task. The good news is Google Sheets provides simple ways to set your print area easily. 

Now, if you’ve been used to how MS Excel sets print areas, you might find how Google Sheets handles it a little different.

Google Sheets does not have the same feature as Excel to set a print area while you’re working on your spreadsheet.

You will only find print area options once you open Google Sheets’ Print settings window. 

You’ve come to the right place because we’ve got you covered. Here, we’ve carefully laid out here in this guide below the steps to easily set the print area of your spreadsheet.

Now, there are about two ways to set the print area in Google Sheets. 

2 Ways to Set Print Area in Google Sheets

• Setting Selected Cells as Print Area
• Setting The Current Sheet or Workbook as Print Area

Both these methods will be covered in this guide down below. At the same time, we also made sure to include some customization tips to make your print area more readable when printed. 

Hopefully, you’ll find the steps outlined here relatively easy to follow, as we have created this tutorial with beginners in mind. Also, we will expound on each of the methods bit by bit to help you follow us at every step of the way. 

Without any delay, let’s get on with it! 

Read moreHow to Set Print Area in Google Sheets

If you didn’t know, Google Sheets can have more than 15,000 rows. While that might be hard to imagine, it’s even harder to keep track of your column heads while you’re scrolling up and down. In most cases, you’ll find it difficult to compare data even between columns as you scroll down. This is also true when comparing data between rows. 

Now, there are two ways to freeze rows in Google Sheets. 

2 Ways to Freeze Rows in Google Sheets

• Freeze the first row 
• Freeze a certain number of rows up to the current row

Both of these methods will be covered in this guide down below. At the same time, we made sure to include a guide on how to freeze and unfreeze columns in Google Sheets. You’ll find those two sections at the end of the article, so make sure to scroll all the way through!

Now, the first method allows you to freeze a number of rows that are pre-defined by Google Sheets. The second one gives you more freedom in terms of how many rows you can freeze. However, there are some limitations to this, and we’ll go over these restrictions below. Hopefully, you’ll find the steps in this guide relatively easy to follow, as we have laid them out with beginners in mind. 

Without further ado, let’s get on with it!

Read moreHow to freeze rows in google sheets

Looking at numbers and texts in a plain spreadsheet table can be an unpleasant experience.

Coloring alternate rows of your spreadsheet not only makes it look easy on the eyes but, most especially, more professional.

Shading alternate rows also make navigating through dozens of them a breeze.

Now, there are two ways to color alternate rows in Google Sheets. 

2 Ways to Color Alternate Rows in Google Sheets

• Using the built-in function of Google Sheets
• Using a formula in the conditional formatting 

The first method is the simplest way to color alternate rows. However, it is limited only to coloring every other row. Thus, you may find the second one more flexible, especially if you want to control the number of rows to be shaded. 

To help you even further, we included links to the same exact spreadsheet we used in this guide down below. You may choose to use our sample spreadsheet so you could start following the steps right away. 

Alternatively, you can also apply what you learned in this article to your own personal spreadsheet.  

Read moreHow to color alternate rows in Google Sheets

Knowing how to create split cells in Google Sheets can save you a lot of time when compiling data. This can be for names, addresses, personal information, and so on. You can even use this for storing items in your shop, as long as you have a proper format.

Now, there are two ways to split your cells. 

2 Ways to Create Split Cells in Google Sheets

• Using the SPLIT function
• Using the Split text to columns feature

Both these methods have varying effects, but with the same outcome. We’ll explain in detail what we mean by that later on. Throughout this article, we’ll go over examples, the pros and cons of both methods, and when you should split cells in Google Sheets. If you aren’t familiar with Google Sheets at all, you have nothing to worry about!

The steps below are made with beginners in mind, so you should be able to just follow through the tutorial. Without further ado, here’s how you can create split cells in Google Sheets.

Let’s dive right in!

Read moreHow to Create Split Cells in Google Sheets

Learning how to wrap text in Google Sheets is a fantastic skill that helps you take your spreadsheets to the next level. It’s one of those underrated skills that show just how particular you are with the details in your presentation. Being able to clearly see your text, information, or any data on your spreadsheet is a massive plus to productivity. 

With that said, there are a couple of ways that you can go about wrapping text in Google Sheets.

3 Ways to Wrap Text in Google Sheets

• Wrap text through format tab
• Wrapping text through the toolbar
• Manually wrapping your text

Each method has its perks, especially the third one where you can manually wrap your own text. With that said, we’ll cover all of this later on in a step-by-step guide. We’ll also provide examples and sample spreadsheets that you can download so you can try this out for yourself.

With that said, don’t be intimidated to follow this article if you’re new to Google Sheets. These steps are beginner-friendly and should be easy for you to go over.

Let’s get started! 

Read moreHow to Wrap Text in Google Sheets

Using dropdown lists in Google Sheets is an excellent way to make your spreadsheet interactive. This feature helps provide a seamless experience when categorizing or adding data. Instead of writing out the same thing repeatedly, adding a dropdown list is a better way to encode information. 

Now, there are about two ways you can create a dropdown list in Google Sheets.

2 Ways to Create a Dropdown List in Google Sheets

• Create dropdown list using a range of cells
• Create dropdown list by manually specifying

We’ll cover both of these methods in the guide down below and give you extra tips in regards to copy-pasting dropdown lists. At the same time, we’ll also expound on the importance of having a dropdown list in your spreadsheet. If you’re interested in figuring out how to edit dropdown lists, we’ll go over that as well at the end of the article. 

With that said, don’t feel intimidated going into this article. This guide was written with beginners in mind, so it should be relatively easy for you to follow the steps. To guide you even further, we’ll provide copy links down below so you can create a copy of the spreadsheets used in this method.

Let’s dive right in!

Read moreHow to Create a Dropdown List in Google Sheets

Being able to filter out duplicates in a cell can be an essential and convenient skill when arranging your spreadsheet. Learning how to do this saves you time, increases efficiency, and fixes so many problems for long documents in Google Sheets.

With that said, how can you highlight duplicates in Google Sheets? Well, there are a couple of ways that you can do this. More so, there are also several variations as to how you can specify which duplicates you want highlighted. With that said, there’s no shortcut button for this, so this article will be a little technical.

3 Ways to Highlight Duplicates in Google Sheets

• Highlight all duplicates in the column or row
• Highlight the rows of all duplicates in a column and vice versa
• Highlight all duplicates except the first instance

These three methods should be more than enough for your regular needs. We’ll go over these variations in a step-by-step process throughout this entire article. If you aren’t familiar with formulas and Google Sheets functions, don’t worry! We’ve written this article with beginners in mind, so you can follow and do this for your spreadsheet with ease!

Without further ado, let’s get started!

Why Should I Highlight Duplicates in Google Sheets?

Being able to highlight the duplicates in your spreadsheet helps you get rid of entries that are repetitive and unnecessary. An important aspect of a good spreadsheet is its ability to be efficient and fast. 

A good example of when highlighting duplicates is convenient is when you’re filling out a registration sheet. Instead of looking through each individual name 1-by-1, or worse, comparing ID numbers manually, automatically highlighting duplicates will save you time and money. 

This is especially true for spreadsheets that have been used for months and are typically used by a lot of people who share the same spreadsheet. You’ll find that this is a common practice in big companies, startups, businesses, and even personal documents.

With that being said, it’s time to highlight duplicates! Here’s how you can do just that for your Google Sheets spreadsheets.

Read moreHow to Highlight Duplicates in Google Sheets

Being able to merge your cells is a useful skill whenever you’re making a spreadsheet on Google Sheets. The feature lets you combine your cells, to make it easier to read and give your text some room to breathe. In this article, we’ll guide you through the step-by-step process of giving your Google Sheet a clearer view by merging your cells.

Now, there are three ways you can go about merging your cells.

3 Ways to Merge Cells in Google Sheets

• Merge chosen cells horizontally
• Merge selected cells vertically
• Merge all horizontal and vertical cells

These three different methods will dictate the orientation of how your cells will be merged. We’ll go over the differences of these three, as we guide you through the process of using each of them. Additionally, we’ll also provide the pros and cons of each variation, and give you examples of when you should use them. Be sure to stick towards the end where we’ll show you how you can merge cells without using the Format button. 

Even if you aren’t familiar with Google sheets, this article was written to be beginner-friendly. With that in mind, here’s how you can merge cells in Google Sheets.

Let’s get started!

Read moreHow to Merge Cells in Google Sheets

Being able to lock cells in Google Sheets can be a lifesaver, especially when you’re in a corporate environment. Although you can always send someone a spreadsheet that they can’t edit, there’s always a case when we want users to edit some parts of the spreadsheet.

With that said, how can you protect other cells from being tampered with when sending your spreadsheets out to potential employees or guests? Well, locking your cells is how. Now, there are a couple of different ways that you can lock cells in Google Sheets, and we’ll go over all those variations in this article.

4 Ways to Lock Cells in Google Sheets

• Locking specific cells, so that other cells can still be edited
• Locking specific cells but allowing other users to edit the locked cells
• Show a warning when trying to edit, but allow editing
• Locking the entire sheet

These are the four ways you can lock cells in Google Sheets. We’ll be going over each variation one by one later on in depth. Additionally, stick around to the end so you can figure out how to unlock or edit the permissions of certain cells. 

For those of you who aren’t familiar with Google Sheets, you don’t have to feel intimidated. This article was written with beginners in mind, so you should be able to just follow through steps with no problem.

Let’s get started!

Read moreHow to Lock Cells in Google Sheets