Freezing column and row
[Closed]
Report
dellosa
vcoolio
- Posts
- 1
- Registration date
- Sunday April 9, 2017
- Status
- Member
- Last seen
- April 10, 2017
vcoolio
- Posts
- 1320
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- October 8, 2021
Related:
- Freezing column and row
- How to convert column to row in notepad++ ✓ - Forum - Excel
- Excel - Re-arrange data from columns into rows - How-To - Excel
- Convert Single Column to Rows, into Matching Rows ✓ - Forum - Excel
- Help! Need to copy only some columns in rows that have X condtn ✓ - Forum - Excel
- Excel if column contains value then copy row to another sheet ✓ - Forum - Excel
1 reply
vcoolio
- Posts
- 1320
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- October 8, 2021
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.
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.
