💻 Software

How can I specify a sheet as range in Excel?

Fresh7 days ago

Mar 15, 202631758 views

Confidence Score0%

Problem

I want to apply conditional formatting on a sheet. I used to do and then apply the formatting, but when i insert new cells or rows, this isn't included in the formatting. As you can see in the picture below, you have to give a range. Is it possible to give the entire sheet as range and how to do so?

Error Output

Ctrl + A

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: How can I specify a sheet as range in Excel?

Low Risk

For MS Office 2007 and later, use to select all cells in the entire worksheet. For MS Office 2003 and earlier, use

Awaiting Verification

Be the first to verify this fix

How can I specify a sheet as range in Excel?

Problem

Error Output

1 Fix

Fix for: How can I specify a sheet as range in Excel?

Environment