Cell size

%3CLINGO-SUB%20id%3D%22lingo-sub-2117249%22%20slang%3D%22en-US%22%3ECell%20size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117249%22%20slang%3D%22en-US%22%3E%3CP%3EI%20merged%20two%20spreadsheets%20and%20now%20I'm%20trying%20to%20sort%20the%20cells%20but%20get%20the%20reply%20%22to%20do%20this%2C%20all%20merged%20cells%20need%20to%20be%20the%20same%20size%22%3C%2FP%3E%3CP%3EHow%20can%20I%20make%20all%20cells%20to%20be%20the%20same%20size%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121430%22%20slang%3D%22en-US%22%3EBetreff%3A%20Cell%20size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121430%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F958718%22%20target%3D%22_blank%22%3E%40Luis_Isava%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20receive%20an%20error%20message%20when%20you%20sort%20a%20range%20that%20contains%20merged%20cells%20in%20Excel%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Ferror-sort-a-range-merged-cell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Ferror-sort-a-range-merged-cell%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Excel%20there%20is%20the%20possibility%20to%20search%20for%20connected%20cells%3A%3C%2FP%3E%3CP%3EIn%20the%20ribbon%2C%20on%20the%20Home%20tab%2C%20in%20the%20Edit%20group%2C%20click%20the%20Find%20and%20Select%20button%20and%20then%20click%20the%20Find%20menu%20item.%20You%20can%20also%20use%20the%20key%20combinations%20%3CCTRL%3E%20%2B%20%3CF%3E.%3C%2FF%3E%3C%2FCTRL%3E%3C%2FP%3E%3CP%3EClick%20the%20Options%20button.%3C%2FP%3E%3CP%3EClick%20the%20Format%20button%20in%20the%20dialog%20picture.%3C%2FP%3E%3CP%3EIn%20the%20Find%20Format%20dialog%20box%2C%20click%20the%20Alignment%20tab.%3C%2FP%3E%3CP%3EOn%20this%20tab%2C%20activate%20the%20Merge%20cells%20option.%3C%2FP%3E%3CP%3EClick%20the%20OK%20button.%20The%20Find%20Format%20dialog%20box%20closes.%3CBR%20%2F%3EThe%20Line%20break%20or%20Text%20break%20option%20should%20be%20activated%20if%20you%20are%20only%20looking%20for%20merged%20cells%20with%20line%20or%20text%20breaks.%20If%20the%20text%20and%20line%20breaks%20should%20not%20play%20a%20role%2C%20it%20should%20neither%20be%20activated%20nor%20deactivated%20(see%20dialog%20above)%3CBR%20%2F%3EClick%20either%20the%20Find%20All%20or%20Find%20Next%20button.%20Excel%20looks%20for%20merged%20cells%20in%20the%20current%20worksheet.%3C%2FP%3E%3CP%3EWhat%20happened%3F%3CBR%20%2F%3ESeparated%20by%20a%20few%20blank%20lines%2C%20there%20was%20a%20merged%20cell%20below%20the%20table%20that%20hindered%20the%20sorting%20process.%20The%20line%20was%20only%20discovered%20after%20scrolling%20down%20the%20worksheet.%3C%2FP%3E%3CP%3EAfter%20deleting%20the%20row%20with%20the%20merged%20cells%2C%20the%20customer%20was%20able%20to%20sort%20the%20table%20without%20any%20problems.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I merged two spreadsheets and now I'm trying to sort the cells but get the reply "to do this, all merged cells need to be the same size"

How can I make all cells to be the same size ?

2 Replies

@Luis_Isava 

 

You may receive an error message when you sort a range that contains merged cells in Excel

https://docs.microsoft.com/en-us/office/troubleshoot/excel/error-sort-a-range-merged-cell

 

In Excel there is the possibility to search for connected cells:

In the ribbon, on the Home tab, in the Edit group, click the Find and Select button and then click the Find menu item. You can also use the key combinations <CTRL> + <F>.

Click the Options button.

Click the Format button in the dialog picture.

In the Find Format dialog box, click the Alignment tab.

On this tab, activate the Merge cells option.

Click the OK button. The Find Format dialog box closes.
The Line break or Text break option should be activated if you are only looking for merged cells with line or text breaks. If the text and line breaks should not play a role, it should neither be activated nor deactivated (see dialog above)
Click either the Find All or Find Next button. Excel looks for merged cells in the current worksheet.

What happened?
Separated by a few blank lines, there was a merged cell below the table that hindered the sorting process. The line was only discovered after scrolling down the worksheet.

After deleting the row with the merged cells, the customer was able to sort the table without any problems.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

@Luis_Isava 

Short answer - never use merged cell, the point.

Same effect will be if you use Center Across Selection (Ctrl+1, Alignment, Horizontal).

Sorting is only one of many potential issues which you may have with merged cells.