CATEGORY: Excel Worksheet, Workbook VERSIONS: All Microsoft Excel Versions

To reduce the workbook size: 1. Press Ctrl+End to find the last cell in the used area within the sheet. In the screenshot, the last cell is E17. 2. Find the last cell containing data in the sheet. In the screenshot, the last cell containing data is cell C11. 3. Delete all the rows between the cells containing data to the row of the last cell in the used area. In the screenshot, the rows to delete are 12:17. 4. Delete all columns to the right of the column of the last cell containing data, up to the column of the last cell in the area used. In the screenshot, the columns to delete are D:E. 5. To quickly delete the rows, select the first row to delete (row 12 in the screenshot), press Ctrl+Shift+Down Arrow. To quickly delete the columns, select the first column to delete (column D in the screenshot), and press Ctrl+Shift+Right Arrow, press Shift+F10 and from the shortcut menu, press Delete. 6. Repeat the steps above for each sheet in the entire workbook. 7. Press Ctrl+S to save the file.

Screenshot // Reducing the Workbook Size for Quick Sending via E Mail

Rate this tip 1 2 3 4 5   RATING: 3.15   VIEWS: 16566 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

Noel wrote on December 31, 1969 19:00 EST Or forget steps 1 to 6 and just do step 7. Excel automatically corrects this (incorrect) memory of the last cell after you save the file.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Dictionary of Finance and Investment Terms Excel Charts Special Edition Using Microsoft Word 2002 The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two How to Use Financial Statements: A Guide to Understanding the Numbers The 22 Immutable Laws of Branding

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books