ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   freezing panes ! (https://www.excelbanter.com/excel-discussion-misc-queries/198646-freezing-panes.html)

Naidu

freezing panes !
 
Hello there !

I came across this requirement, as I scroll down the page all my headers
should get freezed at the top. I've been suggested by one of the respected
user if not freezing panes in between I could go for grouping and I sincerely
accepted that.

As a suggestion I would like to place this, if possible can there be a way
implemented to opt this way of freezing. Like I have
Header "A"
content A1
A2
A3, etc under A
And Header "B"
content B1
B2
B3, etc under B

So, as I scorll down these headers A and B should be retained at the top.
Please Suggest ! if I did not know excel and if there is a way already to do
this or if no way this way can help.


--
Naidu

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Dave Peterson

freezing panes !
 
I would change the layout and put each "header" on each row (insert a new column
A and put them there???).

Then I could use freeze panes to see the headers for each field. I could use
data|filter|autofilter to limit my view to certain "headers". I could sort the
data easier. I could create pivottables easier. I could create charts
easier....

Naidu wrote:

Hello there !

I came across this requirement, as I scroll down the page all my headers
should get freezed at the top. I've been suggested by one of the respected
user if not freezing panes in between I could go for grouping and I sincerely
accepted that.

As a suggestion I would like to place this, if possible can there be a way
implemented to opt this way of freezing. Like I have
Header "A"
content A1
A2
A3, etc under A
And Header "B"
content B1
B2
B3, etc under B

So, as I scorll down these headers A and B should be retained at the top.
Please Suggest ! if I did not know excel and if there is a way already to do
this or if no way this way can help.

--
Naidu

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


--

Dave Peterson


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com