Fit last column in spreadsheet to print

users
#1

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.

#2

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

#3

? 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)

#4

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

#5

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

#6

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