how to freeze the row and the column in Excel

admin ExcelComments374Read

To freeze the title row and the first column in Excel

We have to select the cell B3.文章源自LuckYou.ORG-

Why the cell B3?文章源自LuckYou.ORG-

Because later on when we use the freeze function. EXCEL will freeze文章源自LuckYou.ORG-

All the columns to the left of the selected cell and all the rows above the selected cell.文章源自LuckYou.ORG-

how to freeze the row and the column in Excel文章源自LuckYou.ORG-

Now we go to the tab called View and here we click on freeze panes文章源自LuckYou.ORG-

And again on freeze panes文章源自LuckYou.ORG-

And now when we scroll down文章源自LuckYou.ORG-

You can see that the title row will always be visible and also the NO. Column.文章源自LuckYou.ORG-

And that's it文章源自LuckYou.ORG-




:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: