Ajeesh Wants to Format His Excel Table So That Every

Ajeesh wants to format his Excel table so that every other line is light yellow.He's seen this done on other reports and believes it will make his data easier to follow across rows.Ajeesh begins to apply highlighting to every other line by using the Ctrl key to select the odd rows,but worries that adding and deleting rows will ruin the consistency of his format.What is an alternate solution for Ajeesh?

A) Ajeesh should continue with his current formatting
B) use banded rows
C) Ajeesh should not apply this formatting
D) use Format Painter

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free