Sorting and Merged Cell Issues

Question

Hello,

I'm trying to sort Excel files (where the data has been copied and pasted from an intranet) but I can't because Excel says, "This operation requires that merged cells be of the same size."

My question is: how can I sort? I can't identify which cells are merged, nor how to unmerge them...

Thank you in advance
Configuration: Windows XP / Chrome 25.0.1364.172

PHILOU10120 · Accepted Answer

Hello  In Excel 2010  right-click on the box above the row numbers (sheet selection) in the context menu Format Cells Alignment uncheck the box next to Merge Cells

Vaucluse · Answer

Hello
To split them, but at your own risk because we don't know if you'll get a correct display
Select the entire field to filter or, if necessary, the whole sheet by clicking on the small box to the left of the column titles
Right click/ Cell format / alignment /
and uncheck: merge cells (or leave the checkbox empty as it might be grayed out instead of checked)
best regards

--
To err is human, to persist is diabolical

Anonymous user · Answer

Hello,
Yes, this way merged cells become visible, but I think it's better to identify the merged cells first, then center them across multiple columns via: Format, Cell, Alignment, horizontal, center...

Sorting and Merged Cell Issues

3 answers

Windows 11 microphone issue

My printer won't connect to my pc anymore

No sound on my pc

File with some lines merged and others not

System restore from bootable windows 11 usb drive

Notice use techfive dxf00800

Asus vivobook pc won’t boot anymore, need help

Troubleshooting windows 10 pro installation on lenovo

Excel calendar stuck on dates 1900

Transferring photos from my smartphone to my computer