how do you unmerge cell in excel...remove hyperlinks and page ref

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I removed hyperlinks which apply anytime you add text with the @ sign or .com
it makes it really difficult to format a quick reference. i removed the
hyperlinks and the borders disappear and it seems the cells are merged...this
is way annoying...anyone have answers
 
hi
to unmerge cells
high lite the merged cells then on the tool bar..
format>cells>alignment tab>uncheck merge cells.

regards
FSt1
 
In a standard Module paste in

Sub UnmergeCells()
With Range("a1") 'change cell reference accordingly
If .MergeCells Then
.MergeArea.UnMerge
Else
MsgBox "not merged"
End If
End With
End Sub
 
Hi Jack

To stop the hyperlinks from being added automatically
just preface your entry with an '

HTH
Martin
 

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

How do you unmerge cells 1
Format Cells to Not Allow Hyperlink 1
How do you have both a hyperlink and "regular" words in a cell? 2
inserting a hyperlink into a conditionally formatted cell, Excel 2 2
How do I locate merged cells in my Excel worksheet? 7
removing hyperlinks 1
Help with Excel Hyperlinks macro? 6
Cannot merge or unmerge cells in Excel 2

Back
Top