- Create table with headers in excel .
- Name the table by- Formulas - Name manager - New - Name - save .
- Select the word to be hyperlinked - insert - hyperlink - select - source excel file .
- at the end of excel files name write #"table name".
- Save . Done
No comments:
Post a Comment