Business Software/Spreadsheet

Advertisement


Question
Hi – On a MSExcel2007 spreadsheet, I’m trying to sort on a column that lists by “city” (e.g., Palo Alto, Menlo Park) and I want all the other data to “follow” as well.  Please let me know how to do it.  Thank you kindly.

Answer
Do it from the Data tab. If you chose sort there it should prompt you with the column names. If it doesn't then you need to select the entire table before you hit the Sort button.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Business Software

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

I can answer some questions on a wide variety of business applications, including MS Office, Lotus Smartsuite, Visio, Notes and many others.

Experience

I have over 16 years of experience as an IT professional, supporting a wide variety of business applications.

©2016 About.com. All rights reserved.