MOS Lesson 5

What is Auto-Hide Ribbon?

Another window view option that does not appear in the Workbook Views group in the Ribbon is the full screen view. At the upper right of the Excel window, click the Ribbon Display Options button then click Auto-hide Ribbon to enable this view. This option maximizes the Excel window to the screen, turns off the Ribbon, Quick Access Toolbar and Status Bar to give you more space to view the worksheet data.

Arrange All

Arrange all of the Excel windows on the screen in one of several layouts: tiled, horizontal, vertical, or cascade.

Zoom

Change the magnification percentage to zoom in and out (bigger and smaller text) on the worksheet.

Unhide

Display a dialog box listing the windows you have hidden so that you can select individual windows and redisplay them.

What is Page Layout?

Display the workbook as it will appear on the printer. For example, you can see which rows and columns will appear on which page, how wide the margins are, and the contents of the header and footer on each page. The vertical and horizontal rulers are also displayed to show the placement of all output on the page.

What is Page Break Preview?

Display watermarks on your worksheet to identify which rows and columns will appear on which pages, with the page break lines to mark the boundaries.

How many workbooks can you work on at a time?

Even though you may have multiple workbooks open at the same time, only one workbook can be active at a time. That is, you can only work on one workbook at a time. If you need to update two of them at essentially the same time, you must switch back and forth between workbooks to do the entries.

What happens with too many workbook screens?

Every open workbook will have its own window in the Excel screen. If you use the New Window feature to create a second (or more) view of any of the workbooks, you will quickly run out of available space on the screen to display all of these windows.

Why use multiple windows?

For example, you may want to do some "What-if" evaluations on a workbook. These evaluations may require that you make changes at the top of your worksheet while you view the effects on the totals at the bottom of the worksheet. Using atample, you may want to do some "What-if" evaluations on a workbook. These evaluations may require that you make changes at the top of your worksheet while you view the effects on the totals at the bottom of the worksheet. Using at least two windows on the same workbook facilitates this process. least two windows on the same workbook facilitates this process.

100%

Force the zoom back to 100% immediately.

Hide

Hide the active window from the screen. This is useful when you are working with multiple windows and you want Excel to display only specific windows.

What is the active workbook in multiple workbook windows?

In all of these view options, the active workbook is the one with the thin green border around the window edges and the workbook's filename displayed in bright white in the title bar. The other open workbooks have the workbook name displayed in a lighter shade of gray in the title bar, and the border around the window edges is light gray.

What happens in each of the split views?

In each of the split window views, you can move around to see different (or even the same) parts of the worksheet without having to continuously shift from one end of the worksheet to the other, or move rows and columns around to see the related data closer together. The operation is similar to using four different cameras simultaneously, with the ability to manipulate each one semi-independently of one another - you can point to any part of the worksheet whether they are close or far away from each other.

What is Freeze Panes?

In this option, the active cell serves as an anchor—when the feature is activated, all rows above and all columns to the left of the active cell remain in view until the feature is turned off. You may freeze more than one row or column in place. You can also freeze just the top row(s) or just the leftmost column(s).

Freeze Panes

Lock in place the rows above and the columns to the left of a selected cell while you scroll in the worksheet. Locking only the first row and first column is also an option. This option is useful to keep the headings on the screen when you are working in cells remote from those headings.

What does Arrange All in the View tab do?

On the View tab, in the Window group, the Arrange All button enables you to quickly reposition all open workbook views on the screen at the same time. When arranging the windows on the screen, you can choose from several options:

New Window

Open a second view of the workbook. This is helpful when comparing different parts of a large worksheet or different worksheets.

View Side by Side

Place two open workbooks side by side in the Excel document window. You can place the two side by side in a vertical or horizontal position.

Switch Windows

Present a list of the documents currently open in Excel. You can then bring a workbook to the front by clicking on it.

What is tiled view?

Re-arrange worksheet windows on the screen so that all windows are as square as possible and positioned next to each other.

What is the Horizontal tiled view?

Re-arrange worksheet windows on the screen so that each window stretches across the entire width of the Excel screen. Excel lays them horizontally so that you can see as many columns as possible in each worksheet.

What vertical ?

Re-arrange worksheet windows on the screen so that each window stretches from the top to the bottom of the Excel screen. Excel lines up these windows vertically so that you can see as many rows as possible in each worksheet.

What is the Cascade tiled view?

Re-arrange worksheets so that each one is on top of the next and slightly offset to give you a three-dimensional view of all open workbooks. This kind of arrangement is best when you do not want to reduce the size of each worksheet window, and you can flip between the open windows as needed.

Reset Window Position

Reset the displayed worksheets to equal sizes.

Synchronous Scrolling

Scroll through the worksheets in each pane simultaneously.

Split

Split the worksheet into two or four panes based on the cursor position.

What does the new window button in the View tab do?

The New Window button, found on the View tab, in the Window group, enables you to open another view of the active workbook. You can then arrange the workbook windows to view different parts of the workbook (either the same worksheet, or different worksheets of the same workbook) at the same time without having to scroll around the worksheet continuously to view cells that are far from each other.

What is the split feature?

The split feature enables you to have just one instance of your workbook open, but be able to view the current active worksheet using two or four window panes

What is Custom View?

This will allow you to save your current page layout settings with a name so that you can re-activate them later at any time. Another window

Why use split panes?

To help you overcome this, Excel allows you to lock the titles on the screen while you scroll to a remote part of the worksheet. Freezing panes refers to the feature that enables you to lock the top row(s) and/or left-most column(s). This feature provides you with three options from which to choose:

Why collapse the ribbon?

To increase the amount of display area available to view all of your document windows, you can also collapse the Ribbon temporarily.

How do you remove the split?

To remove the split, use one of the following methods: · On the View tab, in the Window group, click the Split button again to remove both split bars. · Drag the vertical split bar to the far left or far right of the worksheet. · Drag the horizontal split bar to the top or bottom of the worksheet. · Double-click on either of the split bars.

What happens when you use freeze panes in a current cell?

When freezing panes using the current cell, Excel locks all rows above and all columns to the left so that they will not move. Therefore, you should not freeze a block of rows and columns in the middle of the worksheet as you will not have much space to move the rest of your worksheet.

What is Freeze First Column?

When you select this option, the selection of the active cell is not important. Excel will always freeze only the one column currently displayed at the far left of the worksheet window. Like the Freeze Top Row option, be sure to verify that the left column currently displayed is the correct one to freeze.

What is Freeze Top Row?

When you select this option, the selection of the active cell is not important. Excel will always freeze only the one row currently displayed at the top of the worksheet window. Note that if the top row currently displayed on the screen is not row 1 (for example, row 20), Excel will freeze that row, even though your column titles may be in row 1.

How do you alter the location of the horizontal or vertical split bar?

You can only alter the position of either the horizontal or vertical split bar by using the mouse. To move a split bar, position your mouse pointer over the bar. When the double-headed arrow appears, press and hold the mouse button and move the bar to the new location.

What is normal workbook view?

You will see this view by default. In this view, only the worksheet rows, columns, and headers appear. The page break lines only appear if you activate a print-related feature such as inserting page breaks or seeing a print preview of the workbook.

Zoom to Selection

Zoom in or out to display the entire group of selected cells on the worksheet (subject to the minimum (10%) and maximum (400%) zoom available in Excel).