![]() |
trying to sort excel data. won't allow. merged cells sizing.??
lI'm using Microsoft XP. In Excel, I'm trying to sort, but I get a message
box that says."This operation requires the merged cells to be identically sized." I have merged cells within the rows, but not in the columns (and I'm sorting by rows). |
trying to sort excel data. won't allow. merged cells sizing.??
Hi,
Highlight the whole sheet and press Merge, then sort it. You are sorting by rows however one of them is using two columns that is the reason why you get that message, if this helps please click yes, thanks "Skinny in the footlhills" wrote: lI'm using Microsoft XP. In Excel, I'm trying to sort, but I get a message box that says."This operation requires the merged cells to be identically sized." I have merged cells within the rows, but not in the columns (and I'm sorting by rows). |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com