This will open the Document Inspector dialog box. In the options on the left, click on ‘Info’. You should see a new sheet with all the issues listed out. Below are the steps to delete all the hidden rows and columns from the workbook in Excel: Click the File option. In the Compatibility Checker dialog box click the Copy to New Sheet button However, my advice on merged cells is the same for Excel as for Numbers. It makes some things easier than Numbers. I am a daily user of both Numbers and Excel. Was ready to learn Numbers but will go out and buy Excel. In the Info section, select the Check for Issues drop-down However i do have and want some merged cells. 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. While in the above example, we checked whether the data in one column was there in. This can occur as the Source input for a List rule. Compare Two Columns Using VLOOKUP and Find Differences (Missing Data Points). Removing External Links From Data Validation RulesĮxternal Links can reside in Data Validation rules.
