12 December 2017

How to Freeze and Unfreeze Columns and Rows in Excel


excel-dashboard-tips

You can fit a lot of data into an Excel sheet. With thousands upon thousands of rows and columns, it can get pretty unwieldy. One small feature that makes it easier to manage all of that data is the ability to freeze rows and columns so that no matter where you scroll in the spreadsheet, those rows or columns always stay visible. How to Freeze the First Column or Top Row in Excel With this method, you’re going to have to choose to freeze either the row or column. Unfortunately, you can’t do both. Open your Excel spreadsheet and go to the View tab. Click...

Read the full article: How to Freeze and Unfreeze Columns and Rows in Excel


Read Full Article

No comments:

Post a Comment