ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Sort - Merged cells (https://www.excelbanter.com/new-users-excel/143978-sort-merged-cells.html)

Ed

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

RagDyeR

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



Gord Dibben

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