I have the following table with columns extending out to GT. Printing this would produce ~20 pages in landscape.
Is there a way to wrap or stack the columns to fit on a landscape letter size when printing to look like this? TIA
Excel Top Contributors:
April 10, 2025
Excel Top Contributors:
JA
wrap columns on same page to print
This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.
Report abuse
Details (required):
Thank you.
Reported content has been submitted
On the Page Layout tab of the ribbon, in the Page Setup group, click Print Titles.
Click in the 'Columns to repeat at left' box, then select the left two columns (the ones with Analyte and Units).
Click OK.
Check print preview to see if it does what you want.
Best wishes, HansV
https://www.eileenslounge.com
Report abuse
Details (required):
Thank you.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
JA
Hans,
I apologize as I inserted the wrong screen shot. Yes, I already had those two columns selected to repeat yet it still produces ~20 pages with a lot of white space at the bottom. So this is what I want to do, e.g., wrap or stack the columns so I can get
more on a page and reduce the number of pages. Thank you.
Report abuse
Details (required):
Thank you.
Reported content has been submitted
7 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
I fear that you'll have to rearrange the data.
---Best wishes, HansV
https://www.eileenslounge.com
Report abuse
Details (required):
Thank you.
Reported content has been submitted
1 person found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
JA
:-( Thanks Hans
Report abuse
Details (required):
Thank you.
Reported content has been submitted
1 person found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated April 15, 2025 Views 12,792 Applies to: