Filling in a series in Excel
1. Select the first cell in the range you want to fill, and then enter the starting value for the series.
To increment the series by a specified amount, select the next cell in the range and enter the next item in the series. The difference between the two starting items determines the amount by which the series is incremented.
2. Select the cell or cells that contain the starting values.
3. Drag the fill handle over the range you want to fill.
To fill in increasing order, drag down or to the right.
To fill in decreasing order, drag up or to the left.
The easiest way to use this is by selecting two cells and then hover your mouse pointer over the Fill Handle until it changes to a small black cross. Do a left click and drag the selection in the direction in which you want the incremented item to show.
Example:
Enter Today’s date in cell A1 and make sure that the cell pointer goes back to cell A1. Next, grab the fill handle and drag down the column. You will see the last date of the last cell in the range. Once you release the mouse button, Excel adds dates as needed.
To specify the type of series, use the right mouse button to drag the fill handle over the range, and then click the appropriate command on the shortcut menu. For example, if the starting value is the date JAN-2009, click Fill Months for the series FEB-2009, MAR-2009, and so on; or click Fill Years for the series JAN-2010, JAN-2010, and so on.
Make the best of the Auto Fill tool by adding your own custom lists within your organization such as a series of department titles or employees’ names to your spreadsheets you can create a custom list and then use Auto Fill to quickly filling in your information.
This site needs an editor - click to learn more!
You Should Also Read:
Forensic Accounting Quizzes
From Cash Basis to Accrual Basis
Enabling Fraud Environments
Related Articles
Editor's Picks Articles
Top Ten Articles
Previous Features
Site Map
Content copyright © 2023 by Consuelo Herrera, CAMS, CFE. All rights reserved.
This content was written by Consuelo Herrera, CAMS, CFE. If you wish to use this content in any manner, you need written permission. Contact
BellaOnline Administration
for details.