Microsoft

Ask something
Question Locked

Re-ordering rows containing text and formula

0 helpful
2 replies

by drollans

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a spreadsheet with some 18 columns and around 500 rows. Each cell in each row contains either text, numbers or formulae.
Column 1 contains the text that I wish to re-order and I need all of the other columns in the individual rows to re-order accordingly.
I have tried many ways to achieve this including Microsoft Online help but just cannot get ti to work. I am missing something that is probably quite obvious.

2 replies

by john.a.wills

First highlight the column(s) by which you wish to sort. ALT Data. One of the options is Sort: choose that. You may be told that there is data in other columns; indicate that you wish to continue with what you have. A miniwindow will appear asking you by which column to order and there are radio buttons to choose ascending or descending.

This discussion is closed to new replies.