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.

The Guts Of A Phishing Email

Are you ready to lose all your money, cancel all accounts, and probably experience a system failure? I’m sure you will never be ready for that, which is why it’s critical you recognize the anatomy of a phishing email to avoid becoming a victim. So here are several...

read more

Password Managers: Why should I bother?

Password managers do more for you than just help you remember which password you used for different accounts. In this post, I am going to dig a little deeper into explaining what password managers do and how can they benefit your personal security and privacy.  A...

read more

How to Protect Yourself from Ransomware

What you need to do in the short and long term to safeguard your company and employees from cyber threats. Over the last week, organizations across the globe were hit with a massive cyber attack involving ransomware. This is a type of malicious software that blocks...

read more