Excel for ipad

%3CLINGO-SUB%20id%3D%22lingo-sub-1304521%22%20slang%3D%22en-US%22%3EExcel%20for%20ipad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1304521%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%E2%80%99m%20trying%20to%20hyperlink%20a%20cell%20in%20an%20Excel%20worksheet%20to%20a%20cell%20in%20another%20worksheet%20within%20the%20same%20workbook%20using%20the%20link%20function.%20The%20outcome%20I%20want%20to%20achieve%20is%20by%20clicking%20on%20the%20first%20cell%20it%20will%20automatically%20jump%20to%20the%20target%20cell%20on%20the%20other%20worksheet.%20When%20I%20open%20the%20link%20dialogue%20box%20it%20asks%20for%20the%20%3CU%3Eaddress%3C%2FU%3E%26nbsp%3Band%20%3CU%3Edisplay%3C%2FU%3E.%20Unfortunately%20I%20don%E2%80%99t%20know%20what%20to%20enter%20in%20the%20address%20field.%20Because%20this%20is%20the%20ipad%20version%2C%20and%20the%20link%20function%20is%20much%20more%20limited%20than%20the%20one%20for%20laptops%20and%20pc%E2%80%99s.%20I%E2%80%99m%20wondering%20if%20it%20is%20only%20limited%20to%20using%20a%20url%20address%2C%20or%20whether%20I%20need%20to%20enter%20an%20Excel%20formula%20for%20the%20target%20cell.%20Can%20it%20actually%20be%20achieved%20on%20an%20ipad%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1304521%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi, I’m trying to hyperlink a cell in an Excel worksheet to a cell in another worksheet within the same workbook using the link function. The outcome I want to achieve is by clicking on the first cell it will automatically jump to the target cell on the other worksheet. When I open the link dialogue box it asks for the address and display. Unfortunately I don’t know what to enter in the address field. Because this is the ipad version, and the link function is much more limited than the one for laptops and pc’s. I’m wondering if it is only limited to using a url address, or whether I need to enter an Excel formula for the target cell. Can it actually be achieved on an ipad version?

0 Replies