Excel Tip – Reducing the used area:

The vertical scroll bar gets shorter as the used area of a sheet grows larger, making it inconvenient to use.

Reducing the size of the used area also reduces the size of the workbook.

To reduce the used area:

1. Find the last cell that contains data in the sheet.

2. Delete all rows after this cell, as well as the columns to the right of the cell that do not contain data.

3. Press Ctrl+S to save the file. The address of the last cell in the used area is updated when the file is saved.