Freezing the Header row in Excel

OK… this is one of those stupid things I probably should already have known, but I finally decided to look up how to do it. You know how sometimes when you’re in an Excel spreadsheet, you can scroll up and down the rows, but the first row of Header columns stays fixed? Here’s how you do that…

When you’re in an Excel spreadsheet, select View > Freeze Panes > Freeze Top Row:

excel-freeze-header-20170324-1

Now when you scroll the row content, the Header stays fixed, making it very easy to remember what each column is for:

excel-freeze-header-20170324-2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s