sort spreadsheet, "merged cells" comes up. Find cells? Unmerge ?
I have a large spreadsheet that I sort often. When I use the upper left
corner to designate sort area, "merged cells" comes up. If I sot otherwise, sorting works. I have not had this problem till recently but I must have copied in some merged data. How can I find these cells and "unmerge" or remove them? Thanks, Lowell |
sort spreadsheet, "merged cells" comes up. Find cells? Unmerge ?
Hi
First, you bring the unmerge button to the tool bars. Right click on the blank space of the tool bar field and select customize €“ commands €“ format. You can see the unmerge button. Drag and drop it to the tool bar field. Since it is a large spreadsheet, it will be difficult to find merged cells one by one. So select all cells by pressing control A. Now press the unmerge button. I hope this would help. Regards, Jaleel "lowell" wrote: I have a large spreadsheet that I sort often. When I use the upper left corner to designate sort area, "merged cells" comes up. If I sot otherwise, sorting works. I have not had this problem till recently but I must have copied in some merged data. How can I find these cells and "unmerge" or remove them? Thanks, Lowell |
All times are GMT +1. The time now is 09:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com