Power Excel / Exporting Data
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com’s entire library of video tutorials.
Learn More
Subtitles of the Movie
Now your Excel print options aren't going to look a whole different then what you've seen in other applications. So like before, like you've used in Word or maybe Entourage or PowerPoint you'll start with File and Print but of course there is a couple of options that can be very handy especially when you're working with spreadsheets because that's one of the most aggravating things about working with a spreadsheet is that you don't quite get printed output the way you might expect. One of the most handy tips that I can pass along is that you can select a range of cells and use the File menu and click on print and then in your print options, rather then print your active sheet as you can see here would print everything. You just print the selection and now you're just printing that selection whatever your range of cells you selected, that's the only thing that will print. Where you're sending it to of course that's stuff we've seen before and so we don't need to go over that again, but that's one thing that can certainly help you out a lot. Another thing that can help you out a lot when you're doing printing is that you can make a selection of several things in your workbook and with that selection let's say you're going to make the selection there. You can go to the File menu and set your print area, now with your print area set like this you can go back to File and Print and now you get the print area. Now the way I've done the selection there it cut off the side of that graphic but that should be an easy problem to fix and notice again with that print area selected I'm only printing out one page. So the other thing that can really help you with your Excel printing of course is not only setting your print area or printing a specific selection but also doing your set up. So on the page a lot of times it's more helpful in an Excel spreadsheet if we printed out landscape wise rather then portrait as far as the orientation. You can set margins, header and footer, again, there's nothing that's terribly new about these options here that we haven't seen in other programs. We click on OK, again now I get a view, a preview that looks like this. So this combines the changing of the page orientation with the print area that I've selected and of course if you change your mind and you want to move this or do whatever you want to, you want to include this in the print area you can go back to the file, print area, clear your print area, then make your selection once again and define this as your print area. Let's set it, let's go back and see what that might look like, let's go to print, let's see that preview, it's landscape, it includes everything we want and now we're ready to send it off to the printer and get printed output more inline with what we would expect.
Tutorial Information
| Course: | Microsoft Office 2008 for Mac |
| Author: | Brian Culp |
| SKU: | 33888 |
| ISBN: | 1-934743-74-7 |
| Release Date: | 2008-06-30 |
| Duration: | 7.5 hrs / 105 lessons |
| Captions: | Available on CD and Online University |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 98,729 Video Tutorials (23,265 free)
- Video Available as Flash or QuickTime
- Over 1026 Courses
- $30 for One Month Access
- Multi-User Discounts Available
United States 