Sorting columns in Excel

  Perle 19:15 10 Mar 2007
Locked

Hi everyone,
Can anyone tell me if it is possible to lock rows
horizontally so that if you sort the data in say one of five columns using the A-Z sort function on the toolbar, the data remains lined up horizontally and doesn't go out of sync.

Thanks in advance

  VoG II 19:18 10 Mar 2007

Select all of the columns, then Data > Sort and follow the prompts. Nothing should 'go out of sync'.

  chocolate cake 20:13 10 Mar 2007

Be sure, as VOG correctly mentions, to select ALL the columns. Choose one row before sorting to double check your data afterwards.

  xania 20:50 10 Mar 2007

If you click the cell at the top left hand courner, this will select the entire spreadshhet, then you will have no fear that you have msiied out anything. If you're really in doubt, select some rows at random including the first and last, and highlight each in a different colour. You can then double-check after the sort.

  Perle 12:32 11 Mar 2007

Many thanks to you all for your kind help.
It's easy when you know how!

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

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Les meilleures tablettes 2017