Fit last column in spreadsheet to print

classic Classic list List threaded Threaded
6 messages Options
charles meyer charles meyer
Reply | Threaded
Open this post in threaded view
|

Fit last column in spreadsheet to print

Hi all,

Woulds anyone please be willing to look at my spreadsheet file to see how I
cna fit the last column  in to print on  8/12 x 11.

It's in Excel.

Maybe Calc would do better?

Thank you.

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Alan Boba Alan Boba
Reply | Threaded
Open this post in threaded view
|

Re: Fit last column in spreadsheet to print

Hi Charles,

Your initial question was "...see how I cna fit the last column in to print
on  8/12 x 11..." which to me is equivalent to "fit all columns on a single
sheet". So the answer is to set the page width of the printout to one sheet
wide.

Not sure what to say to your follow up, "...I have no idea what I would set
the “Width in pages” to fir this spreadsheet...", because width will ALWAYS
BE set to one sheet if you want the printout to fit across one sheet. If it
has many rows then be sure to set the #of pages high by a number that will
fit everything. If set to 100 the output won't be stretched to be 100 pages
tall.

And you hit on the real trick, "...with all columns across the same page
and also in readable print..." Readable print depends on the number of
columns and the width of the sheet.

If the print isn't legible, try printing the sheet landscape. Now there's
immediately 2½" more paper to scale your columns across. If the print is
still too small then try landscape on a legal page or reduce the number of
columns that need to be seen or both.

p.s. moved back to the list. meant to reply there the first time

On Mon, Jan 4, 2021 at 2:52 PM charles meyer <[hidden email]> wrote:

> Hi Alan,
>
>
>
> I hope you’re enjoying a good new year.
>
>
>
> In Calc, I opened the spreadsheet and then held d own the mouse to
> highlight all the columns and rows of content to print.
>
>
>
> I then selected Format > Page and the Sheet tab and selected “Fit print
> range wit width/height” but I have no idea what I would set the “Width in
> pages” to fir this spreadsheet both with all columns across the same page
> and also in readable print.
>
>
>
> I tried this in Excel and I can either get all the columns across the page
> on one page but in tiny print or I can cat the font size in readable size
> but not all the columns align across the one page.
>
>
>
> Any further thoughts re: the “Width in pages” to be set to in Calc?
>
>
>
> I can’t even see how many pages this spread sheet is on as unlike Libre
> Writer or Word there is no page indicator in either Calc or Excel.
>
>
>
> Thank you.
>
>
>
> Charles.
>
>
>
> From: Alan B <[hidden email]>
> Date: Tue, Dec 22, 2020 at 3:40 PM
> Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print
> To: charles meyer <[hidden email]>
>
> Charles,
>
>
>
> Both LibreOffice Calc and Microsoft Excel include a print feature to scale
> the print range by width and height. The width and height unit used is
> number of pages.
>
>
>
> From your question I expect you want the printout to be one page wide.
>
>
>
> In Calc, select the print range then the menu Format > Page.... Select the
> Sheet tab and for scaling mode select "Fit print range(s) to width/height"
> and then specify the desired "Width in pages:".
>
>
>
> Same for Excel though I'm sure the menu path would be different.
>
>
>
> On Tue, Dec 22, 2020 at 1:49 PM charles meyer <[hidden email]>
> wrote:
>
> Hi all,
>
> Woulds anyone please be willing to look at my spreadsheet file to see how I
> cna fit the last column  in to print on  8/12 x 11.
>
> It's in Excel.
>
> Maybe Calc would do better?
>
> Thank you.
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>
>
>
> ---------- Forwarded message ---------
> From: Alan B <[hidden email]>
> Date: Tue, Dec 22, 2020 at 3:40 PM
> Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print
> To: charles meyer <[hidden email]>
>
>
> Charles,
>
> Both LibreOffice Calc and Microsoft Excel include a print feature to scale
> the print range by width and height. The width and height unit used is
> number of pages.
>
> From your question I expect you want the printout to be one page wide.
>
> In Calc, select the print range then the menu Format > Page.... Select the
> Sheet tab and for scaling mode select "Fit print range(s) to width/height"
> and then specify the desired "Width in pages:".
>
> Same for Excel though I'm sure the menu path would be different.
>
>
> On Tue, Dec 22, 2020 at 1:49 PM charles meyer <[hidden email]>
> wrote:
>
>> Hi all,
>>
>> Woulds anyone please be willing to look at my spreadsheet file to see how
>> I
>> cna fit the last column  in to print on  8/12 x 11.
>>
>> It's in Excel.
>>
>> Maybe Calc would do better?
>>
>> Thank you.
>>
>> --
>> To unsubscribe e-mail to: [hidden email]
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>
>
> --
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>
>

--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
John Kaufmann John Kaufmann
Reply | Threaded
Open this post in threaded view
|

Re: Fit last column in spreadsheet to print

On 2021-01-10 18:07, Alan B wrote:
> ...
> Your initial question was "...see how I can fit the last column in to print
> on  8/12 x 11..." which to me is equivalent to "fit all columns on a single
> sheet". So the answer is to set the page width of the printout to one sheet
> wide.

? Sorry, but I don't follow: What does it mean for a spreadsheet to print one sheet wide?
(especially in an environment where a sheet could be a million columns wide)

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Brian Barker Brian Barker
Reply | Threaded
Open this post in threaded view
|

Re: Fit last column in spreadsheet to print

At 00:21 11/01/2021 -0500, John Kaufmann wrote:
>Sorry, but I don't follow: What does it mean for a spreadsheet to
>print one sheet wide?

See "Printing options for page styles" in Chapter 6, "Printing,
Exporting, E-mailing, and Signing" of the Calc Guide.

o Go to Format | Page... | Sheet | Scale.
o Set "Scaling mode" to "Fit print range(s) to width/height" and
"Width in pages" to 1.

>... (especially in an environment where a sheet could be a million
>columns wide)

In that case, you would have chosen to make your printed data
probably illegible! (Er, sorry, but maximum columns per sheet is 1024.)

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

John Kaufmann John Kaufmann
Reply | Threaded
Open this post in threaded view
|

Re: Fit last column in spreadsheet to print

On 2021-01-11 00:45, Brian Barker wrote:
> At 00:21 11/01/2021 -0500, John Kaufmann wrote:
>> Sorry, but I don't follow: What does it mean for a spreadsheet to print one sheet wide?
>
> See "Printing options for page styles" in Chapter 6, "Printing, Exporting, E-mailing, and Signing" of the Calc Guide.
>
> o Go to Format | Page... | Sheet | Scale.
> o Set "Scaling mode" to "Fit print range(s) to width/height" and "Width in pages" to 1.

Very nice! I had overlooked that. Thanks, Brian.
 
>> ... (especially in an environment where a sheet could be a million columns wide)
>
> ... (Er, sorry, but maximum columns per sheet is 1024.)

I did exaggerate, didn't I? 10^6 high, but only 10^3 (AMJ) wide. I should have checked.

> I trust this helps.

You bet. Thanks again,
John

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
John Kaufmann John Kaufmann
Reply | Threaded
Open this post in threaded view
|

Re: Fit last column in spreadsheet to print

On 2021-01-11 01:14, John Kaufmann wrote:

> On 2021-01-11 00:45, Brian Barker wrote:
>> At 00:21 11/01/2021 -0500, John Kaufmann wrote:
>>> Sorry, but I don't follow: What does it mean for a spreadsheet to print one sheet wide?
>>
>> See "Printing options for page styles" in Chapter 6, "Printing, Exporting, E-mailing, and Signing" of the Calc Guide.
>>
>> o Go to Format | Page... | Sheet | Scale.
>> o Set "Scaling mode" to "Fit print range(s) to width/height" and "Width in pages" to 1.
>
> Very nice! I had overlooked that. Thanks, Brian.
>
>>> ... (especially in an environment where a sheet could be a million columns wide)
>>
>> ... (Er, sorry, but maximum columns per sheet is 1024.)
>
> I did exaggerate, didn't I? 10^6 high, but only 10^3 (AMJ) wide. I should have checked.

Um, sorry: That should be 2^20 high by 2^10 (AMJ) wide.
[That was sloppy.]

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy