Work & learning / Documents & workFit Excel printing to one page: what to check when text gets too small
To put the whole table on one sheet, set both Width and Height to 1 page in Page Layout. For a long table, that may make text too small. If you only need to keep columns together, use Width: 1 page and Height: Automatic, after checking the print area and orientation.
Read article