The following special formatting and Visual Basic for Applications (VBA) codes can be included as a part of the header and footer properties (LeftHeader, CenterHeader, RightHeader, LeftFooter, CenterFooter, and RightFooter).
| Format code | Description |
|---|---|
| &L | Left aligns the characters that follow. |
| &C | Centers the characters that follow. |
| &R | Right aligns the characters that follow. |
| &E | Turns double-underline printing on or off. |
| &X | Turns superscript printing on or off. |
| &Y | Turns subscript printing on or off. |
| &B | Turns bold printing on or off. |
| &I | Turns italic printing on or off. |
| &U | Turns underline printing on or off. |
| &S | Turns strikethrough printing on or off. |
| &”fontname” | Prints the characters that follow in the specified font. Be sure to include the double quotation marks. |
| &nn | Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. |
| &color | Prints the characters in the specified color. User supplies a hexadecimal color value. |
| &”+” | Prints the characters that follow in the Heading font of the current theme. Be sure to include the double quotation marks. |
| &”-“ | Prints the characters that follow in the Body font of the current theme. Be sure to include the double quotation marks. |
| &K _xx_. _S_ _nnn_ | Prints the characters that follow in the specified color from the current theme. _xx_ is a two-digit number from 1 to 12 that specifies the theme color to use. _S_ _nnn_ specifies the shade (tint) of that theme color. Specify _S_ as + to produce a lighter shade; specify _S_ as – to produce a darker shade. _nnn_ is a three-digit whole number that specifies a percentage from 0 to 100. If the values that specify the theme color or shade are not within the described limits, Excel will use the nearest valid value. |
| VBA code | Description |
|---|---|
| &D | Prints the current date. |
| &T | Prints the current time. |
| &F | Prints the name of the document. |
| &A | Prints the name of the workbook tab. |
| &P | Prints the page number. |
| &P+number | Prints the page number plus the specified number. |
| &P-number | Prints the page number minus the specified number. |
| && | Prints a single ampersand. |
| &N | Prints the total number of pages in the document. |
| &Z | Prints the file path. |
| &G | Inserts an image. |
Example
The following code shows how formatting and VBA codes can be used to modify the header information and appearance.
“vb
Sub Date_Time()
ActiveSheet.PageSetup.CenterHeader = "&D &B&ITime:&I&B&T"
End Sub
“
!include[Support and feedback]