Freezing Column Headings in Long Excel Spreadsheets

by Yehuda Cagen 14. September 2010 06:34



Have you ever found yourself frustrated when trying to read a really long spreadsheet full of data because the column headings do not appear on all pages?


Houston IT consultant Cheryl Smith shares a few tips on how to freeze cells so you can read the column headins of long spreadsheets.



Simple way to read column headings in long spreadsheets:


  1. Click the row below the heading aka titles of the spreadsheet


  1. Select the Window tab on the toolbar


  1. Click Freeze Panes


Note: A line will appear directly under the information that will be frozen.


This allows you to continue scrolling through the entire spreadsheet and still be able to read the titles of the columns.


We hope you have found this information helpful. If you would like to learn more about this subject, please feel free to contact us:


·        Questions about this article?

·        Suggest a topic

·        Learn more about our Houston IT Consulting



Microsoft Training


Add comment

(Will show your Gravatar icon)

  Country flag

  • Comment
  • Preview

About IsUtility®

IsUtility® is a turnkey  Houston infor-
mation technology
solution that
brings accountability back to the IT
services industry. We've already
invested in your business - all the
servers and remote pc support -
eliminating the costs and risks of
owning  an onsite IT infrastructure.

Ask The Experts!

Send your IT questions directly to our knowledgeable experts. Since 2000, we’ve helped executives just like you make sense of business technology!
Your Question

Message was successfully sent

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Join our FREE Email Mailing List
For Email Marketing you can trust
Follow Us facebook twitter LinkedIn