Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I get '&' to print within the Header of a Excel Worksheet?

I am having trouble getting the & to show up in the Header of an Excel
Spreadsheet. What am I doing wrong? For example: Smith & Smith
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I get '&' to print within the Header of a Excel Worksheet?

Use two ampersands. The first one gets eaten by Excel.

Francis Hayes (The Excel Addict)
http://www.TheExcelAddict.com
  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default How do I get '&' to print within the Header of a Excel Workshe

mmmmmmmm ampersands....

"ExcelNut" wrote:

Use two ampersands. The first one gets eaten by Excel.

Francis Hayes (The Excel Addict)
http://www.TheExcelAddict.com
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Header Doesn't Print climber Excel Discussion (Misc queries) 1 September 8th 09 07:10 PM
Can't print a header with Excel 2007 beta PLUMMER Excel Discussion (Misc queries) 0 July 18th 06 11:11 PM
In excel print header on firt page only roberte Excel Discussion (Misc queries) 2 May 14th 06 09:07 PM
I want a title to print on every page of a worksheet; not a header DeltaPearl Excel Discussion (Misc queries) 2 February 2nd 06 05:43 PM
How can I print a different header on each page of an Excel Sheet Fatrad Excel Discussion (Misc queries) 2 June 30th 05 07:20 PM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"