![]() |
Sort - Merged cells
I am trying to sort my sales table, it doen't seem to work for me. A
comment comes up: this operation requires the merged cells to be idendically sized. Can you help? Thanks |
Sort - Merged cells
Easiest way is to *unmerge* the cells, and then use "Center Across
Selection" instead. <Format <Cells <Alignment tab, And expand the "Horizontal" window, and choose, "Center Across Selection" -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "ED" wrote in message ... I am trying to sort my sales table, it doen't seem to work for me. A comment comes up: this operation requires the merged cells to be idendically sized. Can you help? Thanks |
Sort - Merged cells
ED
If all the merged cells are the same size..........no problem. If varying sizes, you can't sort. You must unmerge the cells before sorting. Gord Dibben MS Excel MVP On Thu, 24 May 2007 08:38:03 -0700, ED wrote: I am trying to sort my sales table, it doen't seem to work for me. A comment comes up: this operation requires the merged cells to be idendically sized. Can you help? Thanks |
All times are GMT +1. The time now is 08:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com