• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
Techwalla
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Lock Column Headers on Microsoft Excel

How to Lock Column Headers on Microsoft Excel

March 31, 2015
By: Jennifer Loucks
  • Share
  • Share on Facebook

Working on a large spreadsheet in Microsoft Excel can sometimes be difficult to maneuver when important columns do not display as you move throughout the spreadsheet. Locking header or title columns allows you keep them visible while you scroll through the spreadsheet. Locking columns in Excel is an option called freezing panes. This toll is available for locking rows by following the same steps to lock a column, except you highlight the desired row.

Video of the Day

...
Lock columns to make them visible while scrolling through the spreadsheet.

Step

Open a worksheet in Microsoft Excel. Add row and column header text as desired.

Step

Click on the column letter on the right side of the column you want locked. This highlights the entire column. Highlight a group of columns by clicking on the first column and dragging the mouse, with the left button depressed, across the desired columns to highlight.

Step

Click on the "View" tab if using Microsoft Excel 2007. Under the Window group item in the menu, click on the arrow for "Freeze Panes." Select the option to "Freeze First Column" to lock only the one column highlighted. Select the option to "Freeze Panes" if you want to freeze a group of panes at one time.

Step

Click on the "Window" menu if using Microsoft Excel 2003 and select "Freeze Panes" to lock one or a group of columns.

Step

Repeat the process listed in steps 1 through 4 to unlock the column by selecting "Unfreeze Panes."

Show Comments

Related Articles

How to Insert a Row or Column in an Excel Spreadsheet

How to Insert a Row or Column in an Excel Spreadsheet

Around The Home
Productivity
By: Carol Finch
How to Add an Appendix to a Word Document

How to Add an Appendix to a Word Document

Around The Home
Productivity
By: James T Wood
How to Print Address Labels in Excel

How to Print Address Labels in Excel

Around The Home
Productivity
By: Scott Shpak
How Do I Design an Excel Spreadsheet to Track Rentals?

How Do I Design an Excel Spreadsheet to Track Rentals?

Around The Home
Productivity
By: Chad Davis
How to Lock & Unlock an Excel Spreadsheet

How to Lock & Unlock an Excel Spreadsheet

Around The Home
Productivity
By: David Weedmark
How to Tally Survey Results

How to Tally Survey Results

Around The Home
Productivity
By: Louise Balle
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2018 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.