How to Add Yellow Shading to a Row in Google Sheets

Large spreadsheets can be much easier to manage when you use fill colors to highlight rows that are important, or share similarities. For example, highlighting multiple rows with a yellow fill color could let you highlight good months in a sales report. It draws the attention of the reader without affecting the data in the […]

How to Turn Off Autocomplete in Google Sheets

Autocomplete is a helpful setting in a number of different programs where you might be repeatedly entering the same word. Autocomplete works by recognizing the first few letters that you have typed, seeing that a similar word already exists in the document, then offering that word to you in the form of a blue-highlighted suggestion. […]

How to Insert a Picture In Google Sheets

Google Sheets shares many of the characteristics of Microsoft Excel that have helped to make it such a popular application. Along with the ability to store, sort, and manipulate data, Google Sheets lets you add pictures to your spreadsheets too. But if you are mainly familiar with Excel and new to Google Sheets, you may […]

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