I made a table on the Excel and I need it to fit fully on an A6 format sheet. Initially I have tried to set the parameters for the table directly on Excel, though unsuccessfully. Therefore, I thought if I make the table large enough for A4, and choose 'print 4 on one page' (A4), after printing tables would automatically shrink to A4 and my problem would be solved. However, not even that I cannot make the table fully fit on an A4 for printing, I get just one shrunk table printed on an A4 sheet, making the rest 3/4 of a sheet blank.
Can please anyone help me to deal with my ignorance regarding Excel tables formatting and printing settings.
Thank you in advance.