How to Remove Strikethrough in Google Sheets

Do you have a spreadsheet that contains cells with lines through them? While using this formatting option, called “strikethrough” serves a useful purpose of identifying information as deleted without actually deleting it, you might find that your current needs require the removal of that formatting. Fortunately, just as Google Sheets provides the ability to add […]

How to Alphabetize in Google Sheets

Google Sheets has many of the same features as Microsoft Excel. However, many of these features are found in different locations than you might be used to with Excel, so there can be a bit of a learning period as you familiarize your self with Sheets. One of the most commonly used features in Excel […]

How to Left Align a Spreadsheet When Printing in Google Sheets

In many cases a spreadsheet will look better on the printed page if all of the spreadsheet data is aligned at the center of the page. There’s something about centering information on a page that is just more visually appealing. Unlike Microsoft Excel, Google Sheets will horizontally center your spreadsheet by default. But there are […]

How to Hide Gridlines in Google Sheets

Gridlines are an important element for both editing your spreadsheet on a computer and viewing the spreadsheet on the printed page. In fact, Google Sheets has set this as the default behavior for the application. However, you may find your self in a situation where you need to display or print your spreadsheet without gridlines. […]

How to Restore an Older Version of a File in Google Sheets

When you are working with big spreadsheets and large amount of data, it is always a possibility that you will inadvertently change the wrong data, or you will copy and paste the wrong information. This problem can be made even worse when you are collaborating with a team of people on a single file. Google […]

How to Include the Document Title at the Top of the Page When Printing from Google Sheets

Spreadsheets can be difficult to tell from one another when they are printed out, especially if they contain similar information. Without an identifying title, for example, if might be difficult to tell the difference between your monthly sales report for January and your monthly sales report for February. This confusion can lead to mistakes, so […]

How to Save as a CSV from Google Sheets

While the popularity of Google Sheets has been increasing due to the large number of features that it has (and the fact that it is free), there are still occasions where you will need to work with a file in a different application. Fortunately Sheets makes it a simple process to download your Sheets spreadsheets […]

How to Merge Cells in Google Sheets

There are a very large number of ways that someone might need to create a spreadsheet, and it is very likely that the default layout of a spreadsheet is not ideal for your needs. While there are many ways that you can customize the spreadsheet layout in Google Sheets, a common change is to merge […]

How to Download a Google Sheet as an Excel File

Google Sheets is a free spreadsheet application that you can use when you sign into your Google Account. Sheets that you create online are saved to your Google Drive, and you can access them through the Web browser on your phone or computer, or through a dedicated app. But occasionally you will need to work […]

How to Rename a Worksheet in Google Sheets

Large workbooks often have multiple worksheets contained within them, as it is usually more convenient to contain related information entirely within one file. The default worksheet naming convention in Google Sheets will label each worksheet with names like Sheet1, Sheet2, Sheets3, etc, which is typically not very helpful in identifying the information contained in that […]