How do i use autofill to fill the range A9:H11 with the formatting from the range A7:H8
1 answer:
Answer:
See the explanation below
Explanation:
An image showing the range of cells is attached.
The task is to use autofill to fill the range of A9:H11 with the formatting from the range of A7:H8;
As shown in the image some cells are already filled. First, we highlight the cells A7:H8 and then we move the cursor to the end of the selected cell (precisely end of H8) over what is called Fill Handle and the cursor then turns into a black plus sign.
Hold down the right mouse button and drag over the wanted range of cells (A9:H11) and release.
A list of options is presented, this options include:
Copy cells, Fill series, Fill formatting only, Fill without formatting and so on.
From the displayed options, we select "Fill formatting only" and the cell (A9:H11) will have the same formatting as the cells (A7:H8).
You might be interested in