Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
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
Find answers to the most frequently asked questions about Excel 2007 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.