Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting Problems
I've been manipulating data in a speadsheet for about two weeks.
At some point, I copied an entire column, put it into Word, deleted and reformatted the info in that column and then split the column into first and last name. The two columns were then pasted back into the original worksheet. I need to sort the spreadsheet using various columns, but Excel will not allow a sort. I receive a box which states "This operation requires that merged cells be identically sized" I've sized the spreadsheet several times and both the height and width of all cells are identical, but it still gives me this message. Any idea of that I might be able to do? |
#2
|
|||
|
|||
Sorting Problems
Some of your cells are merged: cells with contiguous borders are joined
so they effectively become one large cell. When you land on merged cells the cell pointer will suddenly become much larger. If you un-merge your cells the sort will perform as expected. |
#3
|
|||
|
|||
Sorting Problems
*Unmerge* your cells and use "CenterAcrossSelection" instead.
<Format <Cells <Alignment tab, *Uncheck* "Merge Cells", Expand the "Horizontal" window, And choose the last option. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Katie59" wrote in message ... I've been manipulating data in a speadsheet for about two weeks. At some point, I copied an entire column, put it into Word, deleted and reformatted the info in that column and then split the column into first and last name. The two columns were then pasted back into the original worksheet. I need to sort the spreadsheet using various columns, but Excel will not allow a sort. I receive a box which states "This operation requires that merged cells be identically sized" I've sized the spreadsheet several times and both the height and width of all cells are identical, but it still gives me this message. Any idea of that I might be able to do? |
#4
|
|||
|
|||
Sorting Problems
Thanks, it worked perfectly!
"RagDyer" wrote: *Unmerge* your cells and use "CenterAcrossSelection" instead. <Format <Cells <Alignment tab, *Uncheck* "Merge Cells", Expand the "Horizontal" window, And choose the last option. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Katie59" wrote in message ... I've been manipulating data in a speadsheet for about two weeks. At some point, I copied an entire column, put it into Word, deleted and reformatted the info in that column and then split the column into first and last name. The two columns were then pasted back into the original worksheet. I need to sort the spreadsheet using various columns, but Excel will not allow a sort. I receive a box which states "This operation requires that merged cells be identically sized" I've sized the spreadsheet several times and both the height and width of all cells are identical, but it still gives me this message. Any idea of that I might be able to do? |
#5
|
|||
|
|||
Sorting Problems
Katie59 Wrote: I've been manipulating data in a speadsheet for about two weeks. At some point, I copied an entire column, put it into Word, deleted and reformatted the info in that column and then split the column into first and last name. The two columns were then pasted back into the original worksheet. I need to sort the spreadsheet using various columns, but Excel will not allow a sort. I receive a box which states "This operation requires that merged cells be identically sized" I've sized the spreadsheet several times and both the height and width of all cells are identical, but it still gives me this message. Any idea of that I might be able to do? Try going to "Tools" on your Excel ToolBar then select "Customize". This will open up a "Customize" window. Click on the "Commands" tab. Select "Format" in the lefthand window. Scroll down in the righthand window till you see the "Unmerge Cells" icon. Hold down the mouse button on this icon and drag it into your Excel Toolbar at the top of your Worksheet. Now close the "Customize" window. Highlight the whole of your worksheet by clicking on the blank grey cell above the 1 in your numbered rows and to the left of the A in your columns. Your whole worksheet should now be highlighted. Now click on the "Unmerge Cells" icon that you put on your Toolbar. This will unmerge everthing whether hidden or not in the worksheet. Hopefully this will do the trick. -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=484076 |
#6
|
|||
|
|||
Sorting Problems
Thank you for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Katie59" wrote in message ... Thanks, it worked perfectly! "RagDyer" wrote: *Unmerge* your cells and use "CenterAcrossSelection" instead. <Format <Cells <Alignment tab, *Uncheck* "Merge Cells", Expand the "Horizontal" window, And choose the last option. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Katie59" wrote in message ... I've been manipulating data in a speadsheet for about two weeks. At some point, I copied an entire column, put it into Word, deleted and reformatted the info in that column and then split the column into first and last name. The two columns were then pasted back into the original worksheet. I need to sort the spreadsheet using various columns, but Excel will not allow a sort. I receive a box which states "This operation requires that merged cells be identically sized" I've sized the spreadsheet several times and both the height and width of all cells are identical, but it still gives me this message. Any idea of that I might be able to do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel sorting problems | Excel Worksheet Functions | |||
Need Help with Sorting Problems | Excel Discussion (Misc queries) | |||
Sorting Problems | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Problems with sorting a pivot table | Excel Discussion (Misc queries) |