CODEWITHSUNDEEP
excelcolorsautofill
Daniel Clemence
Daniel Clemence

Reputation: 1

Keep colours of cells when using autofill (Excel)

I have a formula in Excel that I would like to drag down to other cells using autofill. However, the cells below have unique colours and I do not want to remove them. Is there an easy way of autofilling the cells with my formula and keeping the colours?

Thank you in advance.

Upvotes: 0

Views: 1935

Answers (1)

MarioAna
MarioAna

Reputation: 865

Fastest way I have found is to drag using the right mouse button and when you release the button the options menu will popup automatically, just select "Fill Without Formatting".

Upvotes: 2

Related Questions