SOLVED

How to fit a table on a A4 paper

%3CLINGO-SUB%20id%3D%22lingo-sub-1573896%22%20slang%3D%22en-US%22%3EHow%20to%20fit%20a%20table%20on%20a%20A4%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573896%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community%2C%20i%20did%20an%20input%2Foutput%20tables%2C%20as%20you%20can%20see%20there%20is%202%20tables%2C%20i%20wonder%20how%20to%20fit%20these%20tables%20in%20only%20one.%20After%20those%20tables%20i%20will%20work%20making%20operations%20and%20giving%20results%20for%20a%20report%2C%20so%20i%20need%20this%20worksheet%20printable%2C%20that's%20why%20i'm%20struggling%20so%20much.%20I%20required%20all%20this%20information%20in%20this%20one%20sheet%20because%20is%20more%20easy%20to%20review%2C%20to%20print%20and%20make%20copies%20on%20another%20sheets.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Anotaci%C3%B3n%202020-08-07%20151520.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F211030iD07B32C5AB4976C6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Anotaci%C3%B3n%202020-08-07%20151520.png%22%20alt%3D%22Anotaci%C3%B3n%202020-08-07%20151520.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPS1%3A%20This%20was%20an%20old%20work%2C%20my%20ex-boss%20required%20me%20to%20merge%20all%20data%20in%20one%20sheet%20because%20there%20was%202%20sheets%20in%20one%20workbook.%3C%2FP%3E%3CP%3EPS2%3A%20My%20problem%20is%20the%20space%2C%20if%20i%20merge%20all%20data%20in%20one%20table%20it%20probably%20wont%20fit%20in%20a%20A4%20paper%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1573896%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1575192%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20fit%20a%20table%20on%20a%20A4%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1575192%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F752998%22%20target%3D%22_blank%22%3E%40GJoe_CI%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20be%20able%20to%20set%20the%20print%20layout%20so%20it%20will%20print%20horizontally%20(AKA%20%22landscape%22%20mode).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1578927%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20fit%20a%20table%20on%20a%20A4%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1578927%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20your%20for%20your%20advice%2C%20it%20works%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello community, i did an input/output tables, as you can see there is 2 tables, i wonder how to fit these tables in only one. After those tables i will work making operations and giving results for a report, so i need this worksheet printable, that's why i'm struggling so much. I required all this information in this one sheet because is more easy to review, to print and make copies on another sheets. 

Anotación 2020-08-07 151520.png

 

PS1: This was an old work, my ex-boss required me to merge all data in one sheet because there was 2 sheets in one workbook.

PS2: My problem is the space, if i merge all data in one table it probably wont fit in a A4 paper

2 Replies
Highlighted
Best Response confirmed by GJoe_CI (Occasional Contributor)
Solution

@GJoe_CI 

 

You should be able to set the print layout so it will print horizontally (AKA "landscape" mode).

 

 

Highlighted

@mathetes 

 

Thank your for your advice, it works