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.


A Second Look at your Hybrid Workforce

| Business Productivity, Infrastructure, Leadership, Tech Tip | No Comments
In the last two years, companies worldwide have transitioned from a traditional office setup towards a hybrid workforce model as a part of a solution to the pandemic situation. While many employees are going back to the office, physical capacity in the workplace is still limited, and many companies need to make adjustments to accommodate everyone. Many businesses are finding that using a hybrid workforce is a solid long-term solution. Connecting Everyone through Teams In a hybrid workforce environment, employees get divided into teams where some complete work at the office while others do their job from remote locations, usually…

Video: What do a Shared CIO and House Calls Have in Common?

| Consulting, Leadership | No Comments
Our Shared CIOs make house calls like a medical professionals used to. Why? Terry Allen, Shared CIO & Sr. Security Consultant with OXEN Technology, explains why this is so valuable.
Happy Thanksgiving

Happy Thanksgiving from OXEN

| Uncategorized | No Comments
Happy Thanksgiving from the Team at OXEN Technology