One of the finishing touches often applied to a worksheet is to create headers and footers that print on every page. You may have noticed that some characters won't print in a header or footer. For instance, if you work at a company named Drury & James, and you put the company name in the header or footer, it will print as Drury James, omitting the ampersand.
The reason for this is because the ampersand signals, to Excel, that the next character is "special" and represents a code controlling some aspect of what is printed. To override the effect that the ampersand has, simply use two ampersands, as in Drury && James. When you do, the first ampersand is "swallowed" by Excel and the second one actually prints.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12331) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Ampersands in Headers and Footers.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Add subtotals to a worksheet and you can instruct Excel to start each new subtotal section on a new printed page. You may ...
Discover MorePage numbers in Excel headers and footers have always been a source of frustration for users. This tip recounts one ...
Discover MoreNeed to show a custom date in the header or footer of a printout? You'll need to resort to using a macro, as described in ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2018-09-19 11:33:21
PreeTee
Thank you for the simple solution!
2014-01-02 12:35:31
Michael (Micky) Avidan
Here is a list of all the common used codes in the Headers/Footers:
&D Current date
&T Current time
&F Workbook name
&A Worksheet's name (Worksheet's tab)
&P Current page number
&P+x Current page number plus x
&N Total pages in the Workbook(!)
&& Ampersand character
Page &[Page] out of &[Pages]
--------------------------------
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2014)
ISRAEL
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2023 Sharon Parq Associates, Inc.
Comments