If you want to add a header and footer in Excel spreadsheet, then this article will help you to do that. Microsoft Excel allows users to insert a header and footer for each page manually.

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu.

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 ...