Home Products Customers Tips VBA OfficeOne on Mac Contact us

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


Home | Products | Tips | VBA | FAQ | Utilities | Disclaimer | Privacy Policy | Mac | Links | Contact us

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

page counter