Create custom file properties

Create custom file properties for the active workbook

  1. On the File menu, click Properties.
  2. Click the Custom tab.
  3. In the Name box, type a name for the custom property, or select a name from the list.
  4. In the Type box, click the data type for the property you want to add.
  5. In the Value box, type a value for the property. The value you enter must match the selection in the Type box. For example, if you click Number in the Type box, you must type a number in the Value box. Values that don't match the property type are stored as text.
  6. Click Add.
 

Create custom file properties linked to content in the active workbook

  1. You must name the cell or range that you want to link the property to. Otherwise, the Link to content check box is unavailable.

    How?

    1. Select the cell, range of cells, or nonadjacent selections that you want to name.
    2. Click the Name box at the left end of the formula bar Formula bar.

      Name box

      1  Name box

    3. Type the name for the cells.
    4. Press ENTER.

    Note   You cannot name a cell while you are changing the contents of the cell.

     
  2. On the File menu, click Properties.
  3. Click the Custom tab.
  4. In the Name box, type a name for the custom property.
  5. Select the Link to content check box.
  6. In the Source box, click the defined content you want to link to, and then click Add.

Note   When a link is broken - for example, when a cell or range name is removed from your workbook - the file property stores the data last saved in the cell or range.