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 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
> Date: Tue, Dec 22, 2020 at 3:40 PM
> Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print
> To: charles meyer
>
> 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
> 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: users+unsubscr...@global.libreoffice.org
> 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
> Date: Tue, Dec 22, 2020 at 3:40 PM
> Subject: Re: [libreoffice-users] Fit last column in spreadsheet to print
> To: charles meyer
>
>
> 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
> 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 i
