Re-ordering rows containing text and formula

By drollans ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

use the sort facility under data

by john.a.wills In reply to Re-ordering rows containi ...

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.

Related Discussions

Related Forums