When copying cell text with Ctrl + D, how do you make the cell color stay the same format?

Question

Right now, when copying text with Ctrl + D, the color from previous cell above is carried to the bottom one. How do you make that stop and keep cell color format the same for all spreadsheet?

Answer 1

Hi,

It works fine for me i.e. the formatting from the previous cell is not carried to the cell in which i press Ctrl+D. In cell A3, i pressed Ctrl+D and the formatting did not get copied.

Answer 2

Option 1: Fill without formatting

Select the cells.

Press Ctrl + D.

Click the small Auto Fill Options icon.

Choose Fill Without Formatting.

This keeps all existing cell colors exactly as they are.

Option 2: Paste values only If you don’t need formulas:

Ctrl + C

Select target cells

Ctrl + Alt + V → V → Enter

Only text is pasted — no color.

Option 3: Use formulas instead of Ctrl + D If you’re copying from the cell above:

=A1

Fill down — formulas never copy formatting.

Long-term solution (if colors should be consistent)

Use Conditional Formatting instead of manual fills:

Select the range.

Home → Conditional Formatting.

Define your color rules.

This prevents Ctrl + D from “breaking” colors because formatting is rule-based.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin