How to Change the Width of Multiple Columns in Google Sheets

Have the sizes of the columns in your Google Sheets spreadsheet become unruly? Or is data becoming difficult to read because it is obstructed by other columns? Then resizing those columns is definitely something that you will want to do. But individually resizing multiple columns can be a little annoying, especially when you are working […]

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 […]