Step 2: Prevent users from editing these cells An arrow should appear next to each column header.ģ.Go to Review tab-> Allow Users to Edit Ranges 1.Click “New…”ģ.“Refers to Cells” should already contain the cells you want to allowing sorting on.Ĥ.If you want to allow only certain people to sort, give the range a password. Step 1: Make cells editable so that sorting will work.Īdd cells we want to sort to a range and make that range editable in “Allow Users to Edit Ranges.” This allows users to edit these cells when the worksheet is protected, even if they are locked cells.ġ.Select all the cells you would like the user to be able to sort, including their column headings.Ģ.Go to the Data tab and click Filter.
