Skip to main content

How to freeze a row or column in Excel

By July 6, 2021July 8th, 2021Tech Tip
OXEN Tech Tip

If you’re working on a large spreadsheet or a long list in Excel, you may want to freeze the top row or the left column. This way if you scroll down or towards the right, your labels or other information are always visible. So how do you do this?

Freeze Top Row

  1. Go to View on the Ribbon toolbar.
  2. In the Window group, click Freeze Panes > Freeze Top Row.

Freeze Top Row in Excel

You’ll see a solid gray line appear below the frozen row. If you scroll down, the top row will stay visible.

Freeze Top Row in Excel

Freeze First Column

  1. Go to View on the Ribbon toolbar.
  2. In the Window group, click Freeze Panes > Freeze First Column.

Freeze First Column in Excel

You’ll see a solid gray line appear next to the frozen column. If you scroll right, the left column will stay visible. For example, in the screenshot below, you can see Column A is frozen, and when scrolling right it’s displaying right next to Column E.

Freeze First Column in Excel

How to Unfreeze Panes

To unfreeze all rows or columns, click Freeze Panes > Unfreeze Panes.


Wi-Fi router security

Don’t Leave Your Wi-Fi Router Vulnerable

| Security, Tech Tip | No Comments
A common security appliance in homes and offices is the Wi-Fi router. It’s the device that distributes your Internet connection to all your devices. It’s a critical and powerful electronic item that you don’t want to overlook when securing your network.
What Is Zero Trust Networking?

What Is Zero Trust Networking & Why Is It Important Now?

| Leadership, Tech Tip | No Comments
Maybe you’ve heard the term “zero trust networking” and wondered what it is. This term has become a little bit more mainstream over time and it's been gaining momentum.

Video: How to Recognize a BEC Scam or Suspicious Email

| Security, Videos | One Comment
Terry Allen, Sr. Security Consultant with OXEN Technology, walks through some examples of business email compromise scams, and what suspicious details to look for.