I am familar with inserting footers in Excel which show the File name and Tab name ( so that I can hopefully find the right worksheet when the MD asks a difficult question!). What I was wondering was is there anyway to show the folder too, in the footer, to give me an even better chance of getting there first time!
Similarly, I use word (but less frequently). I know that you can add a footer which shows either filename or filename and path. Is there any way to set it up so that it just shows filename and part of the path (i.e. the folder in which the file is located)?