If you select any cell within the table and go to Data|Sort you should be able to pick the column B header to sort by... then all the row items should follow along.
You can also select all the columns and do this to be more sure to get all data.
If you select any cell within the table and go to Data|Sort you should be able to pick the column B header to sort by... then all the row items should follow along.
You can also select all the columns and do this to be more sure to get all data.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Select all the data you want sorted. press Alt+DFF. Select the arrow at the top of column B for your criteria.
The easiest way was how Xx7 said and it done the job, its not automatic but im not lazy either so its perfect for me, thank you very much.
For future reference what is DFF stand for, D is for Data menu, what about F,F ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks