How do I directly refer to a cell within an Excel workbook from a presentation?

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:

More Tips...

Contact OfficeOne on email at officeone@officeoneonline.com. Copyright © 2001-2023 OfficeOne. All rights reserved.