Insert a Footer in Excel If you want to add a footer to an Excel spreadsheet, click the "Insert" tab on the ribbon menu. Then click "Header & Footer" within the "Text" group of options.

Q. How can I print a worksheet name in my spreadsheets? A. You may not realize it, but you can generate very customized headers and footers in Excel.

Adding a Header Go to the "Insert" tab on the Excel toolbar, and then click the "Header & Footer" button in the Text group to start the process of adding a header.

This screenshot guide shows you hwot to create, customize and insert a watermark in Microsoft Excel using two different methods.

But when I try to put it in an Excel header, it comes out Jones Jones—no ampersand. How can I add the ampersand? A. I know it sounds like a silly omission on the part of Microsoft. Actually, it has ...