Making background cells white?

[rodduz]

Hi,

Is there a way of changing all cell backgrounds to white in one go?

I colour code the cells and use the same spreadsheet on a weekly basis which means I have to change the cells back to white before starting again on a Monday if that makes sense?

Cheers

[etaf]

click on the square box between the column letters and the row numbers
that selects the entire spreadsheet
now got to the fill icon on the ribbon and set to "no fill"

[rodduz]

Jeez, that was a really stupid question!

Cheers

[etaf]

no such thing really as a stupid question, so no problem
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here