Remove Unnecessary Formatting

The size of an Excel file can get bigger when you use lots of cell formatting. Formatting means making cells look different, like adding borders or colors. When you format a cell, it uses up more space in the file. For instance, if you put borders around a cell, it takes up more room in the file compared to a cell with no formatting. So, if you don't want your Excel file to become too large, it's a good idea to be careful with how much formatting you use. Keeping it simple can help your file stay small.


Therefore, it's advisable to eliminate any unnecessary formatting from your Excel sheet. To accomplish this, follow these instructions:


  1. Open Excel file and select the sheets that you want to remove formatting.
  2. Click the Home button at the top.
  3. In the Editing group, click the Clear button and select Clear Formats from the resulting menu.
Screenshot via Excel
Screenshot via Excel
Screenshot via Excel
Screenshot via Excel

Toplist Joint Stock Company
Address: 3rd floor, Viet Tower Building, No. 01 Thai Ha Street, Trung Liet Ward, Dong Da District, Hanoi City, Vietnam
Phone: +84369132468 - Tax code: 0108747679
Social network license number 370/GP-BTTTT issued by the Ministry of Information and Communications on September 9, 2019
Privacy Policy