Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Sometimes it's important to get more information on your spreadsheet then you'd normally would be allowed to show if you are looking at it in a print preview environment, and you want to use a Scale to Fit group of commands in order to increase or decrease the amount of information you have on your page. I've re-opened the EatCake Inventory 11A spreadsheet to demonstrate this for you. It shows up best in my Page Layout view, so I'm going scroll down to the bottom and I'm going to open that up.
So here we have our page that we were just looking at. And if I go back up to the Scale to Fit group of commands, and I click on the upward pointing arrow, so I increase the scale even slightly up to 105%, you'll notice that the information chops off now. And if I horizontally move the screen for you, you'll see that my final cost is now popped over to another page. This isn't the way I want it to work, and this is the one thing I wanted to point out to you in your Scale to Fit. Make sure that you do it in your page layout view because that is where you're going to see this kind of effect take place.
Scaling to fit is a little bit different than using your margins. In your margins, you're actually changing the size of a particular column, but in Scale to Fit, you're changing the percentage of the whole table. You're really decreasing the size of the table, and the size of your columns are staying the same. So you're just seeing the table at 90% of its original size. So that's going to allow you to get more information into a printed view. You'll notice as I've been playing with this, I've increased the whites space, and I also have another column I can even work with here if I wanted to put more information in.
How does this look if I want to print it off? We'll go back to our Print Preview icon and you'll see that the size of the columns that we're working with are the same but they're just decreased the whole percentage that's showing on this page is smaller. What you've done is you've shrunk the overall table to a percentage of its actual size, so that you can print it out on the form. Next we're going to take a look at arranging your worksheets so that you can move between different worksheets and still keep them in order
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 87406 Viewers
80 Video lessons · 136398 Viewers
59 Video lessons · 55048 Viewers
52 Video lessons · 68918 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.