LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging cells in Excel 2003 Bob Excel Discussion (Misc queries) 1 October 19th 05 07:10 PM
copy & paste spreadsheet cells from excel to outlook to excel mismarple Excel Discussion (Misc queries) 1 September 20th 05 11:16 PM
Use functions when cells are merged Amanda Excel Worksheet Functions 3 September 12th 05 06:08 PM
why can't i enter text into merged cells in excel shellie Excel Worksheet Functions 1 April 12th 05 03:56 PM
How can I Excel to re-size when wrapping text in merged cells Samjoy Excel Discussion (Misc queries) 4 February 4th 05 12:47 AM


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"