Excell Alphabetizing & Sorting

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

Guest

When I try to alhabetize aan excell sheet I am working on, it says all merged
cells must be the same size. How is this overcome?

DG
--
 
Remove the merged cells?????
When I try to alhabetize aan excell sheet I am working on, it says all merged
cells must be the same size. How is this overcome?

DG
--
Click to expand...
 
iI suppose that would work, Except that it would mean completely remaking my
sheet. Also I Know I have done this before-- Just don't recall how.
DG
-
 
You have done it before?

Yes...........if all the merged cells in the sort range were the same size.


Gord Dibben MS Excel MVP
 
As a follow-up...........

Merged cells cause no end of problems and are best avoided.

For presentation purposes you can use Center Across Selection which won't
involve merging.

You can also take a picture of the area and superimpose it over a range.

If you use the Camera Tool found under Tools>Customize>Commands you can take a
picture that will update as cell contents are altered.


Gord
 

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

Sorting data in excel 1
Sort Multiple Sheets by Category 2
Merged cells 2
Iteration Calculations between sheets 1
Merged cells 2
Sort problem in shared excel file 1
How do I seperate a alphabet and number in a cell-in Excel 2
Sorting information 2

Back
Top