Sorting data in one sheet

G

Gwen

I created a sheet with many columns and rows. I want to be able to sort the
data in different columns but keep all of the row information together. For
instance when I sort one of my rows alphabetically, the rest of the
information in the other columns that pertains to it doesn't follow.
 
S

Sean Timmons

when you do your sort, are you highlighting the entire table of data?

everything within your highlighted data should sort along with yoru selected
field.
 
S

Sean Timmons

when you do your sort, are you highlighting the entire table of data?

everything within your highlighted data should sort along with yoru selected
field.
 
G

Gwen

I think part of the problem might be that I have the information in the first
column frozen so that when you're scrolling to the right you can still see
the info in the first column.
Do I have to highlight the whole table every time I want to sort?
 
G

Gwen

I think part of the problem might be that I have the information in the first
column frozen so that when you're scrolling to the right you can still see
the info in the first column.
Do I have to highlight the whole table every time I want to sort?
 
S

Sean Timmons

It's typically only an issue when you have blank columns in the middle of
your table. If you put anything in the header row for all columns, it should
automatically highlight the entire table.

The frozen pane should not cause an issue with sorting...
 
S

Sean Timmons

It's typically only an issue when you have blank columns in the middle of
your table. If you put anything in the header row for all columns, it should
automatically highlight the entire table.

The frozen pane should not cause an issue with sorting...
 
G

Gord Dibben

Do not let Excel guess at the range to be sorted.

Always pre-select the entire range you want to stay together.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Do not let Excel guess at the range to be sorted.

Always pre-select the entire range you want to stay together.


Gord Dibben MS Excel MVP
 

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

Automatic Sorting? 6
Sorting data field 1
Sorting day names chronologically 5
Compare identifier columns from 2 sheets - remove rows that are dups 2
How do I pick row 3 to be the header row in Excel 1
find and Summarize data in a table from a different sheet? 2
Sorting complex worksheets 1
Excel Help to copy information from one row at a time to another sheet 1

Top