Category Archives: MS Office

How to add filename to header or footer? | Word 2007

Go into the header mode by clicking with your right mouse button on the header and choose “Edit Header”. To add custom information go to the “Insert” section under the Header & Footer tools tab on the ribbon and click “Quick parts”. In the menu choose “Field”. You will get a list of what you can add into your header. Find “Filename” from the list. Choose how you want the data to be formated. If you want the file path also then add check to “Add path to filename”. Press “OK” to finish.

Continue reading →

How to add a data table to a chart? | Excel 2007

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Data Table” and from the appearing menu choose whether you wish for the table to show up in the first place or whether the table should include the legend keys as well. The last option is handy in case you wish to remove the legend from the chart.

Continue reading →

How to have Word automatically update certain fields of text? | Word 2007

On the ribbon there’s Quick Parts option under Insert menu. The Document Property inserts for example information pulled from properties. You can enter to your document the fields and every time you change properties or update any of the same type of field entered into the document; those fields will be updated accordingly.

Continue reading →