Lesson 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

In this lesson, I’m going to be showing you how to:

  1. Understand what is Scale to Fit in Excel or Shrink pages
  2. Use scale to fit to print on a desired number of pages in Excel

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered anything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 33 – How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Or go back to:

Lesson 31 – Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 30 – Best method to format numbers to display as PERCENTAGES in Excel

Lesson 29 – Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28 – A simple DIVISION formula in Excel | How to DIVIDE in Excel

Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25 – Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24 – How to SORT data in ASCENDING order in Excel

Lesson 23 – Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22 – How to RENAME a worksheet in Excel

Lesson 21 – How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20 – How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19 – What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18 – What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17 – How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16 – What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15 – Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?

Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?

Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

22 thoughts on “Lesson 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel”

  1. Habib, thank you for posting about this on your awesome site! I never knew about this let alone how to do it until now! I can definitely see a positive use for it in my use of excel in the future. Your method of teaching is very easy to follow & straightforward. Thank you for taking this time to help educate myself & others! I have heard there are functions on excel used to translate words, is this true? Do you have any lessons on that?

    Reply
    • Thank you Vince for your kind feedback, much appreciated.

      Yes, you can translate words in Excel, using the Microsoft translator. You don’t need to use a function, it’s pretty straight forward. However, I have not done a tutorial on that yet, but will put it in my list of tutorials to do. Take care

      Habib (ICT tutor)

      Reply
  2. Hello Habib. Just like all your other lessons, this one how to scale and fit is just great. Easy to understand. If you don’t use exel often, you tend to forget some of its features. Thank you for the great lesson. Looking forward to the next. All the best

    Reply
    • Thank you Felicity – This is why practice every so often is required and hence I’ve created my website and YouTube channel, where my videos lessons are always available for yourself or anyone to watch and practice their excel skills. Next few lessons are already published, check them out 🙂

      Habib (ICT tutor)

      Reply
    • Thank you very much Fares for your lovely comment. I’m happy to have been helpful by teaching you about the scale to fit feature in excel. Take care 🙂

      Habib (ICT tutor)

      Reply
  3. Your lessons are amazing, I enjoyed this one on What is Scale to Fit in Excel? I find your tutorials much more helpful than those in the help section of excel.

    Reply
    • Thank you Kay, and happy to hear you find my lessons easier than the help section in Excel. Hope you have learnt everything about the scale to fit feature in Excel now. Take care

      Habib (ICT tutor)

      Reply
  4. Woah you are definitely doing a great job here.
    I simply think this page must be bookmarked for everyone that uses Excel. You have done a thorough job and with a lot of diligence. Keep up the good job. If I have a site to recommend about Excel, I will definitely recommend this one. Why don’t you make tutorials and place them at Udemy, you will definitely make more money.

    Reply
    • Thank you very much Mr Charles. I want to share my lessons with the world for FREE and let the people all over the globe benefit from my FREE lessons. I believe everyone should get free education. One of my goals is to reach every corner of the globe with my website and YouTube channel, so everyone can have access to my free lessons I’m creating. Take care

      Habib (ICT tutor)

      Reply
  5. Thanks for this great tutorial on scale to fit in Excel. I learned a lot of great stuff in school, but how to use Excel to its fullest wasn’t something I was taught.

    I love learning new things and will follow your lessons so that I can get better with using Excel. There’s so much to learn about it!

    I have rental property on a rent to own contract and need to know how to set up a spreadsheet for amortization, with formulas to help keep track of interest, principle, and money’s paid in.

    Do you have any lessons that might cover any of that?

    Thanks for sharing! I’m a new subscriber!

    Devara

    Reply
    • Thank you very much Devara for your detailed feedback, comment and question. In regards to your question, I don’t have any direct lessons on amortization, however if you start from lesson 1, you will be able to work them out.

      I always focus on teaching everyone the principles and get you to understand what they do and then how to implement the feature. If you complete all lessons, starting from, lesson 1, as they are sequential, then you will be able to create your very own amortization spreadsheet all by yourself – now wouldn’t that be rewarding. 🙂

      Habib (ICT tutor)

      Reply
  6. Wow, every time I watch your tutorials I’m baffled at how much I didn’t know about excel. I never knew what scale to fit even meant until I watched this. I will surely recommend your website and Youtube channel to my friends who need tutorials on excel!

    Reply
    • Excel is a very technical software and is very rewarding when you get it working. Many features there is to learn about, so don’t worry if you are coming across new learning, and I’m sure this wont be the last time either.
      Thank you for sharing our site and YouTube channel with your friends, I’m very confident they will love it and learn a lot 🙂

      Habib (ICT tutor)

      Reply
  7. Great lessons!! I’m so thankful for ALL of your amazing lessons!! Keep sharing and thanks especially for What is Scale to Fit in Excel?

    Reply
    • Thank you Alyse – Happy to hear you found the lessons amazing. I will carry on making many more tutorial lessons. All the best.

      Habib (ICT tutor)

      Reply
  8. Another great lesson!

    I’ve decided to show your content to my kids as they start to use Excel or similar formats, I think if I saw this years ago I’d be a professional by now, lol.

    I knew I needed to learn a lot more in Excel but I now realise I’ve barely scratched the surface. Going to have to put a couple of hours aside for this, I think!

    Keep up the good work!

    Tony

    Reply
    • Thank you Tony – perhaps you can work through the lessons together with your kids, this way you will have education and spend time together. Please start from lesson 1. Take care

      Habib (ICT tutor)

      Reply
  9. Hi there,

    Well I’m working my way through your lessons and it’s making me wonder where I have spent my time. I’ve been using Excel for years, seen these functions daily and never bothered to learn them or try them out. Thankfully, I’m learning with each lesson and you’re delivering it so clearly. This will come in handy when fitting content to printed pages too.

    Sharon

    Reply
    • Happy to hear you’re working through all the lessons Sharon. That’s the key thing to do with my lessons as they are designed as sequential. Yes, using the scale to fit you can decide how many pages you want to print your spreadsheet on 🙂

      Habib (ICT tutor)

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap