Sorting in locked sheets

  • Thread starter Thread starter Ken Curtis
  • Start date Start date
K

Ken Curtis

I need to be able to sort (A-Z, Z-A) in a sheet some of the cells in which
have been locked. Is there a way?
 
Try this:

Click Tools > Protection > Protect Sheet > Select sort within Allow all
users of this workbook to:
 
Which will allow sorting only on a contiguous range of unlocked cells.

Say A1:F30 are unlocked, you could sort that range.

If even one cell within that range was locked, sort would not be possible.


Gord Dibben MS Excel MVP
 
Hi Ken

If you can unprotect the sheet, you should be able to sort the dat, then
lock the sheet again.

I'm not sure what happens with the locked cells, though. That is, I'm not
sure whether the locking stays with the cell reference or the data.

Try it on a copy of your worksheet first, just in case.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a template that I can reproduce every month by keying ininformation from SAP 8
Sorting Function 2
Sorting a protected sheet 1
Sorting a protected set of cells 3
Sorting the pivot table field list 4
How do I lock ONLY the formatting on an excel sheet? 2
Conditional formatting a cell containing "<" 4
Hyperlink to cell within a sheet breaks when cells are sorted 1

Back
Top