Page Setup group buttons of Page Layout tab Excel 2016

Page Setup group tools Page Layout MS Excel

Page Setup group buttons Microsoft Excel 2016

See Previous Post: Themes group tools Page Layout Tab Microsoft Excel 2016

So, the second group after the Themes group is the Page Setup group. Specifically, it is part of the Page Layout Tab in Microsoft Excel 2016. Notably, it’s a very important group in MS Excel program.

First of all, Margins, Orientation, Size, Print Area & Breaks buttons has th Drop down Menu. Especially, the Page Setup group tools helps in Printing of Excel documents.

The commands of the Page Setup group are the Margins and the Orientation Size etc. Then, are the Print Area, BreaksBackground and the Print Titles buttons. Further, the Normal margin, Wide margin, Narrow margin and Custom margin buttons are part of  the Margins button.

Page Setup group buttons Page Layout tab Excel – continued

Also, Orientation button tool has Portrait view and Landscape view. The Size tool comprises of Letter size, Tabloid size, Legal size, Executive size, A3 size, A4 size. AdditionallyB4 (JIS) size, B5 (JIS) size, Envelope #10 size are part of Size button. Furthermore, the Envelope Monarch size and More Paper Sizes are also available within the Size button.

Particularly, the Set Print Area and the Clear Print Area tools are available in the Print Area button. In addition, the Breaks button has the Insert Page Break, Remove Page Break and the Reset Page Break buttons. Lastly, Background button is the second last. And the Print Titles is the last button in the Page Setup group.

Firstly, the Margins button supports in setting the Page Margins for printing documents. Secondly, the Orientation button rotates the Excel document sheet into Portrait or Landscape view. Next, the Size button lets users to choose predefined default Page size for Printing Pages.

Lastly, using the Print Area user can select  and set any area on Sheet for printing. Also, the Breaks tool adds a break where they’d want to begin the next page in printed copy document. Finally, the Background button adds a picture in Excel Sheets. While, the Print Titles repeats Rows or Columns which users might like to repeat on each Printing Pages.

Page Setup group buttons of Page Layout Microsoft Excel

  • Page Setup
    • Margins
      • Normal
      • Wide
      • Narrow
    • Orientation
      • Portrait
      • Landscape
    • Size
      • Letter size
      • Tabloid size
      • Legal size
      • Executive
      • A3
      • A4
      • B4 (JIS)
      • B5 (JIS)
      • Envelope #10
      • Envelope Monarch
      • More Paper Sizes.
    • Print Area
      • Set Print Area
      • Clear Print Area
    • Breaks
      • Insert Page Break
      • Remove Page Break
      • Reset All Page Breaks
    • Background
    • Print Titles

See Next Post: Scale to Fit group Sheet Options group buttons Microsoft Excel 2016

 

Tags:

We'd be very grateful to everyone for joining with our IndiaExcel blog. So, below are some of the links to join with us.

Join Us - IndiaExcel Social - Microsoft Excel Tutorials







Excel lovers also're requested from us, to show their Love and Support. Kindly share the posts with your friends, which you liked the most from this Blog.

Thanks & Regards
Admin
"IndiaExcel" Blog. ______________________________________________________________________________

About the Author

After working on Microsoft Excel for so many years, now its time to share & spread my Experience and Knowledge, which I have gained on Excel with the world.
Myself, Piyush Kr. Pandey is an Excel enthusiast and founder of IndiaExcel.com (Learn Microsoft Excel), a website since 2016.

Kindly, Subscribe our blog email newsletters for daily vital and essential informative posts on Microsoft Excel.

Email: indiaexcelblog@gmail.com

Post a Reply

Your email address will not be published. Required fields are marked *



Top