Microsoft Office Tutorials and References
In Depth Information
From Header to Footer
If, after selecting some stock header or footer info, you decide that you no
longer need either the header or footer printed in your report, you can
remove it. Simply click the (None) option at the top of the Header button’s or
Footer button’s drop-down menu. (Remember that the Design tab with the
Header and Footer command buttons under the Header & Footer Tools
contextual tab is selected on the Ribbon the moment you click the header or
footer in Page Layout view.)
Creating a custom header or footer
Most of the time, the stock headers and footers available on the Header
button’s and Footer button’s drop-down menus are sufficient for your
reportprinting needs. Occasionally, however, you may want to insert information
not available in these list boxes or in an arrangement that Excel doesn’t offer
in the ready-made headers and footers.
For those times, you need to use the command buttons that appear in the
Header & Footer Elements group of the Design tab on the Header & Footer
Tools contextual tab. These command buttons enable you to blend your own
information with that generated by Excel into different sections of the custom
header or footer you’re creating.
The command buttons in the Header & Footer Elements group include
Page Number: Click this button to insert the &[Page] code that puts in
the current page number.
Number of Pages: Click this button to insert the &[Pages] code that
puts in the total number of pages.
Current Date: Click this button to insert the &[Date] code that puts in
the current date.
Current Time: Click this button to insert the &[Time] code that puts in
the current time.
File Path: Click this button to insert the &[Path]&[File] codes that
put in the directory path along with the name of the workbook file.
File Name: Click this button to insert the &[File] code that puts in the
name of the workbook file.
Sheet Name: Click this button to insert the &[Tab] code that puts in the
name of the worksheet as shown on the sheet tab.
Picture: Click this button to insert the &[Picture] code that inserts
the image that you select from the Insert Picture dialog box that shows
the contents of the My Pictures folder on your computer by default.
Search JabSto ::




Custom Search