Phone book in excel format free download

Moreover, the information is not just stored there securely, but it can also be used to perform various manipulations and comparison with other lists, etc.

How to make a phone list in Excel? To create a phone list you need at least two columns: first column will consist of first names or last names of the person or organization and second one - of the phone numbers. But you can make the list more useful by adding additional rows. The columns header may be different, some columns may be added, some deleted.

All you need is to fill out the list information. Additionally, you can conduct another manipulation: to determine the cells' format. By default, the format of each cell is listed as «General». You can leave it as it is, but for a phone number column you can specify a custom format. To do this, select cells in this column, right-click to bring up the menu, choose «Format Cells».

Among the given options select «Special». On the right you'll see a mini-list, in which you need to select «Phone Number». Any data directory is needed for easy work with information, for example, by using a single criterion to know the rest.

So, in the phone list, we can enter the required last name and get the phone number of this person. So, we have a little phone book. In reality, the firms usually have longer lists, so to look for information in them manually is very difficult.

Let's make the preform, which will contain all the information. And it will appear on specific criteria - last name, therefore we will make this item in form of a dropdown list «DATA»— «Data Validation» — «Allow:» — «List». You need to do the following: by choosing some of the last names, all other cells have to be automatically stamped with the appropriate information. We have received the following.

But where to begin to contact your old friends and customers, if you don't have good records of their contact details? Besides the name, address, phone number, email, date of last meeting, its useful to write down some reminders. Especially if you meet them on trade fairs. For those who work in Sales, they know it is important to use the latest updated address book software or templates in order to grow the business faster! After downloading and filling in the blanks, you can customize every detail, visuals, typography, font size, and appearance of your B2B or B2C contacts and finish in minutes.

Check out this phone book in excel format free download template and keep track of your customers and conversations in order to grow your business. After downloading and filling in the blanks, you can easily customize the visuals, typography, details, and appearance of your Address Book Template.

Download this Sales template now! Leave a Reply. If you have any questions or remarks, feel free to post them below. Excel Templates. Drop Shipping Supplier Compliance Sheet.

Drop Shipping Strategy Model. Dropshipping Contract Template. More topics cheese. Early to bed and early to rise probably indicates unskilled labor. Copy Code. Enter this coupon code at checkout to save at AllBusinessTemplates.