Forum Discussion
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...
Please see link below for further guidance. It's matter of scaling your page set up, there are many ways to skin this cat.
However, given the amount of data you have it wont read nicely cramped into a single page. From the second screen shoot i notice that you have many tables on one sheet?
https://support.office.com/en-us/article/fit-to-one-page-f3015be3-e007-4762-90a7-19ebc8052511
Hope I helped somehow.
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.
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.