Tips, Tricks, and Answers
The following articles are available for the 'Sheets' topic. Click the article''s title (shown in bold) to see the associated article.
Adding a Comment to a Cell
Comments can help document what is going on in a spreadsheet. Here's how to easily add comments to individual cells.
Adding a Drawing to Your Spreadsheet
Numbers alone do not define spreadsheets. Google Drive allows you to also add drawings to a spreadsheet, which can be very helpful in some instances.
Adding borders to a cell (or range of cells) is a common way to draw attention to the cell contents. Sheets provides a variety of formatting tools to quickly add borders to your selection.
Adding Stock Information
Adding stock information to a spreadsheet is a common need. Rather than enter information manually, why not let Sheets handle the heavy lifting for you?
Adjusting Border Color
Want to make a particular cell or range of cells stand out? One way to do it is by changing the border color of the cells, as described in this tip.
Adjusting Cell Alignment
To present your spreadsheet data in just the manner you want, Sheets provides tools that enable you to adjust both horizontal and vertical alignment. Here are the details on how to use these tools.
Brainstorming with Google
Sheets includes a nifty, undocumented feature that allows you to enlist Google's help in brainstorming. All you need to do is supply a few seed words or phrases, and Google does the rest.
Changing the Legend Location
When you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. If you don't want the legend located where Sheets puts it, you can easily move it to a different location.
Changing Vertical Cell Alignment
If you have a large row height, you may want to adjust how the information in a cell is aligned vertically. Sheets allows you to format a cell so that its contents are aligned to the tip, middle, or bottom of a cell.
Changing where a Spreadsheet is Stored
Get lots of files into Drive, and sooner or later you'll want to organize them in some way. Sheets includes a great feature that allows you to easily move any open spreadsheet into any folder within Drive. Here's how.
Controlling Display of the Formula Bar
The formula bar is where you can see exactly what is stored in a spreadsheet cell. If you would rather hide the formula bar, though, Sheets makes the configuration change easy.
Copying a Spreadsheet
There are times when you don't want to mess up a spreadsheet, but you want to try out some changes. This is when making a copy of the spreadsheet can come in handy. Here's how to make that copy directly from within Sheets.
Creating a Conditional Format
Conditional formatting is a powerful tool you can use to dynamically adjust the formatting in your worksheet. This tip gives a quick overview of how you create and use conditional formats.
Creating a Named Range
Named ranges can be a great boon in creating easily understandable formulas. Here's what they are an how to define them.
Creating and Saving a Spreadsheet
Before you can work with numbers, dates, and formulas, you need to create your Sheets spreadsheet. You can do so using the point-and-click technique described in this tip.
Deleting a Comment from a Cell
If you no longer have a need for a particular comment in a cell, you'll want to get rid of it. Here are a couple of ways you can remove those unwanted comments.
Deleting a Named Range
No longer need a previously defined named range? Here's how to get rid of it.
Determining the Day of the Week
Need to know what the day of the week is? Sheets provides a handy function that can return a numeric value that represents the day of the week.
Determining the Name of the Day of the Week
What day of the week is that date? Sheets can let you know by using the TEXT function to return a weekday name for a particular date.
If you work in an international environment, you may have a need to translate text from one language to another. Sheets includes a worksheet function that can help you with the task.
If you need to fill information into a range of cells, one of the fastest ways of doing it is to use the fill handle. This tip helps you locate the fill handle and understand how it works.
When you get a lot of data in a spreadsheet, it can be hard to zero in on the data you really need to work with. That's where filtering comes into play. Sheets provides an easy way to filter your data, as described in this tip.
Getting Notified of Spreadsheet Changes
Google Sheets makes it easy to receive notifications by e-mail whenever anything in a spreadsheet changes. Here's how to set your preferences.
Grading Assignments with Flubaroo
Flubaroo is a third-party extension for Sheets that can help make grading classroom papers fast and easy. Here's a quick glimpse at what it can do, along with a link to where you can get the extension.
Hiding a Chart's Legend
When you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. You may not want a legend for your chart; if not, here's how to get rid of it.
As you are developing a spreadsheet, you'll often have the need to insert additional rows into your data. Sheets makes this easy, providing several ways you can actually perform the insertion.
Keeping Row and Column Headings in Sight
When you create a spreadsheet, it is common to place headings at the top of each column and the left of each row so you can know the meaning of the data you've assembled. It is a bother to have those rows and columns scroll off the screen when you are entering data. Here's how to make those headings stay visible at all times.
One of the layout tools that Sheets provides allows you to merge together a group of cells. Here's how to use that tool.
Renaming a Spreadsheet
Need to change the name of an existing spreadsheet? There are two ways you can do it, using either Sheets or Drive.
Saving a Spreadsheet Locally in a Non-Sheets Format
Need to share your spreadsheet with others who may not be using Google Sheets? Here's an easy way to export your spreadsheet into a variety of formats and download them to your local computer.
Searching for a Term in Sheets
Got a need to search the web for more information on something within a spreadsheet? Believe it or not, Sheets provides a quick and easy way to execute exactly the search you need.
Need to separate the contents of one cell into multiple cells? It's easy to do when you use the SPLIT function, as described in this tip.
Transposing Information in a Sheet
If you want to turn a range of cells by 90 degrees within a spreadsheet, you need to understand how Sheets can handle the transposition for you. This tip discusses your options.
Turning Off Gridlines
The purpose of gridlines is to make it easy to identify and select cells in a spreadsheet. If you find the gridlines to be unnecessary for your purposes, you can easily turn them off by utilizing the information in this tip.
Understanding Text Wrapping
Because you can put text into spreadsheet cells, it makes sense that not all that text could be displayed in a regular-sized cell. That's where text wrapping, explained in this tip, comes into play.
Using Find and Replace in a Spreadsheet
As your spreadsheets get larger, it can be hard to find some information. You may also want to replace some existing information with new information. Both tasks can be accomplished by using Sheets' flexible Find and Replace tool.
When in Rome, Count Like a Roman
Do you remember working with Roman numerals when you were in school? Sheets allows you to put those lessons to work by translating numbers into Roman numerals quite easily.