Subject:
Computers and TechnologyAuthor:
hollyCreated:
1 year agoAnswer:
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).
Author:
columbamurray
Rate an answer:
6To perform the autofill process, we take the following steps :
Autofill option in Excel allows a certain formating option used in a cell or range of cells to be copied to a preferred cell range easily by simply dragging our mouse over the preferred range.
Author:
johnqlpy
Rate an answer:
3Rate an answer:
0Don't worry! There are several alternative approaches you can try to resolve your query. Here are some tips to help you find answers in different ways:
Remember, the process of finding answers often involves persistence, creativity, and an open mind. By exploring various resources, reaching out to others, and being proactive in your search, you increase your chances of finding the information you need. Happy quest for knowledge!