Sort Order and Locking Cells
Hello wonderful excel users, I am hoping for some assistance with a spreadsheet I'm trying to improve on. The Excel spreadsheet is accessed by multiple people via Sharepoint and a big challenge i am finding is how "messy" the cells look.
Column A has a list of blocks (6 per student). Column H has a list of ID'S which are in letter and number form. When working on a particular block, I filter so its just the block and then we sort by the ID'S. However, it doesn't keep the name in alphabetical order. Once the filters have been removed, Column A (blocks) have all been jumbled around.
So my question is, is there a way to to lock Column A to reflect the appropriate block order for that particular student. And then be able to sort my ID. Once the filters are removed, everything stays as is?
I'm sorry if this doesn't make sense.
Thank you in advance for taking the time to reply.
[link] [comments]
Want to read more?
Check out the full article on the original site