fbpx 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.


employee awareness

Employee Awareness Is Your Best Security

| Business Productivity, Security, Uncategorized | No Comments
For business communication security, employee awareness is your first line of defense. The more your staff know about the risks, the better prepared they are to deal with potential attacks and the safer your business will be. Unfortunately, recent studies have shown that more than half of employees today lack training in online security. For a business owner like yourself, this can be a frightening idea. Such a lack of awareness and training poses a grave danger to your business should you become the target of an online attack. Check Your Employees’ Level of Awareness But don't fret just yet.…
Communication Security - Risk Management

Risk Management for Communication Security

| Business Productivity, Security | No Comments
Digital technology has advanced dramatically over the years, and today we get to communicate in ways that were unheard of before. From simple emailing for work and chatting with friends across the globe to high-speed real-time videoconferencing and accessing massive amounts of information within seconds, we have come a long way. When was it time to consider worrying about communication security? But together with these improvements, new communication risks have also emerged. Hackers have also used technology to hone their craft, and businesses need to find effective ways to thwart these risks and stay protected online. Longer Online Time The…
Communication Security

The Importance of Communication Security for Your Business

| Business Productivity, Security | No Comments
Ransomware attacks happen every 11 seconds, according to cybersecurity experts. This statistic is very alarming and continues to worsen. Users of all types are being targeted, from individuals to multinational corporations. The severity of the attacks and the ransom vary considerably, but there is one common factor. Practically all cyberattacks begin with a breach in communication security. Despite the disturbing trends, many businesses are still not fully realizing the importance of security in business communication. Less than half of small companies have protective measures against ransomware attacks, and more than a quarter of employees lack proper training in online security.…