Scroll and print
 

Hi all,

I have a near empty sheet (has a few lines of data at the top of th
sheet) but when I go to print the sheet it comes out at 195 pages fo
some reason. I dont have any data at the bottom of the sheet, but exce
is picking something up that I cant see!

Any Ideas?? TI

--
gti_jober
-----------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=54463

Scroll and print
 

gti, have a look here,

http://www.mvps.org/dmcritchie/excel/lastcell.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"gti_jobert" wrote
in message ...

Hi all,

I have a near empty sheet (has a few lines of data at the top of the
sheet) but when I go to print the sheet it comes out at 195 pages for
some reason. I dont have any data at the bottom of the sheet, but excel
is picking something up that I cant see!

Any Ideas?? TIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=544639

Scroll and print
 

Hi GTI,

See Debra Dalgleish's suggestions for resetting the Used Range:

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


---
Regards,
Norman



"gti_jobert" wrote
in message ...

Hi all,

I have a near empty sheet (has a few lines of data at the top of the
sheet) but when I go to print the sheet it comes out at 195 pages for
some reason. I dont have any data at the bottom of the sheet, but excel
is picking something up that I cant see!

Any Ideas?? TIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=544639

Scroll and print
 

Hi,

reset print area.

Regards,
Ivan

Scroll and print
 

tar lar.....got it going good now


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=544639