How to protect data in rows from being seperated during sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a huge spreadsheet that needs to be sorted a million times but several
people. The problem is that during some of the sorts they don't always grab
the whole row and the data then gets scrambled. how can I protect the sheet
so that the rows can be moved and sorted and edited but the data within the
rows always stays together
 
If your sheet is not too dynamic, and tends to stay the same size, then
simply create a named range.

Select *all* the rows and columns concerned.
Click in the "Name box", and enter a short appropriate name, like "sort" (no
quotes), and hit <Enter>.

Now, before each sort, click that name in the name box, which automatically
selects all your data.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tired of finding my data scrambled"
I have a huge spreadsheet that needs to be sorted a million times but
several
people. The problem is that during some of the sorts they don't always
grab
the whole row and the data then gets scrambled. how can I protect the sheet
so that the rows can be moved and sorted and edited but the data within the
rows always stays together
 
In addition to RagDyeR's suggestion, if the _entire_ list of records is to
be sorted, just tell your users to NOT select anything other than to put the
cell selector (click) in the appropriate sort column and click the A-Z/Z-A
button or have them use Data>Sort as long as the active cell is anywhere
within the data range.

HTH |:>)


On 7/23/05 2:48 AM, in article
(e-mail address removed), "tired of finding my
 
Back
Top