How to Do Google Sheets Left Align
When you start typing numbers into a cell in Google Sheets, that data will appear at the right side of the cell by default. This …
Google Sheets How-To Guides
Visit our collection of articles and tutorials that can help you improve your Google Sheets spreadsheets and fix problems you may be experiencing.
Not sure where to start? Check out our featured Google Sheets guides below:
- How to Wrap Text in Google Sheets – change the way that text is laid out in the cells of your spreadsheet.
- How to Subtract in Google Sheets – use a formula to subtract one cell or value from another one.
- How to Make Google Sheets Alphabetical Order – learn how to sort your spreadsheet alphabetically by one of the columns in the file.
How to Hide Column in Google Sheets
Spreadsheet applications like Microsoft Excel and Google Sheets provide you with ways to format data, select how that data prints, and adjust how it looks …
How to Turn Off Google Sheets Autocomplete
Making your life more efficient is the goal of almost every electronic device that you use on a regular basis. Whether it’s your phone trying …
How to Add a Title in Google Sheets
The term “title” when working with a spreadsheet can mean the name of your workbook or the worksheet tab, or it might even be referencing …
How to Delete Multiple Rows in Google Sheets
Often you will need to delete the data in a spreadsheet. Whether that data is no longer relevant, or it is simply incorrect, it’s rare …
How to Merge Cells in Google Sheets
A standard cell layout in Google Sheets is going to include a series of rows and columns that contain one cell in each column for …
How to Make a Graph in Google Sheets
Sometimes the data that you are creating in a spreadsheet is better understood if you can create a visual representation of that data. This is …
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 …
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 …
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 …
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. But when …
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 …
How to Ungroup Columns in Google Sheets
Grouping columns in spreadsheet applications like Microsoft Excel provides you with a simple method to hide and unhide large groups of data at once. A …
How to Stop Freezing Rows in Google Sheets
You can unfreeze a row in Google Sheets by selecting the View tab at the top of the window, choosing Freeze, then clicking No Rows. …
How to Download a Graph or Chart as a Picture from Google Sheets
Creating charts or graphs from your data in Google Sheets provides you with an effective way to display information to your audience. The actual process …
How to Delete a Graph or Chart from Google Sheets
Google Sheets is a great alternative to Microsoft Excel, and provides you with many of the tools that make Excel such an appealing application. One …
3 Ways to Create a New Worksheet in Google Sheets
When you create a new workbook file in Google Sheets, it will have one worksheet tab by default. In many cases, this is going to …
How to Use a Different Date Format in Google Sheets
Date formatting has long been an issue for spreadsheet users. Sometimes a spreadsheet won’t recognize an input as a date and assign it a weird …
How to Add Color to a Column in Google Sheets
When you are creating a spreadsheet that is going to be shared with other people, it’s common to have a particular column of data that …
How to Change Recalculation Settings in Google Sheets
When you make a change in one of your Google Sheets spreadsheets, certain functions will recalculate so that you always have the most current information. …
How to Publish Google Sheet to the Web as a PDF
While webmasters can create and format tables on their Web pages to display data, Google Sheets can look better, plus you can update them much …
How to Lock Cells in Google Sheets
Occasionally when you have a cell or range of cells in a spreadsheet it contains data or a formula that can never change. As the …
How to Create a Filter in Google Sheets
Working with spreadsheets that contain a lot of data can be cumbersome, especially when you only need to display some of the information for certain …
How to Apply a Default Layout to a Slide in Google Slides
While there are a lot of different ways that you can use presentation software like Google Slides, much of the data that you are trying …
How to Force Text to the Next Line in Google Sheets
If you type a lot of text into a cell in Google Sheets, there’s a good chance that much of it won’t be visible. While …
How to Put the Date and Time in the Header in Google Sheets
Do you print the same spreadsheet a lot, to the point where it’s becoming difficult to tell which printed copy is which? While multiple copies …
How to Add Alt Text to a Picture in Google Slides
Some of the features in Google Sheets are meant to make data easier to read on the screen, like cell merging, while others can affect …
How to Unshare a Google Sheets Spreadsheet
As you collaborate with other people on spreadsheets you may give them permissions to view or edit your files. But once the job is finished …
How to Get a Shareable Link for a Google Sheets File in Google Drive
One of the best features of Google Sheets is the ability to easily share the file with someone, or to add collaborators so that you …
How to Create a New Google Sheets Spreadsheet in Google Drive
You can make a new Google Sheets file by going to your Google Drive, clicking New, and then selecting the Google Sheets option. Google Drive …
How to Increase the Number of Displayed Decimal Places in Google Sheets
Cells in a spreadsheet can contain a wide variety of data types. Some of that data can take up a lot of room, even leading …
How to Remove Worksheet Permissions in Google Sheets
Have you ever opened a spreadsheet to find that a collaborator has made a bunch of changes, such as merging a bunch of cells? Adding …
How to Remove Borders in Google Sheets
Borders in a spreadsheet provide an easy visual clue about where different pieces of data are separated. It makes it easier to read the information …
How to Add a Hyperlink in Google Sheets
Does your spreadsheet have some data that you want people to be able to click so that it will open a Web page? An effective …
How to Unhide the Menu in Google Sheets
The menu at the top of the window in Google Sheets contains access to many of the tools and settings that you will use to …
How to Remove Comments from Google Sheets
When you give permission to someone else to work on a spreadsheet in Google Sheets, you will both be able to leave comments that are …
How to Make Font Bigger on Google Sheets
You might already know how to increase the size of the text or numbers that appear in your cells in Google Sheets, but you might …
How to Hide a Tab in Google Sheets
Worksheet tabs in spreadsheet applications like Google Sheets can be used in a variety of ways. You might have a separate tab for different reports …
How to Insert a Row in Google Sheets
Very rarely will you create a spreadsheet that doesn’t require some editing. If you need to add extra information to a spreadsheet, then often it …
How to Enable Change Notifications in Google Sheets
Do you have a spreadsheet on which you are collaborating with a team of people, and you would like to know whenever someone makes a …
How to Insert a Column in Google Sheets
When you start creating a spreadsheet from scratch, you may have a good idea of what the final layout of that spreadsheet will entail. In …
How to Delete Non-Contiguous Rows in a Google Sheets Spreadsheet
You may already be familiar with how to delete a row in Google Sheets, as it is a useful way to fix a problem that …
How to Delete a Column in Google Sheets
Deleting and editing data in a cell in Google Sheets is often as simple as clicking on a cell and typing the new information that …
How to Clear Formatting in Google Sheets
There is a large assortment of formatting options that you can apply to a cell in Google Sheets. Some of these formatting options are easy …
How to Print Gridlines in Google Sheets
Gridlines in a spreadsheet are important for providing visual representation of the boundaries of a cell. It makes it easier to tell which characters belong …
How to Delete a Row in Google Sheets
Does your Google Sheets spreadsheet have rows that you don’t need or want? Empty rows, or incorrect data, can be a problem for any spreadsheet, …
How to Show Formulas in Google Sheets
The beauty of formulas in spreadsheets is their ability to perform calculations for you. Often this occurs with the help of a mathematical operator in …
How to Use Currency Formatting in Google Sheets
Proper formatting in a spreadsheet can make it much easier for your audience to interpret the data that they are looking at. When the data …
How to Export a Google Sheets File for Microsoft Excel
Google Sheets is a great, free spreadsheet application that is available to people with Google Accounts. You can create, edit and manipulate data using this …
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 …
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 …
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 …
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 …