+ Reply to Thread
Results 1 to 2 of 2

reduce row range in existing worksheet to reduce file size

  1. #1
    Registered User
    Join Date
    04-23-2012
    Location
    Oakland, California
    MS-Off Ver
    Excel 2007
    Posts
    32

    reduce row range in existing worksheet to reduce file size

    I have a problem where I extended a formula down to over 40,000 records which has increased the file size substantially. I only need it to scroll down to a few thousand rows now that I realized that there is alot less data to populate the worksheet. Is there any way to get it back to a scroll range that is more modest in size?

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,844

    Re: reduce row range in existing worksheet to reduce file size

    You should be able to select a row number around where you want your data to end (by clicking on the row label) then press Ctrl + Shift + Down Arrow to select every row to the bottom of the sheet, then choose CLEAR :: ALL.

    Once you re-save your document, the scroll region should be updated.

    - Moo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Reduce File size
    By pedjvak in forum Excel General
    Replies: 3
    Last Post: 01-22-2013, 06:30 AM
  2. How to reduce File Size
    By santoshsapre in forum Excel General
    Replies: 3
    Last Post: 06-25-2012, 09:06 AM
  3. Reduce File Size
    By djfatboyfats in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2008, 09:41 AM
  4. Reduce File Size
    By PacE in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2008, 06:44 AM
  5. Need help to reduce file size
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-11-2007, 06:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1