How to Add Borders in Google Sheets

Customizing the appearance of your spreadsheet cells can be helpful in making some of your data stand out more. One way to accomplish this is by learning how to add borders in Google Sheets. Separating cells in a spreadsheet is often a crucial element of making sure that your data is easy to read. Without […]

How to Print on One Page in Google Sheets

Spreadsheet applications like Google Sheets have a set amount of data that they will print on one page by default. Therefore you may run into problems when you want your whole spreadsheet to fit on one page, but you have a handful or rows or columns that are being pushed to a second page. Printing […]

How to Alphabetize in Google Sheets

Google Sheets has many of the same features as Microsoft Excel. Whether you want to merge cells in Google Sheets or calculate values with formulas, you can do so with Google’s spreadsheet application. However, many of these features are found in different locations than you might be used to with Excel, so there can be […]

How to Subtract in Google Sheets

There are a lot of different ways that a spreadsheet application like Google Sheets can be useful. You can store and sort data, create charts, and you can also quickly edit and compare different types of information. Google spreadsheets share a lot of similarities with the spreadsheets that you create in Microsoft Excel. One of these […]

How to Wrap Text in Google Sheets

Learning how to wrap text in Google Sheets is beneficial when you have a lot of text to display in a single cell that you need to be visible. When you type a lot of data into a cell in your Google Sheets spreadsheet, one of several things can happen. The text can overflow into […]

How to Change Row Height in Google Sheets

Typically the rows and columns in your Google Sheets spreadsheet will automatically adjust to accommodate the data contained within them. But your spreadsheet needs may not be met by the automatic resizing, and you might need to learn how to manually change your row height in Google Sheets. The default row height in Google Sheets […]

How to Repeat the Top Row on Every Page in Google Sheets

Have you ever viewed a printed spreadsheet and had to keep checking to see which column a cell belonged to? Use these steps to repeat the top row on every page in Google Sheets. Open your Google Sheets file. Select the View tab at the top of the window. Click the Freeze option. Choose the […]

How to Change the Width of Multiple Columns in Google Sheets

Adjusting the size of the columns and rows in a spreadsheet application, like Google Sheets, is helpful in making data easier to read. Use these steps to change the width of multiple columns in Google Sheets. Open your Sheets file. Hold down the Ctrl key and click each column letter to resize. Click on the […]

How to Make a Header Row in Google Sheets

Creating a header row in Google Sheets makes it much simpler to identify the information contained within a column. You can also choose to keep that header row visible at the top of the spreadsheet as you scroll. Use these steps to make a header row in Google Sheets. Open your Google Sheets file. Add […]

How to Insert a Column in the Google Sheets iPhone App

When working with data in a spreadsheet it’s very common to adjust the rows or columns within that spreadsheet. We don’t always know the exact layout of our data, and the need for additional rows or columns can often arise. You may already be familiar with how to add a column to your spreadsheet in […]