However, the ampersand is used in Excel headers and footers as a marker that indicates a special formatting code follows.

Well show you the trick to including an ampersand in your header or footer text.

For our example, were going to add a header to our workbook, so click Custom Header.

You can enter your text in the Left section, Center section, or Right section, depending on where in the header or footer you want the text to display.

Notice that the header text displays in the sample header with one ampersand.

Click OK. Your header or footer will now display one ampersand when you print the worksheet or workbook.

Shes been a senior technical writer, worked as a programmer, and has even run her own multi-location business.

Since we launched in 2006, our articles have been read more than 1 billion times.

Say for example, you are creating a document for your client and you wish to have the company name, logo, etc.

You can vary things like page number, section-based header and footer, even-odd page sequences and a lot more.

And to learn the process of printing your companys logo on each page, read on.

Steps to Insert a Logo on MS Excel Header We suggest that you begin with a blank document, create a template with whatever designdata you want and save it for future references and usage.

So, here we go:- Step 1: Navigate to the documents Insert tab and click on Header Footer as highlighted in the image below.

Here, you need to choose the position (left, center, right) to insert the logo.

Do not confuse this option with the default Insert - Picture thing.

Step 4: When you have selected the picture, the header box will be filled with text as shown below.

Do not worry; the picture is there (click anywhere outside the header and check).

What is it that you prefer Will you use this approach now onwards Tell us in the comments section.

Did You Know In 2013, Qualcomm sold the OmniTRACS business to Vista Equity Partners.

Image In Excel For Mac Header