Locking rows (not columns)?

[Lobster]

Hi
I download and store my bank statements in an Excel spreadsheet. This
is maintained in conventional 'bank statement' format; ie columns for
date, payee, amount, account balance, with one statement entry per row
in chronological order. I find it very useful to be able manipulate
the spreadsheet eg by sorting alphabetically by payee, so I can easily
see all payments made to a particular company grouped together.
However, it's very easy to use the 'sort' function incorrectly, so
that the date/payee/amount columns become completely dissociated from
each other, and if someone (SWMBO?!!) then saves the spreadsheet, all
the data is permanently trashed and I need to retrive from backup.

Question: I know there are various ways of protecting spreadsheets,
but is it possible to 'lock' the rows, thereby preventing the data
from separating from each other, while retaining the ability to sort
the columns (as above) at will?

Thanks
David

 

[Dave Peterson]

Maybe you could use Data|Filter|autofilter.
This might even be nicer than sorting.

You could record a macro that sorts your range (correctly <vbg>). Then let that
other person run that macro. (And toss those sort icons from the toolbar!)

Selecting the complete range, then Data|sort might be a good thing to emphasize.

And backup, backup, backup.