i mean to say that whenever we entered any function say 1+2 is =3 then we are
convert into value by Copy<paste Special<value.

Is there any way to convert hyperlink function into Hyperlink

I have More than 80 to 90 Sheets in a workbook And i have 20 workbooks.

Thanks

Pai
"Ashish Mathur" wrote:

Hi,

While you are on cell A1, hit Ctrl+K to create a hyperlink to the required
sheet. You would have to do this for the entries in column A

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Pai" wrote in message
...
I am using hyperlink function using excel 2003. I type this
function in CellA it works perfectly e.g.

HYPERLINK("[Book2.xls]" & A2 & "!" & "a1 ", A2)

But It show in the Form of Formulas. I want In the simple Hyperlink format

My data is look like this After insert the Hyperlink Function
Name
aaryan
aditya
hardeep
neeraj
pai
pardeep
renu

Before
A1 B1
aditya HYPERLINK("[Book2.xls]" & B32 & "!" & "a1 ", B32)
hardeep HYPERLINK("[Book2.xls]" & B32 & "!" & "a1 ", B32)
neeraj HYPERLINK("[Book2.xls]" & B33 & "!" & "a1 ", B33)
pai HYPERLINK("[Book2.xls]" & B34 & "!" & "a1 ", B34)
pardeep HYPERLINK("[Book2.xls]" & B35 & "!" & "a1 ", B35)
renu HYPERLINK("[Book2.xls]" & B36 & "!" & "a1 ", B36)

How can I Convert this in the fom of Hyperlink and remove this function

before I have only one column,now after inserting the function I have 2
column
I want only one column

Thanks

Pai