How to Freeze Rows and Columns in Excel

How to Freeze Rows and Columns in Excel

Excel Tutorial Summary: Freeze Rows and Columns in Excel


Learning how to freeze rows and columns in Excel is up there on the list of things you need to learn as an Excel newbie. This simple yet powerful feature allows you to scroll through large data sets, freeze dashboards, charts or pretty much any object in Excel by freezing rows or columns. Freezing rows and columns is especially helpful when you have information / data outside the cells that are displayed on your screen.

You can either watch the video located below or you can work through the step by step processes also located below..

Skill Level: Beginner

Video: How to Freeze Rows & Columns in Excel

video icon

 

I’m a huge advocate for learning by video so in this clip, I’ll introduce and show you how to freeze rows and columns in Excel.

This section is made specifically for those of you who learn better by seeing / watching.

How to Freeze Rows in Excel

1

Select a Row

The first step of the process is to select the row (by highlighting the row number on the left).  Any content/cells above the highlighted row will be frozen so that when you scroll through your worksheet, you’ll continue to see that content.

2

Select View & Freeze Panes

The second and last step of being able to freeze rows in Excel is to head over to the view tab of the quick access ribbon and select freeze panes.  Once you’ve done this, as you scroll down through your spreadsheet, any rows above the row select will remain in sight on your worksheet.

How to Freeze Columns in Excel

1

Select a Column

The first step of the process is to select the column (by highlighting the column letter on the top of your spreadsheet).  Any content/cells left of the highlighted column will be frozen so that when you scroll through your worksheet from right to left, you’ll continue to see that content.

In the example below, I’ve frozen all columns to the left of column C so that we can see the stock name and its ticker symbol.

2

Select View & Freeze Panes to Freeze Columns

The second and last step of being able to freeze columns in Excel is to head over to the view tab of the quick access ribbon and select freeze panes.  Once you’ve done this, as you scroll to the right in your spreadsheet, any columns to the left of your highlighted column will remain in sight on your worksheet.

How to Freeze Rows & Columns in Excel

1

Select a Cell

The first step of the process is to select a cell whereby you want all columns to the left to be frozen and all rows above the cell to be frozen.  This will then allow columns and rows to the left and above to always be shown when scrolling through your worksheet.

In the example below, I’ve selected cell C2 so that all columns to the left of column C and all rows above row 2 will remain frozen when scrolling.

2

Select View & Freeze Panes to Freeze Columns and Rows

The second and last step of being able to freeze columns and rows at once in Excel is to head over to the view tab of the quick access ribbon and select freeze panes.  Once you’ve done this, as you scroll to the right or down in your spreadsheet, any columns to the left and any rows above your highlighted cell will remain in sight on your worksheet.

Learn By Doing – Buy a $5 Dashboard


Excel Inventory Planning Dashboard
Excel Human Resources Salary Dashboard
Excel Customer Aged Receivables Dashboard

Three 60 Second Excel Custom Number Formatting Videos that will Help you get Noticed in the Office

Three 60 Second Excel Custom Number Formatting Videos that will Help you get Noticed in the Office

Last week I had the opportunity to put a little bit of time into building a few videos on my YouTube Channel that focus on how to effectively use Excel custom number formatting.  Let’s be honest, when I put it that way, it sounds a little bit lame and boring.  I can assure you however that there are a few tricks in here that will likely get you excited about going to work tomorrow to show it off to your boss. Let’s dive right into the videos that are going to make your workweek a little more bearable by making you look like an Excel guru.

(more…)

Three 60 Second Excel Custom Number Formatting Videos that will Help you get Noticed in the Office

Excel in 60 Seconds: Learn How to Display Numbers in Thousands in Excel

It has been quite sometime since I last posted a video on YouTube and to tell you the honest truth, I’m not sure why I don’t do it more often.  What is even more funny is that my wife has been all over me about doing videos saying that it’s really just the best way to help people learn.  This week I’m going to run a quick experiment and I’ll be posting a 60 second video every night for the remainder of  the week on my YouTube channel just to see if my wife was actually right (and yes I know, she is normally right about everything).  I’m going to see what kind of feedback I get from the experiment and if it is positive,  I’m going to try and run more short 60 second videos throughout the week, every week.

(more…)

Creating Pivot Tables 101: A How-To InfoGraphic

Creating Pivot Tables 101: A How-To InfoGraphic

You know the saying, “a picture is worth a 1000 words”? Well, I’m hoping that this post can convey to you in a quick, easy and visual fashion how to create a pivot table.  Please do not be shy and share it with everybody you know – or just post it on your social media accounts and maybe even your office cork board (do they still exist?). (more…)

3 Smart and Simple Tab Shortcuts To Make Your Life Easier

3 Smart and Simple Tab Shortcuts To Make Your Life Easier

As humans, we are always looking for smarter, better and quicker ways of doing things – especially the repetitive and often annoying day to day tasks.  There are days where we quite literally wish we had a monkey by our sides to perform these tasks, allowing us to spend our time doing things that are of actual value.  Thankfully Excel offers tab shortcuts that help us easily navigate between workbooks, change the name of workbooks at the drop of a hat and enter formulas, formatting and other Excel goodies onto multiple sheets all at the same time – can you believe it!  In this post we are going to look at 3 smart and simple tab shortcuts to make our lives easier and really, just make our day way better. (more…)

How to Create a Button Link in Excel – Link Between Worksheets

How to Create a Button Link in Excel – Link Between Worksheets

When we are building dashboards in Excel, we often want to build links between worksheets or spreadsheets.  To do that we can use hyperlinks.  This was kind of a life changing concept to me because it allowed you to build and style your own buttons into whatever shape, size and format you wanted.

I’m going to leave this GIF image with you to teach you how you can do this in a few easy steps. Enjoy!

Lareg_Create Button Links To Other Tabs In Excel