Excel Interface 3

Lesson 3: Quick Access, Status, Zoom & Scroll

S M L XL FS | Slo Reg Fast 2x | Bookmark | Autoplay: ON

In Lesson 3, we will continue exploring the Excel interface by learning about the Quick Access Toolbar, the Status Bar, the Zoom Control, and the Scroll Bars. I will show you how to customize the Quick Access Toolbar, demonstrate the information provided on the Status Bar, and discuss how to use the different View buttons. We will also look at the Zoom controls and how to adjust your view of the spreadsheet. Finally, we will walk through how to navigate your worksheet using the horizontal and vertical scroll bars.

Navigation

Prev: Lesson 02
Next: Lesson 04

Keywords

TechHelp Excel, Excel interface, Quick Access Toolbar, Status Bar, Zoom Control, Scroll Bars, Excel views, Page Layout View, Page Break Preview, Normal View, add buttons Quick Access Toolbar, customize Status Bar, Excel navigation, Excel zoom, Excel scrol

Subscribe to Excel Interface 3
Get notifications when this page is updated

More Information

Transcript

Continuing on with the Excel interface, in lesson 3 we will learn about the Quick Access Toolbar, the Status Bar, the Zoom Control, and the Scroll Bars.

In the upper left corner of the Excel window, you will find the Quick Access Toolbar. The Quick Access Toolbar is designed to give you a place to put buttons and commands that you use on a regular basis.

When you first install Excel, all you will find on the Quick Access Toolbar is Save, Undo, and Redo. We will learn about these commands in a few minutes.

If you have commands that you use a lot, you can add them to the Quick Access Toolbar to make them always accessible, regardless of what tab you happen to be on. For example, let us say you always use bold. You can add bold to the Quick Access Toolbar by right-clicking on it and selecting Add to Quick Access Toolbar. Now you can see that bold is right up here on the Quick Access Toolbar, and you can access it no matter what tab you happen to be on. There is bold.

We will learn a lot more about customizing the Quick Access Toolbar and the Ribbon in more advanced classes. For now, I am going to remove it by right-clicking and selecting Remove from Quick Access Toolbar. You can see how easy that is.

On the bottom of the Excel window, you will find the Status Bar. The Status Bar is used to give you information about the current status of Microsoft Excel. For example, right now you can see the Status Bar says Ready. That is because it is ready for me to input some data.

If I am typing information in, you can see it changes to Enter because I am currently in data entry mode. If you select a block of numbers, you will see some interesting information about those numbers on the Status Bar. For example, down here you can see the average, the count, and the sum of the numbers that I just selected.

You can even customize the information that appears on the Status Bar, and we will learn how to do that in one of our more advanced classes.

Next to the Status Bar, you will find different Views buttons. These buttons let you switch between Normal, Page Layout, and Page Break Preview Views. We will talk about these in a lot more detail later.

You are going to spend most of your time in the default, which is Normal View. But you can use Page Layout to add headers and footers and see how your spreadsheet is going to look when it is printed. Page Break Preview will show you where the page breaks are so you can see what information is going to fall on page 2 or page 3.

In the bottom right corner of the Excel window, you will find the different Zoom controls. You can use the plus or minus buttons to zoom in or zoom out to get closer or further away from the spreadsheet data.

You are not changing the way the data is going to look on the printed page. You are just zooming in or zooming out so that you can see more or less information on the screen.

You can also grab this little slider button here, click, and drag it to zoom in or out. 100 is the default. You can also click on this 100 number here and a dialog box opens with some more options. You can go right to 200, 75, 25, or type in a custom number. I will just click Cancel.

We will talk a lot more about the Zoom controls in a future lesson. And yes, I realize I say that a lot that we will learn about more topics in future lessons. But remember, today is just the overview class. We are just going to give you a broad overview of what Excel can do and we will drill down to get more specific in future lessons.

As I always say, you have to learn how to walk before you can run. I do not want to overwhelm you with too much information at once.

Along the right side and the bottom of the spreadsheet area, you will find two scroll bars. There is a horizontal scroll bar and a vertical scroll bar. You can use the scroll bars to move down or up or left and right inside your spreadsheet. You can either click on the arrowheads or click and drag this box in the center of the scroll bar.

If you think of the scroll bar as a little elevator, you can click on the arrowheads to go up or down one floor at a time, or click on the elevator itself and drag it to go to any floor.

Intro

Quiz

Q1. What is the primary purpose of the Quick Access Toolbar in Excel?
A. To provide easy access to commands you use frequently
B. To display the contents of a selected cell
C. To manage multiple worksheets
D. To show recent documents

Q2. Which commands are included by default on the Quick Access Toolbar when you first install Excel?
A. Copy, Paste, Cut
B. Save, Undo, Redo
C. Bold, Italic, Underline
D. Print, Save As, Delete

Q3. How can you add a command, such as Bold, to the Quick Access Toolbar?
A. Drag the button onto the toolbar
B. Go to the File menu and check the Bold option
C. Right-click the Bold command and select Add to Quick Access Toolbar
D. Double-click the Bold command

Q4. How do you remove an item from the Quick Access Toolbar?
A. Right-click and select Remove from Quick Access Toolbar
B. Press the Delete key on your keyboard
C. Go to Options and deselect the item
D. Drag it off the toolbar

Q5. Where is the Status Bar located in the Excel interface?
A. At the top of the window
B. In the middle of the worksheet
C. At the bottom of the window
D. On the right-hand side

Q6. What information might the Status Bar display when you select a group of numbers?
A. Only the number of selected cells
B. The sum, average, and count of the selected numbers
C. Only the maximum value
D. Only the minimum value

Q7. What does the Status Bar display when you are ready to input data?
A. Go
B. Stop
C. Ready
D. Insert

Q8. Which of the following is NOT one of the View buttons you'll find near the Status Bar in Excel?
A. Normal View
B. Page Layout
C. Page Break Preview
D. Graph View

Q9. Which View mode is most commonly used when working in Excel?
A. Page Layout
B. Page Break Preview
C. Normal View
D. Formula View

Q10. What is the purpose of the Zoom controls in Excel?
A. To change the size of printed pages
B. To switch between worksheets
C. To zoom in or out on the spreadsheet for easier viewing
D. To change the data format

Q11. What happens when you use the Zoom slider to zoom in or out?
A. The font size of your data permanently changes
B. More or less data appears on your screen, but it does not affect the printed page
C. The worksheet is saved automatically
D. The worksheet closes

Q12. Where are the horizontal and vertical scroll bars located in Excel?
A. Only at the bottom of the Excel window
B. Only on the left side of the window
C. Along the right side and the bottom of the spreadsheet area
D. Only at the top of the worksheet

Q13. How do the scroll bars behave like an elevator?
A. They beep when you reach the end
B. You can use the arrowheads to move one row or column at a time, or drag the box to move quickly
C. They take you directly to saved bookmarks
D. You can only scroll up, not down

Answers: 1-A; 2-B; 3-C; 4-A; 5-C; 6-B; 7-C; 8-D; 9-C; 10-C; 11-B; 12-C; 13-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Excel Learning Zone will introduce some important elements of the Excel interface, including the Quick Access Toolbar, the Status Bar, the Zoom controls, and the scroll bars. My goal is to give you a solid overview so you know what these parts are and how they can make your work in Excel easier and more efficient.

In the upper left corner of the Excel window, you will see the Quick Access Toolbar. Think of this as your personal shortcut area, a place designed for the commands you use most often. By default, you will typically see Save, Undo, and Redo here. We will be talking about these commands a little later in the course.

If there is a command you find yourself using over and over, you can add it to your Quick Access Toolbar so it is always within reach, no matter what Ribbon tab you're on. For example, if you frequently use the Bold command, you can add it with a simple right-click and select Add to Quick Access Toolbar. Once you do that, Bold will always be available in the upper left part of your Excel window, ready for you to use any time. Removing a command from the Quick Access Toolbar is just as easy - just right-click on it and choose Remove from Quick Access Toolbar. We will get into deeper customization for the toolbar and the Ribbon itself in future, more advanced classes.

If you look along the bottom edge of the Excel window, you will find the Status Bar. This acts as Excel's way of providing you with information about what is happening in your worksheet. For example, when you are not doing anything in Excel, it will say Ready. If you start typing in a cell, the Status Bar switches to Enter, indicating that you are in data entry mode. If you select a range of numbers, the Status Bar gives you insightful statistics like the average, count, and sum for that selection. You can adjust exactly what information appears here, and we will cover customizing the Status Bar in an advanced lesson.

Right next to the Status Bar, you will find the View buttons. These let you quickly switch between different worksheet views, such as Normal, Page Layout, and Page Break Preview. Most of your work will likely be done in Normal view, but when you want to see how your sheet will look printed, you can switch to Page Layout, which shows headers, footers, and how the printed page will appear. Page Break Preview is handy for showing exactly where your page breaks fall, so you know what will print on which page.

In the lower right-hand corner of Excel, you will see the Zoom controls. These allow you to zoom in or zoom out on your worksheet. This only affects how your sheet appears on screen - it will not change how your data looks on the printed page. You can use the plus and minus buttons to make the sheet larger or smaller, or grab the slider handle to drag for more fine-tuned control. The default zoom level is 100 percent, but you can select preset options like 200 percent or 75 percent, or type in your own custom percentage. There is also a dialog box that lets you do this in more detail. We will spend more time on working with Zoom controls in an upcoming lesson.

Finally, along the bottom and right side of your worksheet area, you have the horizontal and vertical scroll bars. These work just like the elevators you find in a building. You can click the arrow buttons to move up, down, left, or right one "floor" at a time, or drag the scroll box (the little elevator) to quickly jump to another part of your spreadsheet. This makes it easy to navigate large sheets without a lot of clicking or scrolling.

Remember, this lesson is a big-picture overview. As we move forward in this course, I will get more specific with each topic. It is important to build a strong foundation before moving on to more advanced Excel skills. Take your time learning where everything is, and do not worry - you will have plenty of opportunity to practice and get comfortable with these features.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Quick Access Toolbar overview
Adding commands to the Quick Access Toolbar
Removing commands from the Quick Access Toolbar
Status Bar overview and function
Status Bar modes: Ready and Enter
Viewing average, count, and sum on the Status Bar
View buttons: Normal, Page Layout, Page Break Preview
Default Normal View explanation
Using Page Layout for print preview
Using Page Break Preview to view page breaks
Zoom controls explanation and usage
Zooming in and out with slider and buttons
Accessing the Zoom dialog for custom zoom
Horizontal and vertical scroll bars
Navigating with scroll bars and arrowheads

Article

Let us take a closer look at some important features in the Microsoft Excel interface that can help you work more efficiently. These include the Quick Access Toolbar, the Status Bar, the Zoom controls, and the scroll bars.

In the upper left corner of the Excel window is the Quick Access Toolbar. This is designed to give you a place to keep commands that you use often, so you can get to them quickly, no matter what you are doing in the rest of Excel. By default, the Quick Access Toolbar comes with Save, Undo, and Redo commands. If there are other tools you use all the time, you can add them here for easy access. For example, if you find yourself using the Bold command frequently, just right-click on the Bold button in the Ribbon and select Add to Quick Access Toolbar. Once you do that, Bold will always be right up on the Quick Access Toolbar and available on any tab. If you add a command and later decide you do not need it, you can just right-click on it in the Quick Access Toolbar and select Remove from Quick Access Toolbar. This makes it easy to keep this area organized with only the shortcuts you really need.

Moving to the bottom of the Excel window, you will see the Status Bar. The Status Bar gives you information about what Excel is doing at the moment. For example, if you are simply looking at your spreadsheet without typing, it shows Ready, meaning Excel is ready for you to do something. As soon as you start typing in a cell, it changes to Enter, indicating that you are in data entry mode. The Status Bar also provides real-time summaries when you select a range of cells containing numbers. For instance, if you highlight several cells with sales numbers, Excel immediately displays the average, count, and sum of the selected numbers on the Status Bar. This gives you quick insights without needing any formulas.

You can also customize what appears on the Status Bar. For example, you can choose to display the minimum or maximum values, or see other types of data related to your selection. Customizing the Status Bar is a helpful way to tailor Excel to fit the way you work.

Next to the Status Bar, you will find buttons that let you switch between different worksheet views. There are three main views: Normal, Page Layout, and Page Break Preview. Most of the time, you will be using Normal view, which is best for entering and editing data. Page Layout view gives you a preview of how your spreadsheet will look when printed and allows you to add headers and footers. Page Break Preview helps you see where pages will break when you print your worksheet, which is especially useful for making sure your spreadsheet prints exactly as you want.

In the lower right corner of the Excel window, you will find the Zoom controls. These let you zoom in to get a closer look at your data or zoom out to see more of your spreadsheet at once. You can click the plus or minus buttons to increase or decrease the zoom level gradually, or you can drag the slider for more control. The default zoom level is 100 percent. If you click on the number showing the current zoom (like 100), a dialog box will appear where you can quickly choose another preset zoom level or type in a custom number. Zooming only changes how much of your spreadsheet you see on your screen; it does not affect the way your data will look when printed.

Finally, along the right and bottom edges of your spreadsheet area are the scroll bars. There is a horizontal scroll bar for moving left and right, and a vertical scroll bar for moving up and down. These help you navigate through large spreadsheets without using the arrow keys. You can click on the arrowheads at either end of a scroll bar to move one step at a time, or you can click and drag the scroll box, sometimes called the elevator, to move quickly through your data.

By getting comfortable with these features, you can make your Excel experience faster and more efficient. You will find that simple tasks become easier and navigation becomes much smoother once you know where these tools are and how to use them.

Primary Topics

Quick Access Toolbar, Status Bar, Zoom Controls, Views buttons, Scroll Bars, customizing interface

Secondary Topics

customizing toolbar, customizing status bar, view modes