Display ‘&’ in the footer(Excel 2007)

             The ampersand sign (&) is a special symbol which is not printed by default.

             The ampersand sign (&) is a special symbol which is not printed by default. If you have ever tried to add an ampersand symbol in the footer, you might have also noticed that the ampersand sign disappears on print. If you need to print this symbol, you can do so with very little hassles. Open the workbook which requires to be printed, then on the status bar, click the ‘Page Layout’ option. Now place your cursor on any one of the three sections where you need to enter the "&" symbol. Now press [Shift] + [7] combination twice from your alphanumeric keypad. Notice the & sign appears twice (&&). Click outside the footer area, you will now notice the ampersand symbol in your footer.