Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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).
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default 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).

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
How can I sort an Excel Doc containing merged & non-merged cells? KellyH Excel Discussion (Misc queries) 11 June 10th 08 04:12 AM
Automatically re-sizing merged cells LongTermNoob Excel Worksheet Functions 1 March 28th 07 10:42 AM
DATA SORT REQUIRES IDENTICALLLY MERGED CELLS???? HELP PLEASE ELSUL Excel Worksheet Functions 2 September 28th 06 05:37 PM
How I sort data in Excel, it keeps saying "merged cells must be ID angela g Excel Worksheet Functions 2 December 19th 05 04:11 AM
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 09:34 PM.

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"