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.

"patrick" wrote:

Select Cellright clickhyperlinkin this filesheetcell ref. Hope this is
what you mean.
Pat F

"venkat" wrote:

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....