Filling Cells

by Allen Wyatt
(last updated October 31, 2013)

If you take a look at the selected cell within a spreadsheet, you'll notice a few things. First, the cell has a heavy border around it. Second, if you select multiple cells, those cells are shaded in addition to having the border. These features help you to easily locate the selected cell (or range of cells) from all the other cells in the spreadsheet.

The selected cells also have something else unique: A small square at the lower-right corner of the cells. This small square is known as a fill handle. (See Figure 1.)

Figure 1. The fill handle in the lower-right corner of a selected cell.

When you move the mouse pointer over the fill handle, you'll notice that it changes into a large plus sign. You can use the fill handle to either copy cells or fill a range of cells with repeating, sequential values. If you select a single cell and then drag the fill handle downward (click on the fill handle and drag the mouse), Sheets fills in the selected cells with whatever was in the original cell.

If you select a range of cells and those cells have a discernable pattern, when you click and drag the selected cells are filled with patterned cells. For instance, let's say you type 1, 2, and 3 (or 2, 5, and 8) into three adjacent cells. If you select those cells then click and drag the fill handle downward, the rest of the cells are filled with numbers that repeat the same pattern. (See Figure 2.)

Figure 2. You can use the fill handle to fill a range of cells with a discernable pattern.

You could also have the beginning cells contain other information, such as two sequential weekdays or two sequential months, or two sequential dates. Click and drag the fill handle, and the selected cells are filled with values that continue the pattern you started (weekdays, months, or dates, in this instance).

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Understanding the COMPARE Field

The COMPARE field is rather esoteric, but it can be helpful when you need to compare two values using fields. The result of ...

Discover More

Determining Differences Between Dates

Macros are often used to process the data in a worksheet. If that data includes dates that need to be processed, you'll ...

Discover More

Unique Military Date Format

Some industries (such as the military) have special formatting that they use to represent dates. Here is one such format and ...

Discover More
More DriveTips

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 ...

Discover More

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 ...

Discover More

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 ...

Discover More
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is eight minus 2?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)