How do I sort a ROW in excel not a COLUMN

  Sheila-214876 11:57 02 Jan 2004

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 2004

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?