How to create a phone book with Microsoft Excel 2007

Just follow my instructions to be able to get a handy phone book always at hand on your computer. Here is how to create a phone book with Microsoft Excel 2007.

Creating the phone book

First, turn on your PC and then start the Microsoft Excel 7 program. When the program is open, you can start creating your phone book. With the mouse position yourself on the ” A3 ” box and clicking on it you will have to write ” Name “, in the same way in the following boxes of the same line you can enter the parameters that you are interested in that are present in your phone book as: ” Surname “, ” Home number “, ” Office number “, ” Fax “, ” Group “, etc.

Cell selection

Select the boxes in step 1 and make them stand out using bold or italics or changing color (these commands are present on the home screen of the program) according to your taste. Now enter in the cell ” B2 ” the title that can be ” Phone book “, then select the cells from ” B2 ” to ” H2 ” and execute the command ” Merge and Center ” otherwise, your title will not be displayed (the command is present on the home screen in the ” Alignment ” part). Change the title to your liking using the same commands as in step 1.

Display of the grid

To view the typical grid of telephone directories, use the ” All edges ” command (present on the home screen in the part called ” Character ” scrolling in the eighth parameter drop-down menu), after selecting from ” B2 ” until the end of your phonebook.

This step can be repeated as new numbers are entered and then based on how much the column increases in length. Select from ” B3 ” to ” H3 ” and make the border thicker via ” Thick border “.

Now you can make your grid more pleasing to the eye by using colors. With the ” Fill color ” command (present on the home screen in the part called ” Character ” ) and change the color of the columns or if you prefer, of the boxes in which the parameters are present.

Customization

Now the fundamental part of the column has been created; all that remains is to customize it according to your tastes. For example: you can change the color of the boxes, as already done previously, or, to protect privacy, hide some lines of the worksheet to make them invisible (by clicking on the number of the line and pressing to hide). For the rest, you can add all the changes you want, the only limit is the imagination.

Creating the preset phone book

Alternatively, to copy a Microsoft model and create a preset address book to make the data meaningful (time-saving layouts include table columns with a clearly defined heading line for categories such as names, addresses and phone numbers), each column of the table must present a sort button to sort the rows of data based on the alphabet, dimensions to facilitate the search and analysis of the contact database.

Organize the address details for quick access with a sortable table created in Microsoft Excel. Alternatively, copy a Microsoft model and create a preset address book to make the data meaningful.

These time-saving layouts include table columns with a clearly defined heading line for categories such as names, addresses and phone numbers. Each column in the table has a sort button to sort the rows of data based on the alphabet or dimensions to facilitate searching and analyzing the contact database.

Completing the address book

Complete the paper address book with an Excel sharing table. Click on the ” Insert ” tab on the command bar and click on ” Table ” in the ” Tables ” group to open the dialog box. Select ” My table has headings ” and click ” OK ” to create columns that can be ordered with the arrow buttons for sorting.

Click on the table to display the toolbar with the ” Design ” tab. Click on the ” Design ” tab to show style tools, such as the thumbnail gallery in the ” Table Styles ” group. For example, click the ” Other ” button to open the chart that includes the ” Customize ” sections. Select the preferred thumbnail to update the color and design of the table.

Click on a cell, type in the data and then press ” Tab ” to move the cursor to the next cell. Press ” Ctrl-S ” to save this workbook. Click on the ” File ” tab on the ribbon and then select ” New ” to open the list of models. Enter ” Phone Book ” (without quotes) in the ” Search online templates ” box and press ” Enter ” to display previews in the search results.