ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   WON'T print whole area (https://www.excelbanter.com/excel-discussion-misc-queries/51839-wont-print-whole-area.html)

martynjackson

WON'T print whole area
 

Anyone know how to make it so i can print off this excel sheet FULLY and
not just the dates, its put a line down and is only printing off the
dates. Anyone?

'SCREENSHOT'
(http://img.photobucket.com/albums/v4...an04/excel.jpg)


--
martynjackson
------------------------------------------------------------------------
martynjackson's Profile: http://www.excelforum.com/member.php...o&userid=28291
View this thread: http://www.excelforum.com/showthread...hreadid=478612


Nick Hodge

WON'T print whole area
 
Martyn

Under FilePage setup... check the Fit to pages wide radio button, enter 1
in 'wide' and blank out the tall. This will print on one page wide and as
many pages tall as it takes

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"martynjackson"
wrote in message
news:martynjackson.1xdl2a_1130105103.1171@excelfor um-nospam.com...

Anyone know how to make it so i can print off this excel sheet FULLY and
not just the dates, its put a line down and is only printing off the
dates. Anyone?

'SCREENSHOT'
(
http://img.photobucket.com/albums/v4...an04/excel.jpg)


--
martynjackson
------------------------------------------------------------------------
martynjackson's Profile:
http://www.excelforum.com/member.php...o&userid=28291
View this thread: http://www.excelforum.com/showthread...hreadid=478612





All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com