Skip to content

Mstoic

  • Home
  • Start Here!
  • Best Deals
  • Facebook Tricks
  • Privacy
  • Resources
  • TOC
  • Tools
    • Web Tools
      • Stop Watch
      • QR Code Generator
      • Adsense Code Converter
      • Blogger Sitemap Generator
      • Difference Between Two Texts
      • Vacation Checklist
      • Twitter Symbols
      • Count Down
    • Investment
      • SIP Calculator
      • Power of Compounding
      • PPF Calculator
      • FD Calculator
  • About Us

How To Freeze Rows And Columns In Excel 2010

Editorial Team | January 22, 2014January 24, 2014 | How To, Microsoft Office |

While working in excel sheets, we mostly label the columns of the top most row according to the content the column is going to contain. But after adding some rows of content, the top most row with the labels is scrolled away and we have to judge the label of the column by reading its content. But not now, we have a solution.

  • How To Embed Any YouTube Video In PowerPoint
  • How to Convert docx to doc Format Online
  • How to Convert Word Files to JPEG Format
  • How To Embed A YouTube Video In PowerPoint 2010 And Higher
  • How to Open docx Files Without Microsoft Office 2007 or Higher

What Is Freezing Of Rows In Excel

Freezing is a way of keeping rows or columns visible at all times, even if you scroll down. With freezing rows in Excel, you can keep the topmost row, leftmost column, or any number or rows/columns within the excel sheet in view all the time.

Freeze Topmost Row And Left Most Column

Freezing the topmost row or the leftmost column in Microsoft Excel is dead simple. From the top navigation, go to View. Now under the Window group, select Freeze Panes. Now from the pop-up menu, select “Freeze Top Row” to freeze the top most row and “Freeze First Column” to freeze the leftmost column.

Freeze-Rows-In-Excel-2010-Img

To freeze certain rows in Excel, first scroll to the first row to be frozen (the first row you want to freeze needs to be the first row visible on screen), now select all the rows you want to freeze and click the Freeze Panes button. Do the same if you wish to freeze certain columns.

If you want to unfreeze your rows and/or columns, select the Unfreeze Panes button. Unfreeze Panes button will appear in place of Freeze Panes button once you freeze any row/column.

Previous Post

PNG VS JPG - Which To Use And When

by Editorial Team

Next Post

How To Embed Any YouTube Video In PowerPoint

by Editorial Team

Tags
  • Freeze Rows In Excel 2010
Recommended Next
Disable User Accounts Control [Windows 7]

Your Comment Cancel reply

Follow Us

Like us Follow us Follow us

Categories

  • Tricks (93)
  • Facebook (83)
  • Tips (76)
  • Windows (67)
  • Wordpress (39)
  • Android (38)
  • Internet (33)
  • Antivirus (30)
  • How To (29)
  • Webmasters (25)
  • Customization (25)
  • Downloads (21)
  • Utilities (21)
  • Gmail (20)
  • Windows 7 (19)

Related Articles

  • Reverse a String using StringBuilder