Cable Forum - View Single Post - Excel help Sheet Name...linking into Spreadsheet

andygrif · 15-08-2005, 09:05

As Ikthius said you can create hyperlinks to a complete sheet - but I am wondering if you want to link to a CELL in a different sheet. If so it's as easy as putting your forumula in the cell and then (instead of clicking to get the value of a cell on that sheet) click the tab of the sheet you want, then the cell in that sheet, and press enter.

15-08-2005, 09:05	#3
andygrif Inactive Join Date: Jul 2003 Posts: 2,820	Re: Excel help Sheet Name...linking into Spreadsheet As Ikthius said you can create hyperlinks to a complete sheet - but I am wondering if you want to link to a CELL in a different sheet. If so it's as easy as putting your forumula in the cell and then (instead of clicking to get the value of a cell on that sheet) click the tab of the sheet you want, then the cell in that sheet, and press enter.