Freezing column and row

[Closed]
Report
Posts
1
Registration date
Sunday April 9, 2017
Status
Member
Last seen
April 10, 2017
-
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
-
Hello,



how do you freeze first column and top row in excel?

1 reply

Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
Hello Dellosa,

To freeze the first row and first column:-

- Click on cell B2 in the required sheet.
- Select the "View" tab at the top of your sheet and, in the Window group, click on "Freeze Panes".
- From the drop down that appears, select "Freeze Panes".

Done!

Cheerio,
vcoolio.