» Reducing the Used Area in a Sheet
CATEGORY - Excel General
VERSION - All Microsoft Excel Versions
The vertical scroll bar gets shorter as the used area of a sheet grows larger (as shown in the screenshots), 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.
Book Store:
Recommended Books:
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Harry Potter and the Order of the Phoenix (Book 5)
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Financial Reporting and Analysis (2nd Edition)
No comments have been submitted.
