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.
In this lesson, we're going to learn how you use the Show/Hide group of commands, as wells as the Zoom group of commands, on our View tab. In my Show/Hide group of command, I have the following choices selected; I'm looking at my Gridlines, I'm having my Formula Bar and my Headings all turned on. If I deselect any one of these choices, let's see how this changes our worksheet. I need to set myself in my worksheet in order for any of these to take affect. So I'm going to just grab a few cells here by clicking and dragging in column G.
I'm then going up to my Show/Hide commands, I'm going to deselect the Gridlines by taking the check mark out of the box beside Gridlines. You'll notice when you look back at your worksheet, that all of the gridlines, or the indicators where the cells are, are gone. For those of you that like to work in an environment that matches as closely as possible your printed page, this is something you may want to select. I myself like to know more I'm going, so I prefer to have the Gridlines on, and I'm going to turn them back on by just placing the check back in the box, and the gridlines are now seen.
This Formula Bar is very nice for those of you that like to work with large formulas, and in our movies when we're discussing how to create formulas, this is a very nice way to determine what's in there. But for some of you, your eye is coming down more into your workspace here, and this is where you're actually going to be typing. So if I was going to type the word text in here, I'm looking at the box in my workspace, I'm not looking up here at my Formula Bar. So I may want to be move this Formula Bar because it does add some bulk to my screen. I can turn off the Formula Bar by just going up to the box and deselecting that box, and you see I've hidden the Formula Bar.
I can also do the same for the headings. If I'm not interested in knowing that this is column C, and this is row 3, I can turn off the headings for the rows and the columns. And I do that by, again, taking check back out of that box. So I can remove a lot of the bulk that's around my workspace if I'm not interested in using it. I can also very easily turn them back on when it's appropriate. The Zoom feature was covered in our lesson on the Print Preview, and it functions the same way here. I can click Zoom to increase the magnification of the screen. So if I select 200%, and click OK, it really brings out the size of the text that I'm looking at.
I can replace it back to the 100%, by clicking on the 100 % Command button, and I can Zoom a particular selection that I'm looking at by just clicking and dragging over the range, clicking the Zoom to Selection, and only that particular area of my spreadsheet is zoomed, and made larger. I'm going to replace this back to the 100% mark by just clicking my 100% command bar again. Notice that my screen has now shifted somewhat to the left, so I want to pull the information back into the center of the screen and I do that by using my horizontal scroll bar here at the bottom, and I just reposition the screen back to see column A.
When I'm down here, I also want to show you a nice, handy technique that you can use to zoom in as well. Rather then having to select the percentage of magnification you want, you can use this nice, little Zoom bar, and just click and drag, and Zoom increases the magnification, or decrease the magnification of the information that you're seeing on your screen. You just do that by clicking and dragging your mouse. It's really, really a cool feature. Next we're going to take a look at the Windows grouping of commands. And this is where you're going to see how you can split your windows, and have more than one window showing on your screen at a time.
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.