Excel - Sorting rows from left to right

April 2018




Issue


Microsoft Excel by default perform a sort on the columns (Data/Sort).
But how do we sort data horizontally (rows)

Solution


To sort the data horizontally, just select the data to be sorted, then Data tab /Sort/ Options/ check the Sort Left to right box in the sort option window.
  • Press Ok to validate.
Published by jak58. Latest update on January 19, 2013 at 03:57 AM by jak58.
This document, titled "Excel - Sorting rows from left to right," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - How to remove duplicates entries from a column
Inserting an Hyperlink in an Excel Worksheet