Sorting in protected worksheet

		Microsoft Office Forums > Microsoft Excel > Excel
Sorting in protected worksheet

12-31-2016, 12:04 PM

NoSparks

Windows 7 64bit Sorting in protected worksheet

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Have all the cells of the table unlocked.
On the Protect Sheet dialogue, check both Sort and Use AutoFilter.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sorting data while in a protected workbook	Andy Francis	Excel	0	06-06-2015 01:35 AM
Unable to "Shift cells down" on unprotected area in a protected worksheet	ricky0309	Excel	0	08-14-2014 01:51 AM
Cell formating on Protected worksheet	AHB	Excel Programming	2	02-27-2012 10:25 AM
Insert/Paste Picture into Protected Worksheet	udea	Excel	1	02-06-2012 07:43 PM
Word mail merge from a protected Excel worksheet	Platform	Mail Merge	10	09-28-2011 05:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 PM.