Return to course

Dive into Excel 2007

Before you begin

During the practice, this window will stay on top of the program you are working in. When it covers an area you need to use, move and resize it as follows:

• To move this window, click the title bar of the window (as shown below) and drag it to a new location:

  

• To resize this window, drag the resize handle in the lower-right corner.

You'll start work on the Home tab, because that's where many of the most common tasks are done.

Exercise 1: Enter text

1. The Home tab at the top of the Ribbon should be highlighted (it should appear lighter than the other tabs, as shown in the picture). If it isn't, click it.
2. In cell A1, type Product Name, and then press ENTER. The text is too long for the cell; it spills over into cell B1. Next you'll wrap the text so that it fits into cell A1.
3. Click in cell A1.
4. On the Home tab, in the Alignment group, click the Wrap Text button .

   A single click wraps the text.

   Do you recall the steps to wrap text in earlier versions of Excel? You would have opened the Format Cells dialog box by clicking Cells on the Format menu. Then you would have clicked the Alignment tab. Then you would have selected the Wrap text check box, and then you would have clicked OK.

5. In the Alignment group, click the Dialog Box Launcher arrow in the lower-right corner. The Format Cells dialog box opens. Any time you see this arrow , you can open a dialog box or a task pane to see more options.

   For now, click Cancel to close the dialog box.

Exercise 2: Change document view

In this exercise you'll change views and change magnification.

1. At the lower right of the screen, locate the View toolbar.
2. Click the middle button on the toolbar, Page Layout View, to change to Page Layout view. Or click the View tab on the Ribbon, and then click Page Layout View in the Workbook Views group.

   Now the column and row headings are above the worksheet grid.

3. Now you'll zoom in and out of the worksheet. To do this, click the minus sign (-) or the plus sign (+) to the right of the toolbar.

   

   If you click the minus sign several times, you can see several worksheets at once in Page Layout view. The indicator to the left of the minus sign shows you the percentage of the magnification. Click the plus sign until you get back to 100%.

Exercise 3: Adjust column width in Page Layout view

In this exercise you'll adjust column width in the new view.

1. In cell B1, type text that will be too long to fit into the cell: Quantity per Unit. Press ENTER, and then click in cell B1 again.

2. Instead of wrapping the text so that it will fit, you'll make the column wider to fit the text.

3. On the Home tab, in the Cells group, click the arrow next to Format, and then under Cell Size, click AutoFit Column Width.

   The column width automatically changes to fit the text in the cell.

   To use the double-click method to change the column width, point at the right edge of the column heading until you see a cross with a double-headed arrow in it, and then double-click. Remember, in Page Layout view, the column headings (A, B, C, and so on) do not sit on the worksheet as they do in Normal view. Instead, they are up above the white space, beneath the ruler.

   

Exercise 4: Show or hide white space in Page Layout view

In this exercise you'll see how to work with less white space in Page Layout view.

1. Move the pointer into the space between the top of the page and the column headings (A, B, C, and so on).

   

2. When the pointer turns into two arrows, click once.

   The white space is hidden.

   

   To show the white space again, point at the same space until you see two arrows pointing away from each other. Click once.

   Note    You can hide or show all the white space on the page by clicking in any area, at the top, side, or bottom of a page. You can also do the same thing by pressing CTRL+SHIFT+W.

3. Change back to Normal view. Click the View tab, and then click Normal in the Workbook Views group. Or on the View toolbar, click the Normal button on the left.

Exercise 5: Add and delete a button on the Quick Access Toolbar

In this exercise you'll see how to add and delete buttons on the Quick Access Toolbar.

Method 1: Right-click to add a Ribbon button

1. At the top of the Ribbon, click the Data tab.
2. In the Sort & Filter group, right-click the Filter button. Then click Add to Quick Access Toolbar.

   Now the Filter button is on the toolbar.

   

Method 2: Add a button by customizing the toolbar

Use this method to add buttons that aren't already on the Ribbon.

1. Click the arrow on the right end of the Quick Access Toolbar.

   You'll see a list of commonly used commands that you can add to the toolbar, such as New to create a new workbook, E-mail, and Quick Print. Clicking any button on the list will add it to the Quick Access Toolbar.

   Now click More Commands near the bottom of the list.

2. Click the arrow under the Choose commands from box. You'll see a list of the different locations from which you can select commands to add to the Quick Access Toolbar. Select Office Menu.
3. In the lower box, in the list for Office Menu, select Excel 97-2003 Workbook.
4. Click Add. The Excel 97-2003 Workbook button is added to the column on the right.

   As soon as you add a button to the column on the right, the Move Up button becomes available. After you click the Move Up button, the Move Down button also becomes available. You can use these two buttons to change the button order on the Quick Access Toolbar.

5. Click OK. Now the Quick Access Toolbar contains the Excel 97-2003 Workbook button you added. The button is close at hand whenever you want to save a file in that format.
6. Click the arrow on the right side of the toolbar again. Click Show Below the Ribbon. The toolbar moves to its own row just below the Ribbon. You may want to move the Quick Access Toolbar below the Ribbon if you put a lot of buttons on the toolbar and the tabs on the Ribbon are squeezed for space.

   For now, click the arrow on the end of the toolbar once again, and then click Show Above the Ribbon.

Delete a button

• Right-click a button you added on the Quick Access Toolbar.
• Click Remove from Quick Access Toolbar.

Return to course