to create a hyperlink, press ctrl+k, go to insert menu>insert hyperlink, or use the hyperlink button (globe with chain links) on the standard tool bar. all three will bring up a dialog box to create a hyperlink. the 'named location in file' is the bit you want. press the browse button and select the cell ref you want.
sorry but can't help with the autocorrect thing
[ This Message was edited by: anno on 2002-04-22 23:38 ]