Loading...

TapGen

Free online tutorials

img

Page Setup in Excel is an option that helps users ensure that their spreadsheet looks good when printed or shared. This functionality includes options for adjusting page margins, page orientation, paper size, and scaling.

With Page Setup, Excel empowers users to create professional-looking reports and data presentations efficiently for printing and PDF. 

In this article, we will learn 

  • Page Layout and Printing
  • How do you set the print layout in Excel​​​​​​?
  • How to Fit an Excel Sheet on One Page
  • How to Set Print Area in Excel

Watch the video below to learn more about MS Excel Page layout and Printing.

How to make an Excel sheet print area

To print an MS Excel sheet correctly and look professional, you must set up the print area and choose the right orientation.

Step 01: To make visible a print area mark, go to the file - > click print. don't do anything else. then go back to the sheet.

When you come back to the sheet you will get a print area line. 

Watch the video if you don't understand that. https://youtu.be/j7ZbPK5_YsQ?t=120

Configure Page Setup Options

  • Go to the Page Layout tab on the Ribbon.
  • Click on Orientation of the Page Layout group.

  • Orientation: Choose between Portrait (vertical) or Landscape (horizontal).

Setup Page Margins

What is page margins in MS Excel: Page margins is the blank spaces around your worksheet or page. Sometimes you need to adjust the margins to make your data fit in print.

If you have any other questions or need further examples, let us know and upload the question in our forum tapgen.xyz

Learn MS Excel with the world's largest web developer site. Not sure where to begin? Learn MS Excel with Tapgen step-by-step tutorial.

=================================
Share This Article
icon

New to Communities?

Join the community