User Profile
Johan_Lannefors
Copper Contributor
Joined 7 years ago
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.27KViews0likes0CommentsRe: Print a table on one page as multiple kolums.
nabilmourad Theo_Bear Thank you both! I will try and explain better. I have this table with about 500 rows. And I want to be able to print it like this, even after I have been working with it adding/removing rows and data. Kindly Johan27KViews0likes4CommentsPrint 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 Johan29KViews0likes9Comments
Recent Blog Articles
No content to show