+ Reply to Thread
Results 1 to 2 of 2

Linking in Excel

  1. #1
    Registered User
    Join Date
    12-20-2017
    Location
    iran
    MS-Off Ver
    2013
    Posts
    6

    Linking in Excel

    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.
    Last edited by panel123; 06-09-2018 at 05:31 PM.

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Linking in Excel

    Sounds intresting, but I can't find your solution attached.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-20-2017, 06:37 AM
  2. linking incompatible spreadsheeets and linking data in summary sheet
    By tcarter1208 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2015, 04:02 AM
  3. Replies: 0
    Last Post: 11-03-2014, 11:46 AM
  4. Trying to Solve Conditional Formatting Formula Linking 2 sheets linking dates
    By Jetpilot69 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2014, 01:57 PM
  5. Replies: 2
    Last Post: 05-31-2013, 08:45 AM
  6. Excel Macro - Linking dates from Excel to a Shared Outlook Calendar
    By cg7131 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2011, 11:08 AM
  7. data entry in excel by linking to other word doc. or excel sheets
    By wangxuqin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2006, 07:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1