logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel
Southwest USA


dailyclick
All times in EST

Full Schedule
g
g Accounting Site

BellaOnline's Accounting Editor

g

Filling in a series in Excel

Guest Author - Consuelo Herrera, CAMS, CFE

Quickly filling in a series is an excellent tool to streamline time. This is accomplished by using the fill handle. This feature is helpful when you need increments in any series of numbers, words, or other items. For example, if you type Monday in any cell and Tuesday in a cell that adjoins it, you can use the Fill Handle to complete this series. Of course, using this feature to fill in the months of the year, the days of the week is not a big deal, but if you have a long series of numbers, this becomes very useful. The fill handle is the square dot in the lower right corner of the selection.

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!

Add Filling+in+a+series+in+Excel to Twitter Add Filling+in+a+series+in+Excel to Facebook Add Filling+in+a+series+in+Excel to MySpace Add Filling+in+a+series+in+Excel to Del.icio.us Digg Filling+in+a+series+in+Excel Add Filling+in+a+series+in+Excel to Yahoo My Web Add Filling+in+a+series+in+Excel to Google Bookmarks Add Filling+in+a+series+in+Excel to Stumbleupon Add Filling+in+a+series+in+Excel to Reddit




Forensic Accounting Quizzes
From Cash Basis to Accrual Basis
Enabling Fraud Environments
RSS
Related Articles
Editor's Picks Articles
Top Ten Articles
Previous Features
Site Map


For FREE email updates, subscribe to the Accounting Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 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.

g


g features
Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor