---
title: Excel 2010 - Locking Columns  and Rows
description: Excel 2010 - Locking Columns  and Rows
---

[KnowledgeWave Blog ](https://www.knowledgewave.com/blog)

# [Excel 2010 - Locking Columns and Rows](https://www.knowledgewave.com/blog/msoffice/excel/excel-2010-locking-columns-and-rows.html)

 Written by [Dan St. Hilaire](https://www.knowledgewave.com/blog/author/dan-st-hilaire) | March 29, 2011

In this session, we will show you how to Freeze and Split panes in Excel 2010. Freeze panes allow you to freeze columns and rows making them visible as you scroll within a worksheet. Split panes allow you to split your worksheet into multiple views, letting you scroll in one pane of the worksheet, while other panes remain static.

Like this tip? Want more like this? Check out KnowledgeWave's 30-Day Free Trial. 

[View full post](https://www.knowledgewave.com/blog/msoffice/excel/excel-2010-locking-columns-and-rows.html)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Dan St. Hilaire"
  },
  "dateModified" : "2015-09-16T13:26:42.001Z",
  "datePublished" : "2011-03-29T10:57:47Z",
  "headline" : "Excel 2010 - Locking Columns  and Rows",
  "image" : {
    "@type" : "ImageObject",
    "height" : 60,
    "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
    "width" : 60
  },
  "mainEntityOfPage" : "https://www.knowledgewave.com/blog/msoffice/excel/excel-2010-locking-columns-and-rows.html",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "KnowledgeWave Blog"
  }
}
```