With some fill operations, you may not want to copy the formats of the source cell or range to the destination cell or range. If this is the case, click the Auto Fill Options button after the range fills and then select the option you desire on the Auto Fill Options menu.

Question

Quizplus · Accepted Answer

This statement is true. After the range fills, you can click the Auto Fill Options button and select the desired option to prevent copying the formats of the source cell or range to the destination cell or range.

With Some Fill Operations, You May Not Want to Copy