How To Set Up An Address Book In Excel

This projection will provide step-by-step instructions for using an Excel Spreadsheet to create an Accost Book for maintaining the post-obit contact information:

Address Book

Step 1: Offset the Microsoft Excel Application by clicking on the Start push button at the bottom left corner of the Window. Select All Programs , then Microsoft Part, and then click on Microsoft Excel to commencement the Excel application.

Step ii: Click on Cell D1 in Row 1 and blazon Address Book.

Step three: To add the contact information headers, click on Cell A2 and type First Name; in cell B2 type Terminal Name, in cell C2 type Accost, in prison cell D2 type City, in cell E2 blazon State, in jail cell F2 type Postal Code, in Cell G2 type Phone, in jail cell H2 type Email, and in prison cell I2 type Comments.

Step 4 : To shop contact information in the Address Book, use the aforementioned process to blazon in the contact information given below, from Cell A3 to Cell I11.

Step 5 : To make the text in the header row of the Address Book assuming, click on cell A1, hold the <shift> central downwardly, and click on cell I2, and then that all the cells from A1 to I2 are highlighted. Now, click on the Bold icon in the Font grouping under the Home tab in the Ribbon (circled below) to brand the highlighted text bold.

Step 6: To color the cells in the header row, outset highlight the header row (cells A1 through I2). 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 bachelor for filling these cells. Select a blueish colour from the dropdown color box and come across the jail cell color modify in the highlighted cells.

Stride 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 nether the Home tab in the Ribbon. Select a white color from the dropdown font color box. You should at present take a blueish background with white text for the header row (cells A1 to I2).

Step 8: To center-align the text in the header row, select this row and click on the Center Justify icon in the Alignment grouping under the Domicile tab in the Ribbon. The text in each selected prison cell will be aligned to the center.

Stride ix: To center-align the text in the City, State, Postal code, and Phone columns, highlight cells D3 to G11, click on the Center Justify icon in the Alignment group under the Habitation tab in the Ribbon to eye-align the selected text.

Footstep ten. To add a border to the cells, select cell A2 and hold down the <shift> key while moving the mouse to cell I11 and clicking. Note that all cells betwixt A2 and I11 will be selected. Click on the Borders icon in the Font group under the Home tab in the Ribbon to select a way to ascertain the border around the selected text. Select All Borders from the dropdown menu to draw the all the borders effectually the selected cells in the spreadsheet.

Step 11: To preview the spreadsheet before printing, click on the Print Preview icon in the Quick Access Toolbar.

Footstep 12: To print the Excel spreadsheet, click on the Function Button and select the Impress selection.

Step 13 : Select the correct printer and click on the OK push.

Step 14: To save the Excel spreadsheet, click on the Office Push and select the Save Every bit selection. Type the name of the Spreadsheet (Address Book) in the File Name box, and click on the Save button.

0.000000 0.000000