The Worksheet Properties button imports data (Worksheet Title, Company Name, or other text-based Worksheet Data) from Worksheet Properties. You can place more than one Worksheet Properties box and you can change the property shown in each.
-
Click
on the Worksheet Data toolbar and place a Properties box
in the Cover Page grid.
-
Right-click the box, then select Properties.
-
In the Property dropdown menu, select one item (such as Worksheet Title or Company Name) to appear in the Properties box. This item will be dynamically updated from the Worksheet.
Note: File Name, File Path, Today's Date and Short Date are linked to the Worksheet's file name, directory and the current date. -
In Horizontal Alignment, set the text to appear at Left, Center, or Right of the box.
-
In Vertical Alignment, set text to appear at Top, Center, or Bottom of the box.
-
Click Apply to see how these settings appear.
-
Click OK to accept them and exit.