QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Freeze Rows and Columns in MS Excel 2016?

By Neha T Leave a Comment

Suppose, you have an Excel sheet that contains a lot of data. To read the data at the bottom of the sheet, if you scroll the sheet upward, the headings that lie in the top row will be invisible. It will make no sense of reading data without headings. Same is the case with column if you scroll the sheet rightwards the columns to the left will be invisible. The best way to retain rows and columns is to freeze them. Frozen rows and column will appear, no matter wherever you are on the sheet. So, let us learn How to Freeze Rows and Columns in MS Excel 2016?

Steps to Freeze Rows and Columns in MS Excel 2016:

Step 1: Open an Excel sheet on your screen, of which you want to freeze rows and columns. In the image below you can see that I have an Excel sheet of which I want to freeze top row and first two columns.

how-to-freeze-row-and-column-in-ms-excel-in-2016-step-1Step 2: Go to the View tab and under Window group click on Freeze Panes drop-down button.

how-to-freeze-row-and-column-in-ms-excel-in-2016-step-2Step 3: Under Freeze Panes You have three options Freeze Panes, Freeze Top Row and Freeze First Column.

Freeze Panes: It combinely freezes rows and columns that appear above and to the left of the selected cell respectively.
Freeze Top Row: This freezes top row of the Excel sheet.
Freeze First Columns: Freezes the first column of the Excel Sheet.

how-to-freeze-row-and-column-in-ms-excel-in-2016-step-3Note: You can not select Freeze Top Row and  Freeze First Column simultaneously.

Step 4: Now, if you want to freeze rows and columns simultaneously. You have to select a cell in the Excel sheet which exactly lies below the rows and next to the columns you want to freeze. Then under Freeze Panes, drop-down options click on Freeze Panes. It will freeze all the row above the selected cell and all the columns to the left of the selected cell.

how-to-freeze-row-and-column-in-ms-excel-in-2016-step-4In the picture above, I froze top row and first two columns, and for that, I have selected the cell that lies below the top row and next to the second column.

Step 5: If you have selected the first cell of the Excel sheet then there does lie any rows above it and any columns beside its left side to get frozen. In this case, the Excel sheet is frozen at the centre.

how-to-freeze-row-and-column-in-ms-excel-in-2016-step-5Note: The Freeze Panes button does not work in Page Layout view, or cell editing mode. It does not even work if the sheet is protected.

how-to-freeze-row-and-column-in-ms-excel-in-2016-step-6

Thank You. Keep Reading.

You Might Also Like:

how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? how-to-transpose-in-ms-excel-2016-featured-imageHow to Transpose in MS Excel 2016? hide columns feature imageHow to Hide and Unhide Rows & Columns in Excel? Merge Cell in Excel feature imageHow to Merge Cells, Columns & Rows in Excel? delete blank row feature imageHow to Delete Blank Rows in Excel 2016? compare two columns in Excel Feature imageHow to Compare Two Columns to Find Matches & Differences in Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Create an Outlook Account?
  • How to Export Bookmarks in Google Chrome?
  • How to Change Start Button in Windows 10?
  • How to Delete Macro in MS Excel 2016?
  • How to Add and Remove Watermark in Excel

Copyright © 2023 · QueHow · Contact Us