Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ed Ed is offline
external usenet poster
 
Posts: 279
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
getting msg: cannot sort merged cells not same size help with mas data Excel Discussion (Misc queries) 1 May 25th 05 09:19 PM
Sort columns containing merged cells. Ron Excel Discussion (Misc queries) 1 May 4th 05 01:08 PM
How to sort merged cells Sort merged cells Excel Worksheet Functions 3 March 11th 05 04:07 PM
How to sort merged cells imaorange Excel Worksheet Functions 0 March 11th 05 03:41 PM
Sorting merged cellsHow do I sort merged cells not identically siz Laval Excel Worksheet Functions 1 November 3rd 04 09:40 PM


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"