Locking just by row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan S - 13 Apr 2004 16:31 GMT

Hi everybody, I hope someone can help me.

I have a spreadsheet with 100+ rows of this type of
information. I want to be able to sort by any of the
column types, but the rows need to keep their integrity.

1. UniqueID_A Name    9-Mar-04    7763
2. Unique ID_B Name    9-Mar-04    5496
3. UniqueID_A Name    16-Mar-04    4687
4. UniqueID_C Name     15-Mar-04    4621
5. InuqueID_F Name 12-May-04 642

Is it possible to lock just the rows, but to still be able
to sort the workseet by uniqueID, date or count?

Thanks,
Susan

Reply to this Message

Frank Kabel - 13 Apr 2004 16:35 GMT

Hi Susan
prior to sorting select your entire data range and goto 'Data - sort'
and choose your sorting column

wrote:

> Hi everybody, I hope someone can help me.
>
[quoted text clipped - 13 lines]
> Thanks,
> Susan

Reply to this Message

- 13 Apr 2004 17:07 GMT

Thanks for your reply, Frank.

So.... does excel ALWAYS sort the entire row as a whole,
according to whatever sort you choose? And not just by the
cells in the column of the sort type?

S

>-----Original Message-----
>Hi Susan
[quoted text clipped - 21 lines]
>
>.

Reply to this Message

Frank Kabel - 13 Apr 2004 17:14 GMT

Hi
if you select the entire range prior to this: Yes

Signature

Regards
Frank Kabel
Frankfurt, Germany

> Thanks for your reply, Frank.
>
[quoted text clipped - 30 lines]
>>
>> .

Reply to this Message