Excel+frustration+how+to+avoid+lost+files

When you are studying a printed out Spreadsheet and would like to go back to the original in the Computer, do you suffer from the problem of trying to remember where you stored the particular file? To avoid searching etc. there is an easy way in which you can add the location of the folder to the bottom of your spreadsheet so that when it is printed it also prints where the file is located. This is simply a case of adding a Footer to the sheet, so obviously we need to open the Headers and footer Window. Go to :-
 * Excel frustration how to avoid lost files **

Now you have two ways of adding a footer. The first is select from the list of preset footers a file name from those displayed.
 * //View//** **//> Header and Footer//**

The second way is to **//Customize//** an individual one which leaves no room for mistakes.

Select the **//Custom Footer button.//** This opens a window with three sections: _ Left, center, and right sections of the footer. Select which **//Section//**by clicking in it.

Once there, there will be displayed three buttons as per diagram below. Dependent on which button you select it will print the relevant information.

The first button on the left inserts both the **//Path and File Name//****//.//** The **center** button **only** inserts **the //File Name//****//.//** The **right-hand** button inserts the **//Tab// name of the //Worksheet////.//** Also worry not if you move the folder to a different location Excel updates the data to be printed