Ask Your Question

print a xlsx spreadsheet

asked 2019-01-14 22:34:11 +0100

updated 2019-01-14 22:40:23 +0100

I am trying to print a large spreadsheet. On the xlsx spread sheet there is a dotted line between columns E and F and also F and G. These correspond to "page breaks" such that when I print a PDF only 1/2 the page is printed then 100 pages later Column F is printed then 100 pages later Column G thru K is printed. How to I get colunms A thru K printed on the same page? I rotate to landscape and set scaling down to say 50% so now the print is smaller but only A-E is printed then.... F (same as above). Thanks for any help. Columns a Thru E is 14.97 cm, Column F is 18.42 cm G thru H is 5.42cm, I don't care if I thru K is printed or not!

edit retag flag offensive close merge delete


Show the file. RTFM won't hurt too. Pay attention to Using print ranges and Page breaks.

gabix gravatar imagegabix ( 2019-01-15 14:54:10 +0100 )edit

Hello, I don't know how to specify page breaks to change the default in this spreadsheet. I have attached a "modified version" the original has over 5000 rows.

RobertLummerding gravatar imageRobertLummerding ( 2019-01-15 23:36:55 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-01-15 23:44:40 +0100

updated 2019-01-16 00:30:36 +0100

Sorry, new to this forum. I am unsure how to change page breaks. A copy of the file is attached the origional is over 5000 rows. thanks for all help. RobertC:\fakepath\Test Spreadsheet.xlsx I found it! View > Page Break : will show spreadsheet with all the page breaks. I can then use mouse to move them! In Print Preview I can use mouse to adjust margins and the print scaling to the size I need. THanks for all help! Robert

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-14 22:34:11 +0100

Seen: 26 times

Last updated: Jan 16