Discussion Locked

Excel Spreadsheet

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I sort alphabetically one column and have the rest of the data move along with the sort?

4 replies

by timwalsh

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.

by dklippert

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.

This discussion is closed to new replies.