ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   trying to sort excel data. won't allow. merged cells sizing.?? (https://www.excelbanter.com/excel-discussion-misc-queries/231885-trying-sort-excel-data-wont-allow-merged-cells-sizing.html)

Skinny in the footlhills

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).

Eduardo

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