In Microsoft Excel, there are lots of keyboard shortcuts to make the process of solving any problem easier and faster. Use of Keyboard Shortcut to Freeze Columns in Excel 5.1 Freeze First Column Using Keyboard Shortcut Here we will be able to scroll through Columns A & B.ĥ. Finally, we will see that Columns A & B are frozen now.From the drop-down click the option Freeze Panes. Select the new Freeze Panes option in Quick Access Toolbar.We will select Column C as we want to select Columns A & B. After that, select the Column immediately right to the Column that you want to freeze.Click on Add button to add the option in Quick Access Toolbar. From the window, select the Freeze Panes option. From the drop-down, select the More Commands option. Firstly, go to the Quick Access Toolbar and select the Customized Quick Access Toolbar drop-down.Again we will use the dataset of our previous methods to understand this one. It’s somehow similar to previous Method 1 but very convenient sometimes. We can freeze columns with this feature also. Magic Freeze Button is a Customized Quick Access Toolbar. Add Magic Freeze Button to Freeze Columns
#How to freeze a column on excel how to#
Finally, if we scroll left to right, we will see that Columns A & B are frozen.After that, we will see a horizontal and a vertical line intersecting the selected Cell’s top left corner.In short : View > Freeze Panes > Freeze Panes From the dropdown select the first option Freeze Panes. Next, select the View option from the ribbon.So let’s see how easily we can figure out this problem. To do this, we will use the earlier method’s dataset of twelve salespersons. We can apply this when we need to freeze particular Rows and Columns at the same time. In Excel ‘Freeze Panes’ option refers to Freeze Row and Column together. Excel ‘Freeze Panes’ Option to Freeze Multiple Columns and Rows Together We will be able to scroll through the worksheet while Columns A & B remain visible.Ģ. There is a thin vertical line on the left side of column B. Finally, we can see Column A & B is frozen now.Select the Freeze Panes option.In short: View Tab > Freeze Panes > Freeze Panes In our vase, we will select Column C as we want to freeze columns A & B. Firstly, select the Column that is immediate to the right of the last column that we want to freeze.To solve this problem we need to go through the following steps. We will be able to move other frozen columns.įor this example, we will use our earlier dataset. In this method, we will freeze multiple Columns of a dataset. Sometimes we need to freeze multiple Columns. We can see that we can scroll through the sheet content while continuing to view the frozen Column A. After clicking on the Freeze First Column option, a new vertical line will appear before Column B.In short: View Tab > Freeze Panes > Freeze First Column Then, select the Freeze First Column option. Secondly, go to the Freeze Panes drop-down. We will solve this problem step by step.įirstly, In this step click on the View Tab. Suppose we have a dataset of twelve salespersons and their amount of sales for January to June. This feature helps to freeze different Columns and Rows. There is an option named Freeze Panes in the dropdown of the View Tab. View Tab is an option in the Ribbon of Microsoft Excel. Freeze Column with View Tab in Excel 1.1 Use of View Tab to Freeze the First Column
5 Effective Methods of How to Freeze Columns in Excel 1.
0 kommentar(er)
