AndyPandy
asked on
Print wrapped columns in Excel 2010
Hi Experts,
How can I get "Excel 2010" to print wrapped columns?
I have two narrow columns within a worksheet.
I would like to wrap(snake) the columns so that a printed page is filled before going to print the next sheet.
So rows 1 through 60 are in the first two columns page 1, the next 60 rows are in the 3rd & 4th columns (again page 1), etc.
Thanks
How can I get "Excel 2010" to print wrapped columns?
I have two narrow columns within a worksheet.
I would like to wrap(snake) the columns so that a printed page is filled before going to print the next sheet.
So rows 1 through 60 are in the first two columns page 1, the next 60 rows are in the 3rd & 4th columns (again page 1), etc.
Thanks
Another way is from Home -> Alignment -> Wrap Text.
And to adjust the columns visibility you may adjust the column's width and the row's height until you get your desired form to print.
I did a solution on somthing like this (there were two solutions, and mine wasn't picked. feel free to use the first, but I created a macro that broke the three columns up into page sizes and formatted a page from those columns that could be printed).
https://www.experts-exchange.com/questions/26732871/How-to-split-3-columns-on-the-same-page-in-Excel.html
Let me know if this helps and if you want to further persue, I"m happy to help!
Cheers,
Dave
https://www.experts-exchange.com/questions/26732871/How-to-split-3-columns-on-the-same-page-in-Excel.html
Let me know if this helps and if you want to further persue, I"m happy to help!
Cheers,
Dave
If you want to keep it all in Excel, the attached "wraps" to 60 rows, and operates on the first 3 columns. See attached:
The "create word" document tip in the link I sent in the post (above) is a good one, but it is a bit "manual", though a macro COULD be written to handle.
See the second attachment, rewritten to handle the first three Columns in Excel and outputs to the printed page.
If you'd like either modified to suit, or you can take it from here, please let me know!
Dave
its-quick-by-hand-r2.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks dmille, your BA worked well!
I am surprised there is not a native function within excel to do this.
Excel-columns.JPG
I am surprised there is not a native function within excel to do this.
Excel-columns.JPG
Select your cells -> right click -> format cells -> from the Alignment tab check the Wrap text then OK.