Duplicate or unnecessary conditional formatting can make your Google Sheets sluggish. It can also lead to confusing or conflicting formatting rules across your sheet. To prevent duplicate formatting rules, you should know how to copy cell values without conditional formatting in Google Sheets.

When you copy a cell in Google Sheets, everything in that cell is copied. This includes values, conditional formatting, regular formatting, data validation, and formulas. When you paste it into another cell, all these elements get transferred.

For example, if cell A1 contains a conditional formatting rule, copying and pasting its content into cell B1 will transfer the conditional formatting along with the value, formula, or data validation from A1.

Furthermore, if B1 already has a conditional formatting rule, pasting from A1 will not override it. Instead, it will keep the existing rule(s) plus the copied rule.

Do you know how to stop Google Sheets from copying conditional formatting? Check out the tips and examples below.

Quick Answer:

To copy cell values without conditional formatting in Google Sheets, use Paste special → Values only or Formula only instead of regular paste. This prevents conditional formatting rules from being copied.

How to Copy Cell Values Without Conditional Formatting in Google Sheets

You can’t copy a cell’s content in different ways in Google Sheets since there is only one copy option. However, you can paste the content in different ways. So, the key to copying a cell value without conditional formatting lies in how you paste the copied content.

Let’s see an example.

Assume that I have applied a conditional formatting rule in cell C1: if the value is “Yes,” the cell is highlighted in light red. To set this up, navigate to cell C1, click Format > Conditional formatting, select Text is exactly, and enter “Yes” in the field below.

If you copy cell C1 and paste it into another cell, the same conditional formatting rule will be applied to the new cell.

Here’s how to copy a cell value and paste it without carrying over the conditional formatting rule:

1. In cell C1, press Ctrl+C (Windows) or ⌘ + C (Mac) to copy the cell’s content.
2. In cell D1 (or any target cell), right-click and select Paste special > Formula only.

This will paste just the value or formula from the copied cell, excluding the conditional formatting.

If you don’t want the formula and only need the value, choose Paste special > Values only instead of formulas.

Alternative Method: Remove Conditional Formatting After Pasting

If you frequently need to copy cell values without conditional formatting, you can clear conditional formatting separately:

1. Paste the copied content normally.
2. With the pasted cell still selected, go to Format > Conditional formatting and click Remove rules (You will see a trash icon or “Remove rule” when you hover your mouse over the rule).

This method removes any inherited formatting from the copied cell. However, be careful not to delete any rules specifically set for the paste range, if any.

Conclusion

Copying cell values without conditional formatting in Google Sheets is simple once you understand how paste options work. By using Paste special → Formula only or Values only, you can prevent unnecessary formatting rules from being duplicated and keep your spreadsheets clean and efficient.

The alternative workaround of removing rules after pasting can also help, but it requires extra care to avoid deleting existing formatting unintentionally.

This tutorial is part of The Ultimate Guide to Conditional Formatting in Google Sheets, where you can explore more techniques to manage, optimize, and troubleshoot conditional formatting effectively.

Resources

• How to Copy and Paste Data with Formulas from Google Sheets to Excel
• How to Copy Every Nth Cell from a Column in Google Sheets
• How to Copy Only Numbers from Multiple Columns in Google Sheets
• Copy an Image From One Spreadsheet to Another in Google Sheets
• Copy Punch Out to the Punch In Row in Google Sheets (Named Function)
• Copy-Paste Merged Cells Without Blank Rows/Spaces in Google Sheets