Now click the icon showing the dog-eared page with the Excel logo on it. The code & [File] should appear. Now click OK. The file name will appear in the header when you print the file.

For each sheet, the code uses the Name property to enter that name in column A, beginning at A1, in Sheet1. Listing A Sub ListSheetNames () ‘List all sheet names in column A of Sheet1.

I have a bunch of DVDs, each filled with dozens of files. I want to create a list of the contents of these discs and put it into a spreadsheet. I want to list the file name, type and size. So far ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.