![]() ![]() You should see a new sheet with all the issues listed out. ![]() In the Compatibility Checker dialog box click the Copy to New Sheet button Also, if I wanted to delete the selected cells and move the bottom cells up, I would have to use the right click and choose delete option. Everytime I need to right click and select clear contents. ![]() In the Info section, select the Check for Issues drop-down In Excel for office 08, the delete key will not clear contents of the selected cells, only of the first one. Using The Compatibility Checker to Find Data Validation Errors: You can manually search through each of your Data Validation rules within your workbook however, that may be a daunting task if you have a lot of tabs to search through. An easier way is to use the Compatibility Checker to search for you. This can occur as the Source input for a List rule. Removing External Links From Data Validation RulesĮxternal Links can reside in Data Validation rules. Microsoft excel is a popular spreadsheet tool that you can use to manually. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |