Excel inserts the appropriate header/footer code preceded by an ampersand (&) into the header or footer These codes are replaced by the actual information (filename, worksheet name, graphic image, and the like) as soon as you click another section of the header or footer or finish the header or footer by clicking the mouse pointer outside of it For example, a company with an ampersand in their name–like our fictional "Smith & Jones" law firm–may want to put their name in the header However, the ampersand is used in Excel headers and footers as a "marker" that indicates a special formatting code follows We'll show you the trick to including an ampersand in your headerCheck the Excel Essentials Course https//coursesxelpluscom/p/learnexcelessentialsQuickly learn how to insert header and footer information to your Exce
Add Headers Or Footers To An Excel Spreadsheet Learnthat Com Free Tutorial