Search the Community
Showing results for tags 'sort'.
I have a protected worksheet but I want users to be able to sort one of the tables. When protecting the sheet I checked the options allowing users to select cells, sort and use auto filter but it won’t allow the table to be sorted without entering the password for the sheet. What am I doing wrong? Excel 2010 Abby
I made a table 4 colums wide and 4 pages long. The colum titles on each page are Name, Surname, Number, Date. I do an a to z sort on the Name column ascending and the titles on page 1 are ok. The problem is that the titles on pages 2, 3, 4 get sorted and move up the list. What sort settings do use to not sort the Name, Surname, Number, Date so they stay at the top of page 2, 3, 4.Thank you.
I have a an Excel table with a high medium and low column. I want to sort items into high medium and low but the table sorts the words alphabetically so i get all the highs then the lows with the mediums at the bottom of the list. Is there a way to get excel to sort the column so the highs all come first followed by the mediums with the lows at the bottom of the list.