#Excel print selection to fit page how to

This is what the preview looks like in the example: Check the preview to make sure youвЂ™ve highlighted the correct range.This will change the print area from the entire spreadsheet to just what you selected in a previous step. Click on the вЂњPrint SettingsвЂќ menu option that says вЂњCurrent SheetвЂќ.You can do this by clicking the File menu then Print (first image), clicking the printer icon from the sub-menu (second image), or pressing the вЂњCtrl+PвЂќ(вЂњCMD+PвЂќ on Mac) keyboard shortcut. In the example below, IвЂ™ve selected the first 10 lines and the header row for a range of A1:F11.

#Excel print selection to fit page how to

The following steps explain how to set the print area in Sheets. These are the first 20 references of the spreadsheet: WeвЂ™ll be using a spreadsheet with user information for this tutorial. The important take-away from configuring the print area in Sheets is you need to do it every time you print. If youвЂ™re trying to set the print area in Google Sheets, you probably are trying to avoid using excessive amounts of paper to show a narrowed information selection. How to Set the Print Area for a Selection of Range in Google Sheets How to Set Custom Page Breaks in Google Sheets.

How to Adjust the Scale and Margin to Fit.

How to Print the Header Row(s) on Each Page.

How to Set the Print Area to Print Everything on the Sheet.

How to Set the Print Area for a Selection of Range in Google Sheets.