InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Solve : Excel help - linking web pages? |
|
Answer» Hi, does anyone know if there is any way of displaying a hyperlink in a cell without UNDERLINING the whole text? I don't know why you posted the link. Anyway, in Excel, select a cell that has a hyperlink in it. Then, go to Format, Cells, and, in the box for Underline, select None, and then click OK. Of course, you can select multiple cells and then apply the formatting, or use Format Painter to copy the format from one cell to others. Sorry, I don't think you have quite understood my query (maybe I haven't phrased it very well?). The idea is that I wanted only part of the text in the cell to be used as a hyperlink, like in the example above (I don't quite get your first point, as I had to post some kind of link otherwise my question wouldn't make much sense). So that when you MOVE the cursor over the cell, only the bit that is underlined/highlighted appears in the hyperlink caption (like with the link in the above example appearing in the status bar), with the rest of the text normal. It just looks a bit neater and means that when you edit it you don't have to keep clicking into the formula bar to avoid opening ANOTHER window unnecessarily. Not that drastically important, I just wondered if it could be done. Hope this clears things up. Even if it can't be done, please let me know if you can!Your additional explanation clarified what you want to accomplish. But, I'm afraid it cannot be done. However, here's a tip that might be helpful when editing cells with hyperlinks. To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross, then release the mouse button. You can then hit F2 to put the cell in edit mode. Yeah I thought it couldn't be done, I tried pasting a similar example from Word and it just came out as one long hyperlink. Thanks anyway, that's a useful tip! |
|