Scale to Fit group and Sheet Options group buttons Microsoft Excel

Scale to Fit group and Sheet Options group MS Excel

Scale to Fit group and Sheet Options group buttons Excel

See Previous Post: Page Setup group buttons Page Layout tab MS Excel 2016

We’ve already discussed about the 1st (Themes group) and the 2nd (Page Setup group) in previous post. Now, we’ll know try to know about the Scale to Fit group and the Sheet Options group. These groups are part of the Page Layout tab ribbon. Also, the Scale to Fit group is third and fourth is the Sheet Options group in the Microsoft Excel 2016.

First of all, Scale to Fit group contains the Width, Height and Scale buttons tools. Next, Gridlines and Headings options contains View check box and Print check box on under each sides. So, the Gridlines, Headings, View and Print all are available in Sheet Options groups.

Scale to Fit group and Sheet Options group tools Excel

Especially, the Width, Height & the Scale have Drop down buttons in the Scale to Fit group. Also, these buttons adjusts the width, height and scale ratio of the document worksheet. The Width button shrinks width of printout to fit in a least possible amount of pages.

Similarly, using the Height button, height of printout gets shrunk, to fit in a least possible amount of pages. Furthermore, automatic adjustment of Width and Height gets set using Scale button tool. So, the View check box buttons shows the Rows, Column lines, Column headings and the Row numbers of worksheet.

Then, the Print check box buttons prints the Rows, Column lines, Column headings and the Row numbers of worksheet. Lastly, the View and the Print check boxes button makes documents more easier to read. It is because of the enabled lines, printed rows and the columns.

Scale to Fit group and Sheet Options group commands Excel

  • Scale to Fit
    • Width
    • Height
    • Scale
  • Sheet Options
    • Gridlines
      • View
      • Print
    • Headings
      • View
      • Print

See Next Post: Arrange group tools Page Layout tab 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