Tuesday 26 September 2017

Hyperlink a specific excel table to any document


  1. Create table with headers in excel .
  2. Name the table by- Formulas - Name manager - New - Name - save .
  3. Select the word to be hyperlinked - insert - hyperlink - select - source excel file .
  4. at the end of excel files name write #"table name".
  5. Save . Done 

No comments:

Post a Comment