Forum Discussion
Protect lines in Excel?
Hi there, is there a way to keep lines together, such that information assembled in a line cannot accidentally be scrambled? To make my point clear: I organize data in rather large tables with, e.g...
Hi Peter,
thanks for your quick reply. I was aware of that option but didn't think it would solve my problem. Just to check: Will users still be able to sort or filter the data? Cause that would be okay with me, as long as they don't mix them up.
Best,
Konrad
if you have a PW on then sorting will not work.
Filtering will work but you must remember to tick the AUTOFILTER option (see below) when you protect the sheet.
Thanks
Peter