make excel file smaller by constraining the data range

[eac13]

hi guys,
i ve just read an article saying that by pressing cntl end you can see which data the excel takes into account. thus, if your range is large you should be able to constrain it by deleting the cells you dont even have data. for example in one of my sheets excel actually takes into account all the way down to the end. my question is how can i command it to not take into account all these values?

[FDibbins]

At some point, you did something that included the cells that far out/down, and excel remembers that.

My advice is always - press end/home and find where you land. If that is not the known last row/column of data, start deleting rows and columns until you get back to where you know your last row/column of data is.

Then save, close and reopen the file

[Tony Valko]

See this...

http://www.contextures.com/xlfaqApp.html#Unused

[eac13]

thanks my friend! it worked. my problem was i did not save the file after i did. and this works only if you save it. very valuable lesson!

[FDibbins]

If you dont save it, then it's the same as if you made no changes

[Tony Valko]

Good deal. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.