Use AutoFill: MS Excel

• by Carol Bratt on 20060802 @ 10:01PM EST | google it | send to friends
• Filed under Carol's Corner Office | (related terms: adjacent cells, fill, sequence, cell, autofill)

After you've built a budget for a single period of time, you often have to repeat the process for several other time periods, say the next month, quarter or year. MS Excel provides the AutoFill feature to copy text, numbers and formulas to adjacent cells. You can also use the feature to create a sequence.

AutoFill saves you the trouble of typing the same text, numbers and formulas repeatedly.

The active cell is surrounded by a bold rectangle, and on the lower-right corner is a small black square called the fill handle.

1. Select the cell you want to copy.
    
2. Place the mouse pointer over the fill handle. It turns into a black cross (rather than the normal fat plus).
    
3. Drag across or down adjacent cells.

Using AutoFill you can quickly and easily build a large worksheet by copying text and numbers to adjacent cells. Excel is so smart: when you copy formulas using AutoFill, they automatically adjust to refer to the correct items.

The AutoFill feature is awesome; it correctly figures out what you want to put in adjacent cells. How it works depends on what you select.

To continue a sequence of dates, times or certain time periods from a single cell:

1. Select the cell containing the beginning value.
    
2. Place the mouse pointer over the fill handle.
    
3. Drag across or down adjacent cells.

If you hold down the Ctrl key as you drag the fill handle, numbers increase by 1 and dates and times are copied as is, instead of changed to the next value.

To continue a sequence of numbers, dates or time periods based on the data in two or more adjacent cells:

1. Type the first few items of the sequence in adjacent cells.
    
2. Select the cells.
    
3. Drag the fill handle to adjacent cells.

The series extends based on the cells you have selected.

As you drag, the yellow Screen Tip shows the contents of the cells. When you select more than one cell, the sequence continues according to the first few items.

You can also create a custom fill series, such as "high, medium, low" or "strongly agree, agree, neutral, disagree, and strongly disagree."

Visit Carol's web site to learn more tips like this one!

Free eBook: The Windows 7 Guide: From Newbies to Pros. In this 46 page guide you will be introduced to Windows 7 and what it has to offer. It will teach you about the new taskbar, how to resolve software compatibility issues, how to customize Windows Aero, and explain what the Windows 7 Libraries are all about. Also included: a detailed list of what software is included in Windows 7, and how easy networking is with Windows 7 along with other topics. The advice within this guide will help new users become acquainted with Windows 7 and can also help those who are on the fence about purchasing Windows 7 decide if it would be a good idea. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.