![]() ![]() To learn more about how to fix other problems caused by excessive formatting, see the Microsoft Support article How to reset the last cell in Excel. How cleaning affects conditional formattingĬleaning excess formatting works by removing cells from the worksheet that are beyond the last cell that isn't blank For example, if you apply conditional formatting to an entire row, but your data goes out only to column V, the conditional formatting may be removed from columns beyond column V. After excess formatting has been cleared, click Yes to save changes to the sheets or No to cancel. On the Inquire tab, click Clean Excess Cell Formatting.Ĭhoose whether to clean only the active worksheet or all worksheets. To remove the excess formatting in the current worksheet, do the following:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |