In this article, we will learn how we can reduce the used area in a sheet in Microsoft Excel. The vertical scroll bar gets shorter as the used area of a sheet grows larger thereby making it inconvenient to use. Reducing the size of the used area also reduces the size of the workbook.
Let’s take an example to understand how we can reduce the used area in a sheet.
We have a worksheet, and the size of that worksheet is 228KB.
To reduce the file size, follow below given steps:-
This way the data size will reduce from 228KB to 194KB in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.