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.


what Is BDR

What Is BDR and How Does It Impact Business?

| Business Productivity, Security | No Comments
Businesses these days conduct most of their processes digitally. On one hand, this is great because it speeds up transactions, improves data accuracy, and so on, allowing for faster and more efficient IT business development. But the heavy reliance on digital data brings new risks of data loss or damage. All businesses should have a good backup and disaster recovery plan to lessen these risks. We will explain to you what is BDR and how it impacts businesses. An Introduction to What is BDR BDR stands for “backup and disaster recovery.” It is a set of solutions that make sure…
business growth and expansion

The Role of Current Technology in Business Growth and Expansion

| Business Productivity, Managed Services, Security | No Comments
Business growth and expansion entail a lot of work in all the different areas—logistics, finance, research, and technology. Technology plays a key role because practically all aspects of business rely on it. In our last few blogs, we have been talking about some benefits that small business owners can get out of integrating the right technology into their business, especially during expansion, downsizing, or switching from a remote work setup to a hybrid work environment. Attracting and Retaining Talent for Business Growth and Expansion For any SMB, attracting and keeping enterprise talent is quite an achievement. But, of course, it…
How Your IT Company Affects Customers

For Better or For Worse: How Your IT Company Affects Your Customers

| Business Productivity, Managed Services | No Comments
How Your IT Company Affects Customers is very important to keep your business operations in good hands. Most processes today rely on technology, so you need a provider to keep up with the times and ensure everything goes smoothly. But do you realize how your choice of IT company also affects your customers? The level of customer satisfaction might be one of the most revealing gauges of how efficient your IT company is. How Your IT Company Helps Affect Your Delivery of Better Service to Customers Although your IT provider does not have direct contact with your customers, the tasks they take…