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
1344
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 17, 2022
- Apr 10, 2017 at 04:05 AM
Hello,



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

1 reply

vcoolio
Posts
1344
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 17, 2022
249
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