Wednesday, December 2, 2020
Home Excel Sheet How to Use the Freeze Panes Feature In Excel to Keep an...

How to Use the Freeze Panes Feature In Excel to Keep an Area on the Spreadsheet Visible?

How to Use the Freeze Panes Feature In Excel to Keep an Area on the Spreadsheet Visible?

When working on a very large spreadsheet data in excel, we always forget which rows and columns represent what type of data. It is quite easier to remember working on small data but remembering large spreadsheets is not an easy job.

You need to scroll through the data, the header row or column becomes invisible and we forget which rows or columns we were looking at. This leads to errors and becomes very confusing to deal with larger data sets.

But the good news is that you can fix this problem by using freeze panes feature in excel to keep every row or column header visible all the time. Today, we will teach you how you can utilize freeze panes feature of Microsoft Excel with very easy steps. 

Steps to Use Freeze Panes Feature In Microsoft Excel 

  1. Open the spreadsheet with some data in columns and rows in MS excel.

freeze panes feature

2. Click View from the title bar.

freeze panes feature

3. In the View option pane, select the “Freeze Panes” feature.

 

freeze panes feature

4. In the Freeze Panes drop-down menu, choose an option that you like.

screenshoot

5. You can freeze the first two rows or columns. Select the entire third row or column and click on the Freeze Panes option.

ss

Learn more “How to Use PivotTable in Microsoft Excel?”

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

How to Earn Online?

How to Earn Online? Online Earn is a destination that covers almost everything related to online earning techniques. It tells you how to earn money...

Why Do Websites Get Hacked?

Why Do Websites Get Hacked? Every month several vulnerabilities are found in most plugins that are used by the developers on their websites. We notice...

Which Incredible Things You Can Do Using Php In 2020?

Which Incredible Things You Can Do Using Php In 2020? When we talk about the web, how can we forget PHP, which is one of...

What are Common On-page Optimization Mistakes?

What are Common On-Page Optimization Mistakes? On-page optimization needs your concentration for entire SEO battle. In any event, doing one apparently little thing incorrectly, or...

Recent Comments