By Michael Barden
In this edition of Office for Mere Mortals, we will have a look at AutoFill - a powerful feature in Excel used to "automatically fill in" a series of data based on a small amount of input.
WHAT IS AUTOFILL?
Creating a useful Excel spreadsheet will often involve some level of tedious data-entry. What you may not know is that Excel has an AutoFill feature that can be used to automatically fill in a sequence of labels or values along a column or row.
By entering data in one or more cells you can use AutoFill to copy or extend the selection of recognizable patterns such as:
- Numbers: 1, 2, 3…
- Days: Monday, Tuesday, Wednesday…
- Months: January, February, March…
- Dates: 1/25/2007, 1/26/2007, 1/27/2007…
- Calendar Quarters: Q1, Q2, Q3, Q4…
- Numbered Items: Chapter 1, Chapter 2, Chapter 3…
- Formulas: SUM, AVERAGE…
Using AutoFill can vastly reduce the time you spend on manual data-entry and help ensures more reliable and consistent lists. It can save your sanity as well!
Article posted: Monday, 05 February 2007
[1] 2 3 4 Next »
[
View on Single Page ]
More from Office Watch:
|
RSS feed for this category