When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. What can she do to prevent the formatting change?
A) Click the AutoFill Options button and then click Fill Without Formatting.
B) Click the AutoFill Options button and then click Fill Formatting Only.
C) Click the Paste Options button and then click Undo.
D) Click the Quick Analysis button and then click Fill Without Formatting.

Question

Quizplus · Accepted Answer

The AutoFill Options button allows you to choose how the cells are filled. Selecting "Fill Without Formatting" will copy the formula without altering the cell formatting.

When Valerie Used AutoFill to Copy a Formula, Excel Copied