LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
John Britten
 
Posts: n/a
Default How do I reduce the range of a saved worksheet?

I have been working on a file with several worksheets. Each worksheet was
only about 15 columns wide by 50 lines long. Somehow, before the most recent
save, the size of the file went from 3MB to 12MB. No new columns or rows
were added from the previous save. The only thing I have noticed that has
changed is that when I press the Ctrl and End keys, I am taken to the cell
AM1566 in each worksheet. There is no data in any cells beyond Column O, Row
50.

I have tried deleting all rows and columns out to AM1566 except for those I
am using but this did not fix the problem.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Print Range Help waxwing Excel Worksheet Functions 2 February 21st 05 03:47 PM
Field , Date range and Sum from worksheet import Jim e boy New Users to Excel 0 February 19th 05 05:11 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Executing macro for all worksheet from a different worksheet Biti New Users to Excel 3 December 8th 04 10:05 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"