How do I sort a ROW in excel not a COLUMN

  Sheila-214876 11:57 02 Jan 04

I have an excel file with 15 columns and 100 rows. The data in each field is figures. I want to sort each row as ascending (lowest figure to highest figure) Data/Sort only gives me an option to sort Columns not Rows.

Highlight the row, select Data > Sort and then click on the options button. Select "Sort left to right".

  Sheila-214876 12:23 02 Jan 04

silasgreenback, Brilliant thank you. What threw me was a warning "Excel found data next to your selection. Since you have not selected this data, it will not be sorted. What do you want to do? Expand the the selection. Continue with the current selection". I chose Cancel.

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017