Every time I need to do this, I always have to look it up. I have the memory retention of a scratched CD. I paste something into Excel, I need to srot it, and I don't wnat the column headers to be included in teh sort. I figured since I'm stupid and have to look it up every time, there are probably a lot of other people who have to look it up to, so I'm posting it here:
View tab --> Freeze Panes --> Freeze Top Row
Baaaaaa-BAM!
As an aside, hey Microsoft, how about you put it in the right click menu? You know, I select the row, right click, and right there for all to see is an option Make Header Row.
After over a decade of Excel you'd think they could make this easier.
No comments:
Post a Comment