Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
GMS Tower, Inc
 
Posts: n/a
Default 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?
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

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?



  #3   Report Post  
GMS Tower, Inc
 
Posts: n/a
Default

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?

  #4   Report Post  
Chip Pearson
 
Posts: n/a
Default

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple formulas in existing Excel 2002 no longer working. AllieB Excel Worksheet Functions 3 May 3rd 05 04:14 PM
Help, Urgent Excel Formulas are not calculating maashoff Excel Discussion (Misc queries) 1 May 3rd 05 12:25 AM
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 12:22 AM
How do I save a copy of an excel file without the formulas? Saving Excel File without Formula Excel Worksheet Functions 1 February 14th 05 08:55 PM
Problems with Excel formulas when 2002 upgraded to XP Kathi McGraw Excel Worksheet Functions 0 November 16th 04 05:27 PM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"