Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
STUART BISSET
 
Posts: n/a
Default Printing - Have to set print area 1 column further than necessary

Thanks for the prompt response - turns out it was to do with my printer - a
Minolta QMS 3300. when I selected an HP printer as the default printer the
problem was resolved. Strange but true!!!

Stuart



"keepITcool" wrote in message
ft.com...

I've seen this before.. I think the problem is connected to
the Scaling and hidden columns..

Try to circumvent by changing the column width of B and G
from hidden (=0) to 0.1

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


wrote :

Hope you folks can help me out with a strange one.

I have several worksheets formatted in exactly the same way as
follows:


Col A - width 4
Col B - hidden
Col C - width 4
Col D - Width 108
Col E - Width 3
Col F - Width 11
Col G - Hidden
Col H - Width 11 & Empty

My print range should be Cols A:G (I have used page setup to set the
scaling to fit 1 page wide by [blank] pages tall, thus each sheet will
print as many pages as required depending on number of rows]

When I have the print range set to A:G only columns A:E show on the
print preview (and also on the actual print out) and when I make print
area A:F only A:C show on the print preview.

To get A:G printed I have to set the print area to A:H.

In all 3 of the examples above when I look at the print preview there
is a blank area on the right hand side of the page where the missing
columns SHOULD be but aren't... ie the size of the page seems to be
formatted correctly to include all the columns i want but they just
don't print unless 1 extra column is selected in the print area.

Has anyone out there experienced this problem before?
Thanks in advance.

Stuart



Reply
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
Changing print area Aaron Excel Discussion (Misc queries) 2 January 9th 05 05:58 PM
How do I only show print area in excel? Jeffro Excel Discussion (Misc queries) 5 January 7th 05 02:08 AM
In Excel print area setup problem with 2 different computers with. Rafi Setting up and Configuration of Excel 1 December 22nd 04 10:44 AM
"print column titles" fe Excel Discussion (Misc queries) 1 November 30th 04 08:12 PM
print a specific area within a worksheet by clicking on print? honclub Excel Worksheet Functions 1 October 29th 04 03:22 AM


All times are GMT +1. The time now is 02:48 AM.

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

About Us

"It's about Microsoft Excel"