Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Converting to Octal

Filtering Columns for Unique Values

Printing Multiple Worksheets on a Single Page

Changing the Default Font

Creating a Drawing Object

Determining a Value of a Cell

Understanding Macros

 

Embedding Your Phone Number in a Workbook

Summary: Using the custom properties in Excel, you can easily add your phone number to a workbook. This allows people to know how to contact you if they should ever have problems with the workbook. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Excel is used quite extensively in corporate environments. It is often desirable to know exactly who created a workbook, particularly if it has been months since a workbook was last reviewed. Excel keeps track of non-workbook data that can be used to help identify an author. One piece of data that could be very helpful is the phone number of the workbook's author. To specify a phone number, follow these steps:

  1. Choose Properties from the File menu. Excel displays the workbook's Properties dialog box. (To display the Properties dialog box in Excel 2007, click the Office button | Prepare | Properties. This displays an abbreviated set of properties just above your worksheet; click the down-arrow next to Document Properties and choose Advanced Properties.)
  2. Make sure the Custom tab is selected. (Click here to see a related figure.)
  3. In the list of properties at the top of the dialog box (listed in the Name control), choose Telephone Number.
  4. In the Value box, enter the phone number you want associated with the workbook.
  5. Click on Add.
  6. Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3296) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.
 
Check out PivotTables for the Faint of Heart today!