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 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
Hi
You can scale your page using Page Setup:
- Click the Page Layout tab in the Ribbon.
- In the Page Setup group, click the dialog box launcher on the bottom right corner of the group. The Page Setup dialog box appears.
- Click the Page tab.
- Enter a scale amount or choose Fit to Page options.
- Click OK. Be sure to preview the result.
or you can press Ctrl + P and manager your print settings from the back stage.
Hope i understood your question correctly and was able to assist
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!
Hello
What you need to do is a bit different that what I understood from the original question!!
You need to set MULTIPLE print areas and then print them side by side.
You my be able to do that in one of the following techniques:
Method One:
This post talks about the same issue:
https://excel.tips.net/T002779_Multiple_Print_Areas_on_a_Single_Printed_Page.html
Method Two:
Use the "Camera Tool" it's a hidden tool that you need to add to quick Access Toolbar. It will help you take a dynamic screenshot of the Four Ranges, put them side by side on another sheet, resize them the way you like then print the worksheet.
Alternatively you can copy each range and Paste Special AS LINKED PICTURE, then do the same as with the Camera tool.
Hope that helps
Nabil Mourad
Hi Both, agree with Nabil. I finally understand your requirements.
Try the following:
- Right-click a worksheet tab at the bottom of the window and click “Select All Sheets.” Or, hold down the Ctrl key and click individual sheets that you want to include in the printing.
- Click the small arrow to the bottom right of the Page Layout tab, which will default to the Page tab.
- Select the Fit To option under Scaling, and set it to 1 page wide by 1 page tall.
- Click the Print button this box.
- Select the Print Active Sheets button under the Setting header, then select Print Entire Workbook.
- Click Print.
Hope that helps
