Keyboard Shortcut to Remove Conditional Formatting
To remove Conditional formatting rules from the selected range of cells use ALT + H + L + C + S
Note: To use the keyboard shortcut provided above, begin by highlighting the cells from which you wish to remove the Conditional Formatting. Afterward, press the designated keys.
Conditional Formatting in Excel
Excel Conditional Formatting is a handy feature that helps you visualize data and understand your spreadsheets better. Consider a worksheet that has tens of thousands of rows of data. Simply by looking at the raw data – patterns and trends would be very difficult to spot. By applying formatting rules to cells, anyone can spot patterns easily and changes in your data. With a range of preset formatting options and customization choices, conditional formatting provides flexibility as well as efficiency in analyzing and data presentation.
Contact Us