Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an easy way to find/display merged cells in excel
I received an excel spreadsheet from a third party and wanted to sort it, but
because it had merged cells - it couldn't be sorted. I would like to know if there is a way to display or find merged cells in a spreadsheet. As for the sort, I know that I can highlight the entire spreadsheet and press the "merge and center" icon and it will unmerge everything. But I'm concerned about what cells are merged and how it will affect the spreadsheet if I indiscriminately unmerge them. Thanks for any assistance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an easy way to find/display merged cells in excel
Hi Ronald,
if you highlight your data and run this, it will colour all merged cells yellow. Sub merged() For Each cell In Selection If (cell.MergeCells) = True Then cell.Interior.ColorIndex = 6 End If Next cell End Sub HTH Simon Ronald J. wrote: I received an excel spreadsheet from a third party and wanted to sort it, but because it had merged cells - it couldn't be sorted. I would like to know if there is a way to display or find merged cells in a spreadsheet. As for the sort, I know that I can highlight the entire spreadsheet and press the "merge and center" icon and it will unmerge everything. But I'm concerned about what cells are merged and how it will affect the spreadsheet if I indiscriminately unmerge them. Thanks for any assistance. -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200611/1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an easy way to find/display merged cells in excel
Thank you sir for the assistance, but I did find another way. Find a couple
blank cells on the spreadsheet and merge them - then do a find - and then options - then format - and choose "choose format from cell" - it will do the same thing. "smw226 via OfficeKB.com" wrote: Hi Ronald, if you highlight your data and run this, it will colour all merged cells yellow. Sub merged() For Each cell In Selection If (cell.MergeCells) = True Then cell.Interior.ColorIndex = 6 End If Next cell End Sub HTH Simon Ronald J. wrote: I received an excel spreadsheet from a third party and wanted to sort it, but because it had merged cells - it couldn't be sorted. I would like to know if there is a way to display or find merged cells in a spreadsheet. As for the sort, I know that I can highlight the entire spreadsheet and press the "merge and center" icon and it will unmerge everything. But I'm concerned about what cells are merged and how it will affect the spreadsheet if I indiscriminately unmerge them. Thanks for any assistance. -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200611/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
Use functions when cells are merged | Excel Worksheet Functions | |||
why can't i enter text into merged cells in excel | Excel Worksheet Functions | |||
How can I Excel to re-size when wrapping text in merged cells | Excel Discussion (Misc queries) |