How to Keep Conditional Formatting Ranges Static in Excel for the Web
Question details
The user needs to prevent Excel for the web from automatically adjusting conditional formatting ranges when cells are moved, copied, or pasted.

- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- The user manages a workbook in Excel for the web where conditional formatting rules must keep a fixed applies-to range during structural edits.
- Observed behavior
- Excel for the web automatically shifts or expands the conditional formatting range when cells are moved, copied, or pasted, without a built-in lock option.
Open the workbook in Excel for the web and identify the exact conditional formatting rule and its current Applies To range before making any changes.
Use Excel Desktop to Manage and Restore Conditional Formatting Ranges
Best when you can open the workbook in the desktop app and need more precise control over the applies-to range before sharing it on the web.
Excel for the web does not expose a lock for conditional formatting ranges. The desktop app provides the Manage Rules dialog where you can verify or re-enter the intended range after structural changes.
Open the file in the Excel desktop app instead of Excel for the web.
Go to Home > Conditional Formatting > Manage Rules.
Select the rule, click Edit Rule, and enter or confirm the exact Applies To range you want to keep.
Save the workbook and open it again in Excel for the web if web sharing is required.

Restrict Structural Editing in Excel for the Web
Use when the workbook must stay in Excel for the web and you want to prevent users from moving or pasting cells that trigger range changes.
Manually Restore the Applies To Range After Editing
Use as a fallback when the range shifts after copy/paste and you cannot use the desktop app.
Use WPS Office as a Free Alternative for Excel Workbook Management
WPS Office opens and edits Excel .xlsx files for free with a familiar ribbon interface, making it easy to review conditional formatting rules, protect sheets, and continue working without a Microsoft 365 subscription.
- 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
- 2. Open your Excel workbook: Launch WPS Spreadsheets and open the .xlsx file you were using in Excel for the web.
- 3. Review conditional formatting and protection: Use Home > Conditional Formatting > Manage Rules to check rules, and use Review protection options to restrict structural edits.

Frequently Asked Questions
Can Excel for the web permanently lock a conditional formatting range?
No, Excel for the web does not have a built-in setting that keeps the Applies To range permanently static after moving, copying, or pasting cells. You can restore the range manually or restrict editing.
Why does my conditional formatting range change when I copy and paste?
Excel for the web automatically adjusts conditional formatting ranges as part of its normal cell edit behavior, so the Applies To range shifts to follow inserted or pasted content.
Does the Excel desktop app fix this issue?
The desktop app gives you more precise control through Home > Conditional Formatting > Manage Rules, but it does not fully lock ranges against future structural changes. You may still need to reapply the range after major edits.
Can I use VBA to keep conditional formatting ranges static in Excel for the web?
No. VBA macros do not run in Excel for the web, so this approach is not available unless the workbook is opened in desktop Excel.
Will WPS Office keep my conditional formatting ranges from changing?
WPS Office can open and edit .xlsx conditional formatting rules and includes protection options to limit structural edits, but no spreadsheet app can guarantee that a range remains static after every copy/paste action.




