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