In Excel, you can print your worksheets just the way they look after you enter the data, or you can enhance the printout using several page layout options. When you select Excel’s Page Setup command, the Page Setup dialog box offers four tabs: Page, Margins, Header/Footer, and Sheet.
Changing the Page Margins
Margins are the empty spaces around the four edges of a page. Setting margins in Excel is very easy to do on the Margins tab in the Page Setup dialog box. You can change the margins before, during, or after you enter data in a worksheet.
Excel presets the top and bottom margins at 1″ and the left and right margins at 0.75.” You can adjust the margins for the top, bottom, left, and right sides of a page, as well as set the header and footer margins. The steps are
- Click the File menu and choose Page Setup. The Page Setup dialog box opens.
Click the Margins tab. Excel shows you a sample page with the margin settings surrounding the page