•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What is the best method to lock columns?
I have a consolidated payment list across different teams. I need everyone to follow the same template and formating. Sometimes they add space in the header and my consolidated pivots gets broken or some columns are only combobox and they completely delete it and add their manual data. I have tried the Ctrl+1 and locking it up but this time the Ctrl+Shift+L stuff is not working. Is there any other better way?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#real-time data collaboration
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#intelligent data visualization
#lock columns
#consolidated payment list
#template
#formatting
#header
#pivots
#combobox
#manual data
#Ctrl+1
#Ctrl+Shift+L
#space
#data integrity