Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove hyperlinks Excel 2003 | Excel Discussion (Misc queries) | |||
How can I remove a large page number from each page in Excel | Excel Discussion (Misc queries) | |||
How do I remove multiple hyperlinks in the same cell (Excel)? | Charts and Charting in Excel | |||
how to split the unmerge cell in Excel? | Excel Discussion (Misc queries) | |||
How to remove all hyperlinks from a worksheet in Excel? | Excel Worksheet Functions |