Using Ctrl+A will select all of your WORKSHEET, which isn't what you want to do. You want to select all of your data, not all of your worksheet. Actually, as long as your data are contiguous (no column or row gaps within it), all you have to do is select a single cell within your data. Then go to Data > Sort and follow the instructions. In a message dated 11/4/2005 1:43:52 AM Eastern Standard Time, [EMAIL PROTECTED] writes:
On 10/27/2005 3:35 PM Nick Danger spoke: > Select *all* your data and then choose Data... Sort... when you choose > the individual column by which to sort, it should take the rows > connected to it. > > James Lockie wrote: > >> How do I sort rows by the data in a specific column? >> I can sort the column but the cell data is tied to other cell data in >> the same row. I tried ctl-A and then Data/Sort/Column C and it gave me an error saying "Ranges containing merged cells can only be sorted without formats". I have no clue what the error means.
