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 …
Google Sheets
How-to guides and tutorials to help you perform specific tasks and use the Google Sheets spreadsheet application.
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 …
How to Remove Cell Shading in Google Sheets
Spreadsheets can be difficult to read when all of your cells contain similar types of information. if that information extends across many rows and columns, …
How to Freeze the Top Row in Google Sheets
Scrolling through large amounts of data can be tedious and confusing, and the bigger your spreadsheet, the more likely you are to make a mistake …
How to Insert a Column in Google Sheets
When you first create a spreadsheet you probably have a general idea of the information you need, and what will be included in the sheet. …