In the September 2003 column I erroneously stated that Excel’s Sort function can sort information only in columns (up and down) not in rows (left and right). I should have known better because I’ve used that row-sorting function many times. I would like to thank the several readers who pointed out the error.
|Here are the steps to sort data
in rows. Highlight the cells you want to sort, click on
Data , Sort and the screen
at right appears. |
Then click on Options , and the screen below appears.
Click on the Sort left to right box, and you’re in business.