An Excel sorting trick — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

An Excel sorting trick

by on
in Excel Training,Office Technology

Did you know that you can sort from left to right, and not just top to bottom?

Select the cells you’d like to sort. Go to the Data tab, select the Sort button from the Sort & Filter group. Click the Options button on the top row of the Sort dialog box. On the Sort Options dialog box, in the Orientation section, click the Sort left to right radio button. Make it case sensitive by checking the box at the top. Be sure Row 1 appears in the Sort by field. Don’t worry, it will sort all the rows you selected.

Leave a Comment