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.


Business ROI

Do You Know Your Business ROI?

| Business Productivity, Uncategorized | No Comments
Do You Know Your Business ROI?  Business ROI, or return on investment, is a tool used to measure the profitability of your business based on your various costs and the profits generated by these investments. The performance of the business ROI can also have an assortment of implications on the different aspects of your business.   A positive ROI indicates that an investment has delivered welcome profits. But it's more than just a metric used to monitor the feasibility of your business investments. By maintaining a solid ROI, you are also creating positive effects on your total cost of ownership, R…

5 Reasons Why Planning Business Growth Matters

| Business Productivity, Uncategorized | No Comments
When starting a business, it is only natural for the business owner to dream of success and growth for their new venture. But having a dream is not enough. There also needs to be a strategic business plan to ensure that the business will thrive. Unfortunately, many small business owners have the mindset that planning is only for large companies. Some of them don't think that learning business planning skills is necessary. They don't realize that planning for growth is one of the most important things you should do for your business. Here are five tips to help you build…
Business Budget

The Fastest Way to Lose Track of Your Business Budget

| Business Productivity, Uncategorized | No Comments
Business budgeting is a very important part of running a business, regardless of whether you are a startup or an established company operating for years. Creating a budget is not a problem for most business owners. The challenge is sticking to the budget as the business grows and the spending expands. The Problem of Hidden Costs If you are like many owners of small and medium-sized businesses, you probably focus on the services and products you need when making a projection of your business expenses, which is what you should do. However, do you also consider the hidden costs of…