If you have a large worksheet with formulas and you want to perform an autofill, then it may be a tedious job to drag the fill handle across hundreds of rows or columns. Here is a simple procedure to make your life easier:
1. Select the first cell in your range (the one which has a [...]
In a previous post I explained How to use Autofill with formulas.Today I will cover the same subject but from a different perspective.
Suppose you have a list of values in a certain currency and you want to convert those values to another currency based on a given currency rate. If we follow the same [...]
The Autofill feature of Excel can be applied on formulas as well as predefined lists. Let us take a simple example:
Suppose you have two columns of Quantity and Price and you want to derive a third column of Value by multiplying the quantity by the Price, then you:
Enter the formula [...]
In Excel menu click Tools.
In the Tools menu click Options.
Click the Custom Lists tab.
Click the Add button. The cursor will move the List entries edit box.
Enter the data for your list separated by commas. E.g. East, West, North, South.
Now if you enter “East” in any cell and drag the fill handle, other [...]
You can save yourself allot of typing if you know how to make use of autofill feature in Excel.
Suppose you want to enter names of days in cells A1 to A7 (Sun, Mon, …. Sat). Here is what you do:
Enter “Sun” on cell “A1”.
Drag the fill handle across the [...]
