It sounds like you should protect your worksheet to prevent users from
invoking functions that would harm your data/structure. It's under Tools
Protection Protect Sheet. Then you can select the functions you do want
to allow. If there are cells that the users have to edit, you can unlock
them individually (Format Cells Protection) and then enable that when
you set the worksheet protection.

Does that help?

" 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