Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2012
    Posts
    2

    how to remove multiple hyperlinks in excel

    how to remove multiple hyperlinks in excel 2007?

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,275
    Try copy paste values only
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE

  3. #3
    Join Date
    Aug 2012
    Posts
    4

    Smile

    Simple trick that may help you with this:

    just type 1 in any empty cell and select all that cell where hyperlinks you want to remove , after selection right click and choose paste special option and under operation menu click multiply then click ok.

  4. #4
    Join Date
    Jan 2013
    Posts
    6
    After selection of cells that you want to remove right click then paste special then under the operation menu click ok.

Posting Permissions

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