Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
Auto Fill In Excel.
Posted by - NA - on 30 March 2006 05:50 AM
|
|
Solution: Excel's Auto Fill works fine, but it does have a few quirks. For example, if you want to enter a series beginning with 1, you'll end up with nothing but ones, unless you know the trick. Here's the trick: type a 1 into cell A1. Hold down the Ctrl key and grab the cell highlighted by the little handle at the lower right corner. Drag down and you'll get 1, 2, 3, 4, etc. If you drag down without using the Ctrl key, you'll get 1, 1, 1, 1 … Auto increase year 1. Type 1991 on cell A 2. Type 1992 on cell B 3. Highlight both cells 4. Copy it down | |
|
Comments (0)