How to Create Excel 2007 Custom Properties

1. Start Excel by clicking on the icon labeled Microsoft Office Excel 2007. It may be located on your start menu, quick launch bar or desktop.
2. Click on the menu item labeled 'File' with your left mouse button, then select the line labeled 'Properties' to bring up the file properties screen. Select the Custom tab to display the Custom panel. Enter a name for the custom property or select one from the drop-down box labeled 'Name.'
3. Look at the 2 buttons on the right. They are grayed out, which means that they are not functional at this point because you have not entered a value for the property. These buttons will be labeled 'Add' or 'Delete' if the selected property does not have a value. Otherwise, they will be labeled 'Modify' and 'Delete.'
4. Select a data type from the drop-down list labeled 'Type.' Your data may be text, a date, number or logical (yes or no). Enter a value in the box labeled 'Value.' Your data must match the data type you selected. For example, if you selected a Type of Number, then Value must be numeric.
5. Notice that the buttons labeled Add and Delete or Modify and Delete are now active. You may now Add, Modify or Delete the specified value. For a new value, you would click the 'Add' button.