One of the features that this application provides users is the communication between multiple Excel files, the values stored in cells stored in each file, and the fast access to each sheet (Sheet) in various Excel files.
Linking to Excel is done in the following way:
1- First enter the phrase as a list option in one of the desired cells.
Select the top cell and right-click it then select the hyperlink option.
3. You can now perform various link operations in a variety of ways.
1. Link to specified cell in the same file: In the Add a link to the Place in This Document, in the Type the Cell reference box, enter the desired cell name and select the current page from the list of pages in the box below it.
2. Link to the other page and the specified cell in the same file: In the Add a link to the Place in This Document, in the Type the Cell reference box, enter the name of the cell you want, and type the cell from the list of pages in the box below it, each of the other pages Choose to link to them.
3. Link to another file: In the Add Link window, select the Existing File and Web Page option and use the routing tool to select the desired Excel file path and then click OK on the end.
4. Link to the page and cell specified in the other file: In the above mode, the link to the other file is taken, but by default the first page will be displayed to you. If you want to display another page, you need to enter the page name at the end of the file after repeating the steps above and selecting the desired Excel file:
'Sheet'! A1 #
Note: The page title page and A1 are also the cells in the page.
Bookmarks