why can't I add a hyperlink to my excel document?

P

PCLIVE

Click the desired cell, then the hyperlink button should be available.
This option is greyed out if you have clicked in the formula line. This
will also be true if you have double-clicked a cell or started typing in a
cell. You must enter what you want in the cell and then press enter to
leave the cell. Then click once on that cell and you should be able to
click the hyperlink button.

HTH,
Paul
 
G

Gord Dibben

Are any other menu options grayed out?

Could be you enabled sheet protection.

Shared workbooks also gray out the hyperlink option.


Gord Dibben Excel MVP
 
Top