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

J

jacknthbox

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
 
F

FSt1

hi
to unmerge cells
high lite the merged cells then on the tool bar..
format>cells>alignment tab>uncheck merge cells.

regards
FSt1
 
J

Jim May

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
 
M

MartinW

Hi Jack

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

HTH
Martin
 
Top