TRYING TO SORT, MERGED CELLS HAVE TO BE IDENTICAL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HOW CAN I TELL WHICH ARE THE MERGED CELLS? HOW CAN I FIX THIS TO BEABLE TO
SORT?
 
Merged Cells are more than 1 column/row wide or tall. Someone applied a
merge cell format-usaully for a header row-but you do lose the sort. To
unmerge, click
top left corner of spreadsheet (between Column A and Row 1) This will select
whole sheet. Then click Format>Cells>alignment tab and select 'merge cells"
OK. This will unmerge all cells and give you back your sort tool.
Pat
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to sort excel data. won't allow. merged cells sizing.?? 2
Best solution to merge multiple Outlook contacts easily 2
How do I locate merged cells in my Excel worksheet? 7
sorting problems - error message: identically sized merged cells. 2
Sorting Rows 2
sorting two columns of merged cells 1
Merging Cells and Sorting 1
Sharing workbooks limitations - Merged Cells 12

Back
Top