How do I adjust size of printed output in calc

[Tim Deaton]

When I print a spreadsheet in Excel, if the sheet is too large for one
page, I can adjust the size of the printed output.  I can either adjust
the size by a percentage (ie: print at 75% of normal size) or I can set
it to shrink the document so that it fits within x pages wide by y pages
long.  I can also adjust the margins of the document.  And all this is
done from either a Page Setup box that can be accessed either from the
Print Preview screen or from the "File" menu.

Where do I find this functionality in Calc?

-- Tim Deaton



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Johnny Rosenberg]

2009/11/4 Tim Deaton <tim@...>:

> When I print a spreadsheet in Excel, if the sheet is too large for one page,
> I can adjust the size of the printed output.  I can either adjust the size
> by a percentage (ie: print at 75% of normal size) or I can set it to shrink
> the document so that it fits within x pages wide by y pages long.  I can
> also adjust the margins of the document.  And all this is done from either a
> Page Setup box that can be accessed either from the Print Preview screen or
> from the "File" menu.
>
> Where do I find this functionality in Calc?
>
> -- Tim Deaton

There is no such functionality in OpenOffice.org Calc.

He he… only kidding…
File → Page Preview → Adjust the scale directly by moving that thing
you see between ”Margins” and ”Close Preview”. For more options, click
Format Page and look around among the tabs in the dialog that pops up.


Johnny Rosenberg


>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Harold Fuchs-2]

Johnny Rosenberg wrote:

> 2009/11/4 Tim Deaton <tim@...>:
>  
>> When I print a spreadsheet in Excel, if the sheet is too large for one page,
>> I can adjust the size of the printed output.  I can either adjust the size
>> by a percentage (ie: print at 75% of normal size) or I can set it to shrink
>> the document so that it fits within x pages wide by y pages long.  I can
>> also adjust the margins of the document.  And all this is done from either a
>> Page Setup box that can be accessed either from the Print Preview screen or
>> from the "File" menu.
>>
>> Where do I find this functionality in Calc?
>>
>> -- Tim Deaton
>>    
>
>
> There is no such functionality in OpenOffice.org Calc.
>
> He he… only kidding…
> File → Page Preview → Adjust the scale directly by moving that thing
> you see between ”Margins” and ”Close Preview”. For more options, click
> Format Page and look around among the tabs in the dialog that pops up.
>
>
> Johnny Rosenberg
>
>
>  
>

You can also change the font/size of individual cells, blocks of cells
or whole rows/columns. You can make the characters bold, italic,
underlined etc. etc. Use the Format>Cells menu to change the attributes
of selected cells/rows/columns.

You can also change the height of rows and the width of columns. Use
Format>Row or Format>Column.


--
Harold Fuchs
London, England
Please reply *only* to users@...

[Brian Barker]

At 11:35 04/11/2009 -0500, Tim Deaton wrote:
>When I print a spreadsheet in Excel, if the sheet is too large for
>one page, I can adjust the size of the printed output.  I can either
>adjust the size by a percentage (ie: print at 75% of normal size) or
>I can set it to shrink the document so that it fits within x pages
>wide by y pages long.  I can also adjust the margins of the
>document.  And all this is done from either a Page Setup box that
>can be accessed either from the Print Preview screen or from the "File" menu.
>
>Where do I find this functionality in Calc?

Go to Format | Page... | Sheet | Scale.  (You can also get to the
same dialogue from the Page Preview screen using the Format Page
button.)  Under "Scaling mode", you can adjust your output in three
ways: select either your scaling factor or the number of pages
vertically and horizontally (as you describe above) or just the total
number of pages.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Tim Deaton]

Brian Barker wrote:

> At 11:35 04/11/2009 -0500, Tim Deaton wrote:
>> When I print a spreadsheet in Excel, if the sheet is too large for
>> one page, I can adjust the size of the printed output. I can either
>> adjust the size by a percentage (ie: print at 75% of normal size) or
>> I can set it to shrink the document so that it fits within x pages
>> wide by y pages long. I can also adjust the margins of the document.
>> And all this is done from either a Page Setup box that can be
>> accessed either from the Print Preview screen or from the "File" menu.
>>
>> Where do I find this functionality in Calc?
>
> Go to Format | Page... | Sheet | Scale. (You can also get to the same
> dialogue from the Page Preview screen using the Format Page button.)
> Under "Scaling mode", you can adjust your output in three ways: select
> either your scaling factor or the number of pages vertically and
> horizontally (as you describe above) or just the total number of pages.
>
> I trust this helps.
>
> Brian Barker
>

----------------------------------------------------------------------------
Johnny Rosenberg wrote:
> File ? Page Preview ? Adjust the scale directly by moving that thing
> you see between ”Margins” and ”Close Preview”. For more options, click
> Format Page and look around among the tabs in the dialog that pops up.
>
>
> Johnny Rosenberg


Thanks to both Brian & Johnny. Between you, those solutions are exactly
what I was looking for.
-- Tim


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Johnny Rosenberg]

2009/11/6 Tim Deaton <tim@...>:

>
> Brian Barker wrote:
>>
>> At 11:35 04/11/2009 -0500, Tim Deaton wrote:
>>>
>>> When I print a spreadsheet in Excel, if the sheet is too large for one
>>> page, I can adjust the size of the printed output. I can either adjust the
>>> size by a percentage (ie: print at 75% of normal size) or I can set it to
>>> shrink the document so that it fits within x pages wide by y pages long. I
>>> can also adjust the margins of the document. And all this is done from
>>> either a Page Setup box that can be accessed either from the Print Preview
>>> screen or from the "File" menu.
>>>
>>> Where do I find this functionality in Calc?
>>
>> Go to Format | Page... | Sheet | Scale. (You can also get to the same
>> dialogue from the Page Preview screen using the Format Page button.) Under
>> "Scaling mode", you can adjust your output in three ways: select either your
>> scaling factor or the number of pages vertically and horizontally (as you
>> describe above) or just the total number of pages.
>>
>> I trust this helps.
>>
>> Brian Barker
>>
> ----------------------------------------------------------------------------
> Johnny Rosenberg wrote:
>>
>> File ? Page Preview ? Adjust the scale directly by moving that thing
>> you see between ”Margins” and ”Close Preview”.

Oops… somewhere something is not supporting UTF-8… Those question
marks were supposed to be right arrows (”→” = U+2192).

>> For more options, click
>> Format Page and look around among the tabs in the dialog that pops up.
>>
>>
>> Johnny Rosenberg
>
>
> Thanks to both Brian & Johnny. Between you, those solutions are exactly what
> I was looking for.
> -- Tim

You're welcome

Johnny Rosenberg

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...