Forum Discussion
Solved
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...
I ended up just creating a column to the left that wasn't included in the table that was numbered.
Hi,
Instead of sequential numbers you may use in first column something like
=ROW()-ROW($A$2)
if you data starts from row 2
- I know your tip is 5 years old, but it's great!
Thank you, in modern Excel SEQUENCE() works great.
- I appreciate that update. After a bit more Googling, saw that function too! Thanks again!
