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
 
Back
Top