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 |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext