For filling data that increased by a fixed unit, you must have at least data in two cells. The data can be numbers, dates, month names, and days.
Example:
1. In cell A1 enter 3. In cell A2 enter 6.
2. Click and select cells A1 and A2. You will see cells A1 and A2 highlighted with a tiny black square at the lower right corner at cell A2. This tiny black square is called the fill handle.
3. Place the mouse over the fill handle and drag it down. Excel automatically values like 9, 12, 15, and so on in cells in A3, A4, A5, and so on.
You may try entering Sunday in cell B1, Wednesday in cell B2 and try selecting cells B1, B2 and drag the fill handle.
Try date entries like 1/2/2011 in cell C1, 1/4/2011 in cell C2.
Try superscript and subscript entries, month names, text like World War 1, World War 2.
Example:
1. In cell A1 enter 3. In cell A2 enter 6.
2. Click and select cells A1 and A2. You will see cells A1 and A2 highlighted with a tiny black square at the lower right corner at cell A2. This tiny black square is called the fill handle.
3. Place the mouse over the fill handle and drag it down. Excel automatically values like 9, 12, 15, and so on in cells in A3, A4, A5, and so on.
You may try entering Sunday in cell B1, Wednesday in cell B2 and try selecting cells B1, B2 and drag the fill handle.
Try date entries like 1/2/2011 in cell C1, 1/4/2011 in cell C2.
Try superscript and subscript entries, month names, text like World War 1, World War 2.
0 comments:
Post a Comment