How to Save a Google Sheets File as a CSV
The CSV file type might seem somewhat basic when you are dealing with a spreadsheet, but it’s a very versatile file type that works with …
Google Sheets
How-to guides and tutorials to help you perform specific tasks and use the Google Sheets spreadsheet application.
How to Change Slide Dimensions in Google Slides
Your Google Slides dimensions can be a pretty important part of your presentation when you want to print it. The standard size of a Google …
Why Is My Google Sheets Toolbar Missing?
Are you trying to make some edits to a spreadsheet that you have in Google Sheets, but you either don’t see the menus at the …
How to Lock a Row in Google Sheets
There are some things you can do with your spreadsheets that make them easier for others to read, but also easier for you to edit. …
How to Make All Columns Same Width – Google Sheets
Blank spreadsheets in Google Sheets have a default column width of 100 pixels. But as you start adding data to those cells and adjusting their …
How to Make a Title in Google Sheets (An Easy 5 Step Guide)
While you may have already figured out how to give your Sheets file a name by changing it in Google drive or at the top …
Google Sheets Restore Version Guide (Just 6 Easy Steps!)
While you can fix a lot of problems on a computer with the “Undo” option, you might not realize that a mistake has been made …
How to Lock an Image in Google Sheets (An Easy 5 Step Guide)
If you’ve ever had a picture in a cell in a spreadsheet and had it not move when you were adjusting your layout, then you …
How to Print Gridlines in Google Sheets
Gridlines are a crucial part of many spreadsheets in applications like Microsoft Excel and Google Sheets. They can make data easier to understand, so you …
How to Set Google Sheet Row Height
While the default height of your rows and your cells in Google Sheets are ideal for single lines of data, you may be adding a …
How to Turn Off Autocomplete in Google Sheets
If you’ve ever been typing in an application like Google Docs or Google Sheets and had it offer suggestions or fill in information, then you …
How to Print Your Entire Workbook in Google Sheets
When you print in a spreadsheet application like Google Sheets or Microsoft Excel you may have more experience printing individual worksheets. Since configuring a spreadsheet …
How to Change Cell Border Color in Google Sheets
Formatting your cells in a spreadsheet application like Microsoft Excel or Google Sheets is an important component to making your data easier to read. One …
How to Sort Highest to Lowest in Google Sheets
While spreadsheet applications like Microsoft Excel and Google Sheets have a multitude of uses, perhaps one of the main reasons to employ this type of …
How to Unhide Sheets in Google Sheets
Google Sheets has an option that you can use to hide some of the worksheet tabs in your file. This is helpful when you have …
How to Put Google Sheets Page Numbers at the Top of the Page
Numbering pages in a document is often a requirement for schools or organizations, but they may not have a similar requirement for spreadsheets. You can …
How to Change a File Name in Google Sheets
Do you find it difficult to manage your files in Google Drive because the names aren’t descriptive enough? Sometimes we may have an idea of …
How to Use the Google Sheets Hide Sheet Tool
A Google Sheets file is a workbook that can contain a number of individual worksheets within it. Each of these worksheets is identified by a …
How to Delete Columns in Google Sheets
When you are editing a Google Sheets spreadsheet, especially if it contains a lot of data, then it’s not uncommon to need to delete an …
How to Find the Google Sheets Show Formulas Setting
Google Sheets can make calculations a lot simpler with the help of equations and formulas. But as you enter formulas into the cells in your …
How to Change the Color of the Sheet Tab in Google Sheets
If your Google Sheets file has a lot of worksheets, finding the right one can be difficult. This is made even worse when the tabs …
How to Change Google Sheets Recalculate Settings
Many of the formulas that you might add to a spreadsheet in Google Sheets are going to rely on cell locations. If you change something …
How to Change the Orientation of a Printed Spreadsheet in Google Sheets
Does it seem like your printed spreadsheet isn’t making the best use of the space on the page? If it seems like you aren’t fitting …
How to Clear Formatting from a Cell in Google Sheets
When you enter data or text into an application like Google Sheets or Google Docs you can elect to change a formatting option for that …
How to Make a Histogram on Google Sheets
Google Sheets provides you with many of the same options that you would find in Microsoft Excel, including the ability to create charts and graphs. …
How to Remove Lines in Google Sheets
Google Sheets files will display the gridlines on your screen by default when you create a new spreadsheet, and it will even include them by …
How to Add Color to Cells in Google Sheets
Documents that only contain black text on a white background can sometimes be tough to read. it can even make it difficult for people to …
How to Add Borders to Cells in Google Sheets
Have you ever seen a spreadsheet that had different colored lines between its cells, or the lines seemed darker? If you liked that effect then …
How to Make a Picture More Transparent in Google Docs
While some of the images that you add to a document will look perfectly fine as they are, you might have pictures that need some …
How to Insert a Picture in the Google Sheets iPhone App
The steps in this article are going to show you how to insert a picture from your iPhone into a cell in one of your …
How to Copy Multiple Rows in Google Sheets
This article is going to show you how to copy more than one row in Google Sheets so that you can paste it into a …
How to Use Autofill in Google Sheets
When you are adding data to a spreadsheet in Google Sheets, it’s very likely that some of that data will fall into a pattern. Whether …
How to Download a Google Sheets Chart as a PNG
The steps in this article are going to show you how to download a chart or graph in your Google Sheets spreadsheet as a .png …
What is the Gray Bar in My Google Sheets Spreadsheet?
The steps in this guide are going to show you the setting in Google Sheets that will let you add or remove the gray bar …
How to Create a Google Sheets Drop Down Menu
The steps in this guide will show you how to create a drop down menu in Google Sheets. This menu will be either created from …
How to Remove Multiple Checkboxes in Google Sheets
Google Sheets provides a simple way for you to add a checkbox to your spreadsheet. Simply click the Insert tab at the top of the …
How to View Cell History in Google Sheets
Google Sheets has long had an option that allowed you to view the history of a file. You could open up the Version History, select …
How to Download an Excel Version of a Google Sheets File
Google Sheets is very similar to Microsoft Excel in many ways and, for a large number of users, is a perfectly acceptable replacement. Sheets lets …
How to Hide a Column in Google Sheets
Sometimes when you are creating a spreadsheet you will focus first on adding all of the data, then format everything so that it is more …
How to Rename a Google Sheets Worksheet Tab
Google Sheets, much like Microsoft Excel, lets you add new worksheets to your file. This makes it easy for you to organize all of your …
How to Remove Cell Borders in Google Sheets
Cell borders are useful in spreadsheet applications for providing a visible outline around cells of importance, or when you are printing your spreadsheet. But your …
How to Insert a Checkbox in Google Sheets
Spreadsheets can be used for a number of different purposes, but one common one is to create a form that is distributed to other people. …
How to Apply Alternating Colors to Rows in Google Sheets
Spreadsheet data can be difficult to read on a screen or on a printed page, especially when you are dealing with a lot of data …
How to Randomize a Data Selection in Google Sheets
While spreadsheet applications are useful for their ability to calculate and manipulate data, situations may arise where you don’t want your data in a specific …
How to Merge Cells in Google Sheets
When you first create a spreadsheet in Google Sheets it will contain a series of cells arranged into rows and columns. These cells will be …
How to Center Data Horizontally in Google Sheets
The data that you enter into your cells in Google Sheets often receives some default formatting based on the type of data it is. For …
How to Split Full Names in Google Sheets
Data formatting is something that many people don’t consider when they are first creating a spreadsheet, but it often becomes an issue later in the …
How to Stop Sharing a Link to a Google Sheets File
Google Drive makes it very easy for you to share a link to one of the Google Sheets files that you’ve created. Simply turn on …
How to Protect a Worksheet in Google Sheets
The collaboration feature in Google Sheets makes it easier for a group of people to work on the same file. But if you have shared …
How to Apply Currency Formatting in Google Sheets
Many of the spreadsheets that people work with in Google Sheets involve money. But it’s possible that the cells containing those monetary values are either …