A: Yes. With your spreadsheet open, go to Excel's View menu and choose Header and Footer. Click the Custom Header button, then place your cursor where you want the file name to appear, at the left ...

To add hyperlinks to Excel, you can type the corresponding URL, add hyperlinks using the Link feature or use the HYPERLINK Function.

You don't have to add a header to every Excel worksheet individually when you can group them first.

The PDF File has been inserted into an Excel sheet as an object similar to a chart or any shape. We can drag it or resize it as we want. Repeat the same steps to insert more PDF files into the sheet.