Header and Footer Codes
| &A | Prints the name of the workbook or worksheet tab ?? |
| &B | Turns bold printing on or off |
| &C | Centres the characters to follow |
| &D | Prints the current date |
| &[Date] | Prints the current date |
| &E | Turns double-underline printing on or off |
| &F | Prints the name of the document |
| &[File] | Workbook name |
| &I | Turns italic printing on or off |
| &L | Left aligns the characters to follow |
| &N | Prints the total number of pages in the document |
| &R | Right aligns the characters that follow |
| &S | Turns strikethrough printing on or off |
| &T | Prints the current time |
| &[Tab] | Worksheet name |
| &U | Turns underline printing on or off |
| &X | Turns superscript printing on or off |
| &Y | Turns subscript printing on or off |
| &P+number | Prints the page number plus the specified number |
| &P-number | Prints the page number minus the specified number |
| &[Page] | Current page number |
| &[Path] | Folder path of the workbook |
| &[Picture] | Picture has been inserted |
| && | Prints a single ampersand |
| & "fontname" | Prints the characters in the specified font. Be sure to include the double quotation marks |
| &nn | Prints the characters in the specified font size. two-digit number to specify size in points |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext