» Reducing the Used Area in a Sheet
CATEGORY - Excel General
VERSION - All Microsoft Excel Versions
Why is it important to reduce the used area?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:
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Special Edition Using Microsoft Word 2002
- Business Plans Kit for Dummies (With CD-ROM)
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Flipping Properties: Generate Instant Cash Profits in Real Estate
No comments have been submitted.
