Q: I print a lot of Microsoft Excel spreadsheets, and it would be great if the name of the file could be displayed at the top of the printed page. Is there a way to do that?

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.

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 ...

When working with Excel files that have different sheet names or layouts, Power Query can dynamically detect and extract the necessary data.

How to Copy a List of Files in a Windows Folder Into an Excel List. Maintaining an Excel spreadsheet of computer files can help you keep track of important business documents or images ...