Forum Discussion
Bryan Kospender
Jan 15, 2018Copper Contributor
Can I lock a column so it doesn't get sorted?
I have created a table on a sheet in excel. I made the first column a column of numbers, 1-100, so that when I print it all my rows will be numbered for easy reference. ie. me telling "Joe" look at l...
- Jan 24, 2018
I ended up just creating a column to the left that wasn't included in the table that was numbered.
dschulze
May 05, 2023Copper Contributor
I know your tip is 5 years old, but it's great!
SergeiBaklan
May 08, 2023Diamond Contributor
Thank you, in modern Excel SEQUENCE() works great.
- dschulzeMay 08, 2023Copper ContributorI appreciate that update. After a bit more Googling, saw that function too! Thanks again!