Sorting columns in Excel

  Perle 19:15 10 Mar 07

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 07

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

  chocolate cake 20:13 10 Mar 07

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 07

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 07

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…