To propagate in any area, use the Fill Handle. Select the cell with data to be copied, hover the cursor over the cell’s lower right corner until the cursor turns to a plus sign (+) or a black square, and drag up, down, left, or right to fill the cells.
If the data to be copied is a date, number, or a custom-made series, it will be incremented by one instead of just copied when the Fill Handle is used.
Suppose you need to show the months of the year in column A. So all you need to do is just type the year in column A and write down January in cell A1, drag the file Handle down to your required cell, and the months will be displayed in chronological order in column A.
0 responses on "Basics in Excel: A Beginner's Guide To Getting Started"