Cells within an Excel workbook can be directly referred using the file name with Excel's native naming scheme:

<filename>#<sheet>!$<row>$<col>

For example, for linking to cell A1 of Sheet2 within the file microsoft.xls, you would use microsoft.xls#Sheet2!$A$1 as the hyperlink text to take you directly to that cell.

Related Tips:

• How do I directly refer to a slide within a presentation?
• How do I directly refer to a bookmark within a Word document or an Excel workbook from a presentation?

More Tips...