Freezing column and row [Closed]

Report
Posts
1
Registration date
Sunday April 9, 2017
Status
Member
Last seen
April 10, 2017
-
Posts
1278
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 16, 2021
-
Hello,



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

1 reply

Posts
1278
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 16, 2021
220
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!