Right clicking on text does not bring up hyperlink option

I want to add a hyperlink to another area in my Excel workbook.

On one sheet when I right click on text that I want to add the hyperlink to,
I don't get the hyperlink option. It has the following:

cut
copy
paste
paste special
__________
insert page break
reset all page breaks

insert
delete
clear contents
__________
insert comment
__________
format cells
set print area
reset print area
page setup

There is no hyperlink option. Any ideas? Thanks in advance.

The cell menu (the one you get when you rightclick on a cell) is different if
you're in View|Normal or View|Page break preview mode.

So click View|Normal and you'll see the normal cell menu.

Morocco Mole wrote:
>
> I want to add a hyperlink to another area in my Excel workbook.
>
> On one sheet when I right click on text that I want to add the hyperlink to,
> I don't get the hyperlink option. It has the following:
>
> cut
> copy
> paste
> paste special
> __________
> insert page break
> reset all page breaks
>
> insert
> delete
> clear contents
> __________
> insert comment
> __________
> format cells
> set print area
> reset print area
> page setup
>
> There is no hyperlink option. Any ideas? Thanks in advance.

--

Dave Peterson

Thank you that was it.

"Dave Peterson" wrote:

> The cell menu (the one you get when you rightclick on a cell) is different if
> you're in View|Normal or View|Page break preview mode.
>
> So click View|Normal and you'll see the normal cell menu.
>
> Morocco Mole wrote:
> >
> > I want to add a hyperlink to another area in my Excel workbook.
> >
> > On one sheet when I right click on text that I want to add the hyperlink to,
> > I don't get the hyperlink option. It has the following:
> >
> > cut
> > copy
> > paste
> > paste special
> > __________
> > insert page break
> > reset all page breaks
> >
> > insert
> > delete
> > clear contents
> > __________
> > insert comment
> > __________
> > format cells
> > set print area
> > reset print area
> > page setup
> >
> > There is no hyperlink option. Any ideas? Thanks in advance.
>
> --
>
> Dave Peterson
>

fantastic answer it very very helpful
thanks