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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks