Printing - Have to set print area 1 column further than necessary

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

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


[email protected] 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

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> [email protected] 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