Forum Discussion
Print a table on one page as multiple kolums.
Hi
First thing you need to know that although the width is easy to fit in one page, however if you have lots of records the font might be too small when you fit them in a single page.
The Process is as follows:
- Click on the Page Layout Tab
- Click on the dialog box launcher (as shown in picture) or use the shortcut ALT, P, SP
- In the Page Setup dialog Box opens to the Page Tab
- Click the Radio Button for "Fit To". You may select to set the width to 1 and may be (if needed) set the length (Tall) to 1, 2, 3,...
- Click on the Margins Tab
- Reduce the Top Margin
- Reduce the Bottom Margin
- Center Horizontally
- Preview and Print
Hope that helps
Nabil Mourad
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 Johan
I am trying to do the same thing! I have a table that has several rows but only two columns. I normally cut and paste to make it print on one sheet, but that is tiresome having to manipulate it each time.
I know this post is older, so this is a long shot, but did you ever find a solution to this? The answers in this thread do not seem to be helpful pertaining to this exact issue.
Let me know, Thanks!
- I'm curious as well. I am literally trying to do this very same thing!!!
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.
