Locking Columns And Rows in Excel 13

Assume that we have a spreadsheet full of data and while scrolling down we get lost with all the data. We can’t see what data corresponds to the appropriate labeled cell. The same when we scroll to the right of our spreadsheet, we can’t see the first column which contains important information that we always want them to be viewable. In Excel we can freeze panes in our spreadsheet so that they always remain visible. To keep column titles and info always into sight we must follow the steps below.

First of all we must select the View tab and from the area of the ribbon named Window we select the arrow next to the command Freeze Panes for the drop down menu to appear, as shown in the image below.

Freeze Panes

We see that the available commands are the following:

  • Freeze Panes:
  • Freeze Top Row:
  • Freeze First Column:

To make these commands understandable, we have a large spreadsheet as shown below, where we want to navigate through our data. The only thing though is that when we want to scroll down in our spreadsheet we want the first two rows (1 and 2) to be visible, and when we want to scroll to the right in our spreadsheet we want the first column (A) to be always visible. How can it be done? Of course with the command Freeze Panes. First of all we must find the right cell for this to work.

Spreadsheet

In the spreadsheet above we want to lock the first two rows, which contain the labels for our columns such as income, expenses and the suppliers that we associate with. Also we want to lock the first column which contains the dates that we have bought from our suppliers. In order to accomplish that we must go to the cell B3 because we want the two above rows to freeze and we want the column to the left A to freeze.

Selected Cell

Then we go to the View tab and from the area of the ribbon named Window we select the command Freeze Panes and from the drop down menu that appears we select the command Freeze Panes as shown in the image below.

Freeze Panes

Once the command is selected a grid horizontal and vertical line appears above the selected cell B3 and at the end of column A.

Proper Cell

Now if we scroll down in our spreadsheet the rows 1 and 2 will be always visible so we can always see the labels as shown in the image below.

Scroll Down

If we scroll to the right in our spreadsheet the A column which contains the dates will always be visible in our spreadsheet as shown in the image below.

Scroll Right

For any reason we want to unfreeze the parts of the window we just select the same command with the procedure described above, only now it mentions Unfreeze Panes as we can see in the image below.

Unfreeze Panes

If we only want to freeze the Top Row meaning the line 1 we select the command Freeze Top Row as shown in the image below no matter what cell is activated.

Freeze Top Row

If we only want to freeze the First Column meaning Column A we select the command Freeze First Column as shown in the image below no matter what cell is activated.

Freeze First Column

Whatever we choose we can still Unfreeze the panes by selecting the command Unfreeze Panes as described above.

You can also check out the video below describing the Freeze Panes feature in Excel.

Freeze Panes in Excel 13

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on July 3, 2013, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , . Bookmark the permalink. Comments Off on Locking Columns And Rows in Excel 13.

Comments are closed.