You can automatically fill data that follows a series or continues formatting from other cells.
-
Select one or more cells you want to use as a basis for filling additional cells.
-
Move the cursor to the bottom right corner of the selected cell, and drag the cross (+) to as many as cells as you need.
-
After you let go, select the Auto Fill Options button that appears and choose which kind of fill you want.
You can automatically fill data that follows a series or continues formatting from other cells.
-
Select one or more cells you want to use as a basis for filling additional cells.
-
Move the cursor to the bottom right corner of the selected cell, and drag the cross (+) to as many as cells as you need.