Step 13 : Select the correct printer and click on the OK button. Step 12: To print the Excel spreadsheet, click on the Office Button and select the Print option. Step 11: To preview the spreadsheet before printing, click on the Print Preview icon in the Quick Access Toolbar. Select All Borders from the dropdown menu to draw the all the borders around the selected cells in the spreadsheet. Click on the Borders icon in the Font group under the Home tab in the Ribbon to select a way to define the border around the selected text. Note that all cells between A2 and I11 will be selected. To add a border to the cells, select cell A2 and hold down the key while moving the mouse to cell I11 and clicking. Step 9: To center-align the text in the City, State, Postal code, and Phone columns, highlight cells D3 to G11, click on the C enter Justify icon in the Alignment group under the Home tab in the Ribbon to center-align the selected text. The text in each selected cell will be aligned to the center. Step 8: To center-align the text in the header row, select this row and click on the Center Justify icon in the Alignment group under the Home tab in the Ribbon. You should now have a blue background with white text for the header row (cells A1 to I2). Select a white color from the dropdown font color box. Step 7: To change the font color of the header row, highlight this row (cells A1 through I2) and click on the Font Color icon in the Font group under the Home tab in the Ribbon. Select a blue color from the dropdown color box and see the cell color change in the highlighted cells. While this row is selected, click on the Fill Color icon in the Font group under the Home tab in the Ribbon to display all the colors available for filling these cells.

Step 6: To color the cells in the header row, first highlight the header row (cells A1 through I2).

Now, click on the Bold icon in the Font group under the Home tab in the Ribbon (circled below) to make the highlighted text bold. Step 5 : To make the text in the header row of the Address Book bold, click on cell A1, hold the key down, and click on cell I2, so that all the cells from A1 to I2 are highlighted. Step 4 : To store contact information in the Address Book, use the same procedure to type in the contact information given below, from Cell A3 to Cell I11. Step 3: To add the contact information headers, click on Cell A2 and type First Name in cell B2 type Last Name, in cell C2 type Address, in cell D2 type City, in cell E2 type State, in cell F2 type Postal Code, in Cell G2 type Phone, in cell H2 type Email, and in cell I2 type Comments. Step 2: Click on Cell D1 in Row 1 and type Address Book. Select All Programs, then Microsoft Office, then click on Microsoft Excel to start the Excel application. Step 1: Start the Microsoft Excel Application by clicking on the Start button at the bottom left corner of the Window.

Excel 2007 tutorial 15