How To Fit An Excel Sheet On One Page - Fitting data to page in excel using page setup. Web fit worksheet on one page say you have the following data set (range a6:j6). Web shrink a worksheet to fit on one page go to page layout > dialog box launcher on the bottom right. From the page layout tab, you will find the ‘ scale to fit ’. In the scale to fit group, in the width box, select 1 page, and in the height box, select automatic. Click the page layout tab on the ribbon. If you print this data range, it would be on two pages. Web below are the steps to scale down the sheet while printing: In the page setup dialog box, select the page tab. Web how to fit to page in excel (print on one sheet) method 1:
Web how to fit to page in excel (print on one sheet) method 1: If you print this data range, it would be on two pages. In the scale to fit group, in the width box, select 1 page, and in the height box, select automatic. Fitting data to page in excel using page setup. In the page setup dialog box, select the page tab. Click the page layout tab on the ribbon. From the page layout tab, you will find the ‘ scale to fit ’. Web shrink a worksheet to fit on one page go to page layout > dialog box launcher on the bottom right. Web below are the steps to scale down the sheet while printing: Web fit worksheet on one page say you have the following data set (range a6:j6).