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 that runs horizontally or vertically between rows or columns in your spreadsheet. We cover the steps briefly at the top of the article, then continue further with additional information and […]

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 a list of data that already exists in your file or from a list that you enter, so you will need to have that data in one of your worksheets […]

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 window, then choose the Checkbox option near the bottom of that menu. But if you find that you don’t want those checkboxes, or if you are working on someone else’s […]

The gridlines in your Google Sheets spreadsheets are typically effective enough at separating your data so that you can easily determine the limits of each cell. Gridlines even print by default in Google Sheets, which helps to solve one of the more common issues encountered when printing in Excel. But sometimes you will want something […]

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 have similar names. One way to alleviate this problem, however is by adding color to those tabs. Our guide below will show you how to modify a worksheet tab in […]

Google Sheets shares many of the same features as Microsoft Excel, including the ability to add a picture to your spreadsheet. Previously this had meant adding the image in a way where it might not actually be in a cell, which could make it somewhat difficult for you to work with your data. Fortunately a […]

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 a version of the sheet from a different date, and even revert to that version of the file if you wanted. But they have recently added a feature that gives […]

Have you ever made a change to a spreadsheet, then realized later that it was a mistake? Often these sorts of changes can be rolled back with Ctrl + Z or the application’s Undo option, but sometimes they can’t. Typically you may decide that you simply need to manually recreate everything, or possible even give […]

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 you perform much of the same formatting, and many of the same calculations, that are possible in Excel, and the ability to share and collaborate on projects with other Google […]

The rows in your Google Sheets spreadsheet have a height of 21 pixels by default. This is meant to fit a single line of text at the default font size. But you may find that this row height is too small, or your spreadsheet needs require the height of your rows to be either smaller […]