Freezing Rows and Columns in a Spreadsheet

John Biglin, CEO | September 28, 2012

One really cool thing that you can do in Excel is freeze your heading rows and columns so they remain visible as you scroll through your spreadsheet. This will let you compare facts and figures as well as move quickly through your data. You can also split panes into multiple worksheets so that you scroll in one pane while information in the others remains static. Follow these steps to lock specific rows or columns in your spreadsheet:

Follow these steps to lock specific rows or columns in your spreadsheet:

  1. Highlight the cells you want to lock.
  2. Click on the Window menu option.
  3. Select Freeze Panes.

Microsoft Teams Gets Private Channels

Microsoft Teams is a collaborative workspace in Office 365 that brings together people, content and conversations. Previously, to chat privately with a group of team members, separate Teams had to be created outside of the originating team within which a group would...

read more

SMB Success Story: Jack’s Diving Locker

Did you know that technology is helping to protect and save our oceans? With #cloud security and communication tools, @JacksDiveLocker has exponentially increased their outreach and education efforts to keep our oceans healthy and thriving.

Want to see how the latest #security tools can help grow your business? Contact the Client Engagement team at Interphase Systems ( or 610-276-5500) to get started today!

read more

The Importance of Teamwork and Collaboration

We live in a world of constant disruption where business models are undergoing constant change. This article explores the impact of these trends on collaboration and teamwork and the most important skills for the 2020 workplace. Contact Interphase Systems for help in...

read more

A Day in the Life – Compliance

Meet Diego, a Compliance Officer who works closely with his company's IT team to ensure employees abide by internal policies and regulations set by regulatory bodies. Check out this infographic to see how Diego uses productivity and collaboration tools in Teams across...

read more