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
Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 9,493
- 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
