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

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

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

hi
to unmerge cells
high lite the merged cells then on the tool bar..
formatcellsalignment tabuncheck merge cells.

regards
FSt1


"jacknthbox" wrote:

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

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

FormatCellsAlignment clear the merge option.


Gord Dibben MS Excel MVP

On Fri, 19 Oct 2007 15:53:00 -0700, jacknthbox
wrote:

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

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

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


"jacknthbox" wrote:

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

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

Hi Jack

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

HTH
Martin


"jacknthbox" wrote in message
...
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