ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get the "&" to appear in a custom header? (https://www.excelbanter.com/excel-discussion-misc-queries/106642-how-do-i-get-appear-custom-header.html)

megmicwil

How do I get the "&" to appear in a custom header?
 
I cannot get the "&" to appear in the print preiew or in the print of my
worksheet. I have inserted it in my custom header and I can see it, but not
when I look at the print preview or printed version. How can I get this to
appear?

JE McGimpsey

How do I get the "&" to appear in a custom header?
 
The '&' is an escape character in headers and footers. To see the &, use
two in a row: &&



In article ,
megmicwil wrote:

I cannot get the "&" to appear in the print preiew or in the print of my
worksheet. I have inserted it in my custom header and I can see it, but not
when I look at the print preview or printed version. How can I get this to
appear?


Gord Dibben

How do I get the "&" to appear in a custom header?
 
Double it up

AT&&T returns AT&T


Gord Dibben MS Excel MVP

On Wed, 23 Aug 2006 08:07:02 -0700, megmicwil
wrote:

I cannot get the "&" to appear in the print preiew or in the print of my
worksheet. I have inserted it in my custom header and I can see it, but not
when I look at the print preview or printed version. How can I get this to
appear?




All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com