Discussion Locked
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.
Thank you very much.
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 question was closed by the author
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending
1 helpful
17 replies
0 helpful
5 replies
0 helpful
12 replies
Discussion
Do you think that business directories are relevant to Local SEO And Lead Generation today
0 helpful
14 replies
0 helpful
2 replies