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.


Social Engineering

January Recap: All You Need to Know About Social Engineering

| Managed Services, Security | No Comments
This month, we covered a range of topics concerning social engineering. Social engineering is now considered one of the most prevalent risks when it comes to online security. Most hackers rely heavily on social engineering tactics to lure unsuspecting users to divulge information. It sounds complicated but it's nothing more than the practice of manipulating people into revealing information through the use of false pretenses. It often creates a sense of urgency, fear or excitement, playing with people's emotions to get them to do exactly what the hackers want them to do. In case you missed any of them, here…
Cybercriminals Use Social Engineering

The Top 5 Ways Cybercriminals Use Social Engineering

| Managed Services, Security | No Comments
Advanced technology and cutting-edge hacking techniques have been the main tool that cybercriminals use for online attacks. But did you know that the most effective method that hackers use for enticing victims online is something so much simpler? Cybercriminals use social engineering or in other words, manipulate people by establishing trust and playing on their emotions. Common Methods of Social Engineering Attacks There are a number of creative ways that social engineers go about their devious ways. However, there are five ways that stand out on how cybercriminals use social engineering for their personal gain. Phishing This method is by…
Social Engineering scams

Where Does Social Engineering Scams Come from?

| Managed Services, Security | No Comments
Social engineering scams are so much more rampant these days than ever before. There will certainly be suspicious-looking items in your inbox when you check your emails, which are most likely phishing emails. Many people now know to avoid clicking these malicious emails, which is a good thing. But still, their vast amount makes you wonder, where do social engineering scams come from anyway? The very simple answer to that is social media. How Social Media Is Used for Social Engineering scams According to the latest count, there are more than 4.74 billion social media users today. For hackers, each…