+ Reply to Thread
Results 1 to 2 of 2

Quickly edit text of a hyperlinked cell?

  1. #1
    Registered User
    Join Date
    12-02-2013
    Location
    United States
    MS-Off Ver
    2010
    Posts
    6

    Quickly edit text of a hyperlinked cell?

    Hello,

    Obviously on a cell without a hyperlink, you can double click a specific part of the cell to begin editing the text at the precise point.

    How can you do this with a hyperlinked cell? Obviously one click anywhere in the cell takes you to the URL. A click-and-hold lets you select the cell without going to the URL, but you are still not able to edit the text, unless you go all the way up to the formula entry box (which takes basically an eternity).

    Is there anyway to quickly begin editing the text without using the formula box?

    Thanks!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,401

    Re: Quickly edit text of a hyperlinked cell?

    Click on the File button, then on Excel Options (at the bottom), then on Advanced. Then about the 5th option down you have a choice of Allow editing directly within cells. Check this then click OK, and then you will be able to edit a cell directly without having to use the formula bar (although I don't think this is a big deal, as the formula bar is always visible on screen).

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] macro code to edit address name of hyperlinked file
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2016, 12:01 PM
  2. Move text from cell to cell if matches criteria, and edit text
    By joematzzie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2015, 07:58 AM
  3. [SOLVED] Macro to use different cell as 'Text to display" in hyperlinked cell.
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2014, 01:39 PM
  4. Searching for URL-text in a hyperlinked cell
    By SIM.SIM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2013, 11:05 AM
  5. Sheet tab name to be hyperlinked without being underlined & to be in linked in Text Box
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2013, 01:33 AM
  6. Moving text thats hyperlinked
    By Frazzfreeman in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-30-2007, 06:52 AM
  7. [SOLVED] how can i make 2500 urls in an excel file hyperlinked quickly?
    By M_E_Luft in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-22-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1