ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how to hyperlink text to a cell (https://www.excelbanter.com/new-users-excel/4641-how-hyperlink-text-cell.html)

steve

how to hyperlink text to a cell
 
I am a new user of microsoft excel and being a health professional I need to
use it for my research purposes. I have to put in a lot of text in each cell
of first column for reference of each row.I would like the entire text in
each cell to be on display when I take the cursor to each cell of the first
column. How do I hyperlink the first two words of the visible text in each
cell of first column to the remaining text typed into that particular cell,so
that when I take the cursor to the first two words in the cell, the remaining
text is displayed in the form of a drop down menu without clicking the
mouse.Also could I make it appear for longer time by clicking it and then
make it disappear by clicking it out . I would greatly appreciate it If you
could answer my question.
thanking you

Frank Kabel

Hi
maybe not quite what you're looking for b ut you may use 'Insert - Comment'
for this

--
Regards
Frank Kabel
Frankfurt, Germany

steve wrote:
I am a new user of microsoft excel and being a health professional I
need to use it for my research purposes. I have to put in a lot of
text in each cell of first column for reference of each row.I would
like the entire text in each cell to be on display when I take the
cursor to each cell of the first column. How do I hyperlink the first
two words of the visible text in each cell of first column to the
remaining text typed into that particular cell,so that when I take
the cursor to the first two words in the cell, the remaining text is
displayed in the form of a drop down menu without clicking the
mouse.Also could I make it appear for longer time by clicking it and
then make it disappear by clicking it out . I would greatly
appreciate it If you could answer my question.
thanking you





All times are GMT +1. The time now is 11:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com