Excel ze top row and first column how to#

By scrolling right, we can view the frozen data columns.Now, we can see the gray line which indicates that the columns are now locked.Next, in the Freeze Panes drop-down menu in the Window group, choose the Freeze Panes option.After that, on the ribbon, select the View tab.First, select the column behind those we want to freeze.So let’s have a look at those procedures to freeze multiple columns in Excel.

As we want to view the product name and the price of those products. Suppose we want to freeze column B and column C. To do this we need to follow some procedures. If we wish to lock multiple columns, we can easily do that with Excel.

Excel ze top row and first column how to#

Read More: How to Freeze Top Two Rows in Excel

Now, we can scroll down the worksheet to see the frozen rows at the top while going down.

Finally, As shown by the gray line, the rows will lock in place.

Next, select Freeze Panes from the Freeze Panes drop-down menu of the window group.

Secondly, select the View tab on the ribbon.

We want to freeze rows 1 to 9 in our case.

Firstly, select the rows we want to freeze from the list below.

Now, let’s go through the following steps to freeze multiple rows. Assume that we need to freeze the rows up to row 10. We can freeze multiple rows in Excel using the freeze panes command. And, we can still view the frozen rows when we scroll through our data. We could choose to keep certain rows of our spreadsheet displayed at all times. The dataset contains some product name in column B and their price in column C as well as the product’s percentage of value-added tax (VAT). To Freeze multiple panes in Excel, we are using the dataset below. In this article, we will cover some benchmarks about the Freeze Panes command. To keep a section of the worksheet displayed while scrolling to another part of it, we are going to use the Freeze Panes to freeze multiple panes.

Related Articles How to Freeze Multiple Panes in Excel: 4 Different Criteria