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 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?
Who's Online 0 Members, 0 Anonymous, 4 Guests (See full list)
There are no registered users currently online