How do I enable sorting of data in sheets that have column headings in row 1 frozen and protected. If I unprotect Row 1 then sorting works fine but I want to protect my headings and columns?
How do I enable sorting of data in sheets that have column headings in row 1 frozen and protected. If I unprotect Row 1 then sorting works fine but I want to protect my headings and columns?
Try this, it sorts data in ascending order from A2 (you can change the column you want to use), it takes in to account header row and unprotects then reprotects the worksheet.
Please Login or Register to view this content.
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks