I would like to extend hyperlinks across cells

[Guest]

I want to extend the hyperlinks across all cells in one worksheet..... like
cell A1 in sheet 1 should point to cell A1 in sheet2 and so on..... i have
500 cells in both sheets....

 

[Guest]

Select Cell>right click>hyperlink>in this file>sheet>cell ref. Hope this is
what you mean.
Pat F

 

[Guest]

Ya this will enable hyperlink for one cell... i would like to drag this
across for all cells... for example if i have a hyperlink from cell A1 of
shet1 to cell A1 of Sheet2, by someway i wnat to extend this to all cells of
sheet1 to corresponding cells in sheet2.