1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/LadyVelrankian
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel
#Spreadsheet
#Sorting
#Filtering
#Column A
#Column H
#Locking Cells
#Sharepoint
#Blocks
#ID's
#Order
#Alphabetical Order
#Data Integrity
#Multiple Users
#Student
#Cell Order
#Data Arrangement
#Data Manipulation
#Row Order
#Formula