Hi Experts I have attached a sample *.XLS file which is an extract of one much wider sheet from a multi-sheet file. To freeze or lock your first column, click the Freeze Panes icon and select Freeze First Column. About this tutorial: Video duration: 5:28 In this Excel 2016 Tutorial Video, you will learn to use Freeze Panes to freeze rows and columns in your Excel In this example, we want to freeze rows 1 to 6, so we've selected row 7. Excel 2016: Freeze Panes Updated: 4/16 Freeze Panes In Excel 2016, you may have header rows or columns on the spreadsheet that you want to see as you scroll through the spreadsheet. Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze.
![view freeze frame in excel windows 10 is grayed out view freeze frame in excel windows 10 is grayed out](https://support.content.office.net/en-us/media/122e60e9-6038-48ce-95c0-e592751e2459.jpg)
What to Do When the Freeze Panes Command is Disabled in Excel. As you have just seen, freezing panes in Automatically freeze panes to show the heading row. To freeze a column, or a set of columns, you need to select the column to the right of the column(s) you want to freeze. Learn more about deleting blank cells in Microsoft Excel. Hello Friends, and welcome again to our channel, The Teacher. Unfortunately there is nothing new at all.
#View freeze frame in excel windows 10 is grayed out how to
13, 2017, /screen-with-freeze-panes hi friends welcome to may i help you panagarh, in this tutorial you can learn how to freeze multiple row and column in excel. Figure 1 is the result of using Excels Freeze Panes feature. 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. Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. On the View tab, click Freeze Panes > Freeze Panes.
![view freeze frame in excel windows 10 is grayed out view freeze frame in excel windows 10 is grayed out](https://www.technipages.com/wp-content/uploads/2016/06/Excel-Freezing-Side-Pane.png)
To freeze or lock your top row, click the Freeze Panes icon in the ribbon and select Freeze Top Row. Excel lets you freeze the top row or the first column so that they remain visible as you move through the spreadsheet.