Aug 21 2019 05:22 AM
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
Aug 22 2019 05:43 AM
Hi
You can scale your page using Page Setup:
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
Aug 22 2019 06:26 AM
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:
Hope that helps
Nabil Mourad
Aug 22 2019 06:56 AM
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
Aug 22 2019 07:25 AM
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.
Aug 22 2019 10:50 PM
Aug 23 2019 03:21 AM
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
Aug 23 2019 04:24 AM
Hi Both, agree with Nabil. I finally understand your requirements.
Try the following:
Hope that helps