Thursday, September 29, 2011

Create Header Row in Excel 2007

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: