General discussion

Locked

Excel Spreadsheet

By marcia.burfeind ·
How do I sort alphabetically one column and have the rest of the data move along with the sort?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Spreadsheet

by timwalsh In reply to Excel Spreadsheet

Highlight all data fields; Go to the Data menu and choose Sort; Choose the column you wish to sort on and pick either ascending or decending.

Collapse -

Excel Spreadsheet

by marcia.burfeind In reply to Excel Spreadsheet

Thank you very much.

Collapse -

Excel Spreadsheet

by DKlippert In reply to Excel Spreadsheet

First make sure you have a header row.
(Name, Address, Phone etc.)
make sure that the data is contiguous (no empty rows or columns).
Select ONE cell in the column you wish to make the primary search field.
You can use the A-Z, Z-A icons on the toolbar, or go to Data>Sort on the menu bar.
Usually synchronicity is lost when more than one cell is selected before a sort. Choose either one cell or the entire database.

Collapse -

Excel Spreadsheet

by marcia.burfeind In reply to Excel Spreadsheet

This question was closed by the author

Back to Windows Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums