Can you elaborate more about your situations?

You said they will mix up your data when sort, but how is it mixed?

for example

A
Name
Topmost
John
Peter
Iris

after sort:
A
Name
Iris
John
Peter
Topmost


So Topmost should not be sorted, is this your situation?

or you have many rows as heading on leftmost columne but after sorting, they
mixed up?




" wrote:

Is it possible to lock data in rows so they dont mix up when you sort?
I know it would be better to use an database program as Access, but
ive been asked to work in excel and i really need this function since
people are gonna mess my data up otherwise.

Thankful for any help!

/Jeo