Why do I print blank pages?

[Selene]

I have several files that do this to me. If I do a CTRL-End it takes me to a
blank cell way past where my data stops. What's going on here?

 

[Guest]

Go to page break preview and move the bottom line of the worksheet (up) to the end of your data

 

[Lady Layla]

This happens when you format areas where there is no data or when you remove
data

Physically select the data tha you want to print, go to file Print area Select.



: I have several files that do this to me. If I do a CTRL-End it takes me to a
: blank cell way past where my data stops. What's going on here?
:
:

 

[Gord Dibben]

Selene

If CRTL + END takes you beyond your data, you can reset the actual used range.

Visit Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP