Remove duplicate conditional formatting rulesĪs mentioned above, copying and pasting cells and rows can duplicate their conditional formatting rules as well.You will lose the nice formatting, but Excel will become speedy again. To do so, you can click the Conditional Formatting toolbar button, then select Clear Rules From Entire Sheet. It's a very quick and easy process to delete all of these at once. The most common cause of sluggish form definitions is many conditional formatting rules.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |