In this chapter
Using the Mini Toolbar to Format Selected Text 54
Zooming In and Out on a Worksheet 59
Using the Status Bar to Add Numbers 60
Switching Between Normal View, Page Break Preview, and Page Layout View Modes 61
Using the New Sheet Icon to Add Worksheets 63
Although the ribbon and Quick Access toolbar are likely to be the most talked-about features in the new Excel interface, several other features are worth mentioning:
The Mini toolbar is a shy attendant. When you select some text, almost imperceptibly, the Mini toolbar faintly appears above the text.
If you ignore the Mini toolbar, it fades away. However, if you move the mouse toward the Mini toolbar, the toolbar solidifies and offers you several text formatting options.
Note
Microsoft began experimenting with fading toolbars in Outlook 2003. In that version, a new message toolbar would fade into view in the lower-right corner of your screen. You could glance down and read the first line of the email. You could ignore the toolbar, and the message would be waiting for you later in your inbox. Or you could move the mouse toward the notifier, and it would stay long enough for you to click Delete or Open. I enjoyed this feature of Outlook 2003. If my attention needed to stay on the task at hand, I could ignore the notifier, and it would unobtrusively fade away. However, if I was waiting for a message, I could handle it as it came in, avoiding a buildup of messages in my inbox.
The new Mini toolbar is another feature that fades in if you move toward it and fades out if you ignore it. I expect to see more fade-in/fade-out features in future versions of Office.
In your initial use of Excel 2007, you might not see the Mini toolbar. Although you often select cells or ranges of cells, it is rare to select only a portion of a cell value in Cell Edit mode.
However, as you begin using charts, SmartArt diagrams, and text boxes, you will have the Mini toolbar appearing frequently.
To use the Mini toolbar, you follow these steps:
The Mini toolbar appears faintly. On some computers and with some color schemes, “faintly” actually means “completely transparently.”
Initially, it is difficult to see the Mini toolbar. In Figure 3.1, look for the word Magneto just above the year 2005 on the x-axis. This word is the font name drop-down in the Mini toolbar. Plus, this is the second level of visibility; you actually have to have started moving your mouse toward the Mini toolbar in order to get it to appear this much.
If you continue moving the mouse toward the Mini toolbar, it solidifies a bit more. In Figure 3.2, the mouse pointer is just outside the border of the Mini toolbar. At this point, you can start to identify all the controls on it.
In Figure 3.3, the Mini toolbar is completely visible. At this point, you can use any of its 14 controls in order to format the selected text.
In the top row, the Mini toolbar offers five controls:
In the bottom row, the Mini toolbar offers nine controls:
After you have formatted the selected text by using the Mini toolbar, you might want to apply the same formatting to other text. To do so, you follow these steps:
Caution
Using the Format Painter icon is difficult to master. You only get one click to apply the formatting. If you inadvertently click on a nontext element, you lose the Format Painter mouse pointer.
The Format Painter command in the Clipboard group of the Home ribbon is a bit easier to use than the Format Painter icon. You can double-click this command to keep the application in Format Painter mode. You are then free to click multiple objects, applying the format to various elements.
The shyness of the Mini toolbar might be the most frustrating part of using it. If you move the mouse away from the Mini toolbar, it fades away. If you immediately move back toward the Mini toolbar, it comes back. If you use the mouse for some other task, such as scrolling, the Mini toolbar permanently goes away. In this case, you might have to re-select the text in order to get the Mini toolbar to come back.
If you are annoyed by the Mini toolbar, you can turn it off for all Excel workbooks. Here’s what you do:
Formulas range from very simple to the very complex. As people began writing longer and longer formulas in Excel, an annoying problem began to appear: If the formula for a selected cell was longer than the formula bar, the formula bar would wrap and extend over the worksheet (see Figure 3.6). In many cases, the formula would obscure the first few rows of the worksheet. This was frustrating, especially if the selected cell was in the top few rows of the spreadsheet.
Excel 2007 features a new formula bar that prevents the formula from obscuring the spreadsheet. For example, in Figure 3.7, Cell E4 contains a formula that is longer than the formula bar. Notice the two new controls at the right end of the formula bar: a scrollbar and Expand Formula Bar icon (which looks like a down-pointing double arrow).
You use the formula bar scrollbar to scroll through the formula, one line at a time. You use the Expand Formula Bar icon to expand the formula bar. As shown in Figure 3.8, expanding the formula bar actually moves the grid down. This way, you can see the formula bar and still see the cells in the grid, too. In expanded mode, the Expand Formula Bar icon is replaced by a double up-pointing arrow that you can use to contract the formula bar back to one line.
After you collapse the formula bar, Excel has the annoying tendency to show only the last line of the formula. This could be confusing, especially if you look in the formula bar to learn whether a cell starts with an equals sign. For example, someone new to the spreadsheet shown in Figure 3.9 might not understand that Cell E4 contains a formula.
In the lower-right corner of the Excel window, a new Zoom slider allows you to zoom from 400% to 10% with lightning speed. You simply drag the slider to the right to zoom in and to the left to zoom out. The Zoom Out and Zoom In buttons on either end of the slider allow you to adjust the zoom in 10% increments.
Figure 3.10 shows the zoom control set to the maximum zoom of 400%.
At the opposite end of the zoom spectrum, the 10% view shows an overview of 158 printed pages of the worksheet. As shown in Figure 3.11, you cannot make out any numbers at a 10% zoom. However, in the 40%–60% zoom range, you can see 3 to 10 pages and actually make out the numbers in the cells.
If you select several cells that contain numeric data and then look at the status bar, at the bottom of the Excel window, you can see that the status bar reports the average, count, and sum of the selected cells (see Figure 3.12).
If you need to quickly add the contents of several cells, you can simply select the cells and look for the total in the status bar. This feature has been in Excel for a decade, yet very few people realized it was there. In prior versions of Excel, only the sum would appear, but you could right-click the sum in order to see other values, such as the average, count, minimum, and maximum.
As with past versions of Excel, in Excel 2007 you can customize which statistics are shown in the status bar. In Excel 2007, you can configure all of the status bar elements. To do so, you right-click the status bar to display the Status Bar Configuration panel. In this panel, you can see the current value of all status bar icons, whether they are hidden or not (see Figure 3.13).
To add new items to the status bar, you click them in the Status Bar Configuration panel.
Three shortcut icons in the status bar allow you to quickly switch between three view modes as shown in Figure 3.14:
In Page Layout View mode, each page is shown, along with the margins, header, and footer. A ruler appears above the pages and to the left of the pages. You can make changes in this mode in the following ways:
Because it is possible to navigate and enter formulas in any of the view modes, you might want to do actual worksheet editing in the new Page Layout View mode.
The final new control in the Excel 2007 user interface is the Insert Worksheet icon. This icon appears as a small worksheet tab with a New icon. The tab appears to the right of the last worksheet tab, as shown in Figure 3.16.
You click the icon to add a new worksheet to the end of the workbook.
After a worksheet has been added to the end of the workbook, you can drag the sheet to a new location in the middle of the workbook. Follow these steps to move a worksheet to a new location:
The worksheet will be moved to the new location.
Although using the New Worksheet icon and then dragging a worksheet to a new location is easier, you can also insert a worksheet in a particular location. To insert a worksheet to the left of the current worksheet, for example, you choose Home, Cells, Insert, Insert Sheet. The new sheet is added before the current sheet.
Alternatively, you can right-click any sheet and choose Insert. The Insert dialog appears, where you can choose to insert a worksheet or a variety of templates. The new sheet appears to the left of the selected tab.
3.147.104.230