Sometimes we apply formatting to an entire sheet or an entire group of rows or columns. But sometimes we do mistakes while applying conditional formatting. In excel, Conditional formatting visualizes data and makes worksheets easier to understand.
After this clear the blank cells as we did earlier. This will automatically find the blank areas of your Excel workbook.
On that box tick on the Blanks and press OK. On the Home tab, Press Find & Select and then press Go To Special. The arrow signs indicate where you want to put your command.Īfter selecting the blank cells, In the Home tab on the Clear option press Clear all. If you want to select the entire blank cells just click CTRL+Shift+ ↓+ → together. Removing the formatting from these blank cells reduces your file size. Sometimes you accidentally do some formatting in these unused cells which actually increases your file size. Hence you often won’t see your XLSB files working everywhere.Ģ) Deleting/Clearing blank cells in ExcelĪfter you complete a task in the Excel workbook, there are so many unused cells that have no usefulness in your workbook.