Adding Hyperlink to multiple values within a cell

  • Thread starter Thread starter t2true
  • Start date Start date
T

t2true

What about this:

Can I create one comment and assign it to multiple cells at once
instead of clicking on each cell and pasting the same comment?

I've decided to just use a separate cell for each numeric value.

Thank
 
Good choice about separating your data. You'll find that you can do lots more
lots easier!

I don't think you'll be able to do that with the comments (multiple comments at
once).

You could use a macro to do it, but even easier.

Add your comment to one cell.
edit|copy
go to another cell
edit|paste special|comments

go to another cell
edit|repeat paste special

Or just hit F4 to repeat your last action.
(Ctrl-y repeats the last action, too.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Hyperlink to multiple values within a cell 2
Activating hyperlinks 3
Excel Macro to hyperlink an archived worksheet to an index page 0
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells 1
Assign numerical value to cell based on selection from drop-down m 1
how can i hyperlink multiple cells to one file? 2
Multiple hyperlinks in a single cell 3
converting text cell to numeric cell 5

Back
Top