User Profile
Johan_Lannefors
Copper Contributor
Joined Aug 21, 2019
User Widgets
Recent Discussions
Re: Print a table on one page as multiple kolums.
Thanks! I have one table placed on Sheet1. I want to be able to print that table on a paper so it ends up looking like the second Picture. If I simply create lots of cell references it turns ugly once I start i remove and add rows to the source, the original table. This being due to that if i remove row 100, it will not get the data from the new row 100, but it will say there is no reference as I removed the cells (row) that it was pointing to. A strict instruction to get the data from row number 100 no matter if I add or remove rows should solve the problem.Print a table on one page as multiple kolums.
Hello I have a long table that has four columns. I want to print it so that you can view the entire table on one page. Right now I manually cut and paste the table into four or five kolumns to fit a printed page. I would like to be able to work with, sort and change the data in the table without having to re-do the cut and paste each time. I would like Excel to print the table the same way automatically even if i sort the table differently or add a row. The table has the same four colums all the time, the data and the number of rows do change. Any advice on this would be very much appreciated. Kindly Johan
