Sorting Data..HELP!

J

jill

I am trying to sort my speadsheet by the date. When I sort it only
moves the information in the colum with the sort information instead of
the whole row. How do I get the rows to move with the sorted
information?

Thank you so much!
 
D

David McRitchie

Hi Jill,
Suggest you first select the entire worksheet before sorting, so that
all cells are involved. Excel tries to be helpful and expands
a single cell to the current region (Ctrl+*) which is just helpful
enough to cause you later grief. More information on sorting
http://www.mvps.org/dmcritchie/excel/sorting.htm

To select all cells on a worksheet:
Use Ctrl+A to select all cells, or
use Ctrl+Shift+SpaceBar if you are using Excel 2003 to be safe
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#foobar
use the gray button between the lettered column headers an numbered row headers.
which is not the same as it changes the activecell.
 
Top