BusinessAanalyst_Alpha
New Member
- Joined
- Jan 21, 2024
- Messages
- 7
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
- Mobile
- Web
Hello Guys! How to do this kind of freeze pane? Thank you.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to do this kind of Freeze Pane is this?
- Thread starter BusinessAanalyst_Alpha
- Start date
Excel Facts
How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 8,972
- Office Version
- 365
- Platform
- Windows
The freeze panes you are showing is distinctive to what happens when you have a table, in that the headings are not below the Column reference grid (A,B,C etc) but replace those headings with the table headings.
I suspect that your data is already a table in which case the thing you might be missing is that your active cell (selected cell) has to be inside the table range.
If you click anywhere in the table and then scroll down the table headings will show where you normally see the column letters.
I suspect that your data is already a table in which case the thing you might be missing is that your active cell (selected cell) has to be inside the table range.
If you click anywhere in the table and then scroll down the table headings will show where you normally see the column letters.
Upvote
0
