Freezing column and row

Closed
dellosa Posts 1 Registration date Sunday April 9, 2017 Status Member Last seen April 10, 2017 - Apr 10, 2017 at 02:32 AM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Apr 10, 2017 at 04:05 AM
Hello,



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

1 reply

vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
Apr 10, 2017 at 04:05 AM
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.
0