Step 1: Open the data table, as shown below:
Step 2: Select the empty cells in the data area Grid, as shown below:
Related recommendations: "excel basic tutorial"
Step 3: Select the DIY toolbox , as shown in the figure below:
Step 4: Select the selection inverse button in the positioning reference, as shown in the figure below:
Step 5: Select the non-empty cells and modify the data uniformly, as shown in the figure below:
The above is the detailed content of How to invert selection in excel. For more information, please follow other related articles on the PHP Chinese website!