Formulas in Excel
 

I am adding information to a worksheet. How do I keep my rows in
alphabetical order while also keeping the columns together?

Select all your columns, and then sort on the column you wish to
alphabetize.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"GMS Tower, Inc" <GMS Tower, wrote
in message
...
I am adding information to a worksheet. How do I keep my rows
in
alphabetical order while also keeping the columns together?

Ok, I tried this. It is telling me that my merged cells must be identically
sized. How do I do this?

"GMS Tower, Inc" wrote:

I am adding information to a worksheet. How do I keep my rows in
alphabetical order while also keeping the columns together?

You should seriously consider unmerging the cells. Merged cells
cause all sorts of problems with sorting, copy/paste, etc.
They're more trouble than they're worth.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"GMS Tower, Inc" <GMS Tower, wrote
in message
...
Ok, I tried this. It is telling me that my merged cells must
be identically
sized. How do I do this?

"GMS Tower, Inc" wrote:

I am adding information to a worksheet. How do I keep my rows
in
alphabetical order while also keeping the columns together?