Friday, November 30, 2012

How to Print the file name Excel Spreadsheet

Steps:  By default, new workbooks do not have any headers or footers.  You need to create the header/footer 'manually' for each sheet in the workbook
  • View: header and footer
  • Custom header (or footer)
  • Click on the open button
    • You will see &[Path]&[File]
  • Remove the &[Path], just leave the &[File]

No comments:

Post a Comment