#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Freezing Panes muerkilla New Users to Excel 3 April 4th 06 05:25 AM
Freezing panes Tiina Excel Discussion (Misc queries) 1 October 12th 05 12:18 PM
Freezing panes LAF Excel Discussion (Misc queries) 1 September 16th 05 03:56 PM
Freezing Panes Jmeyer Excel Discussion (Misc queries) 2 March 29th 05 08:41 PM
Freezing panes Excel User leka Excel Worksheet Functions 2 November 3rd 04 07:16 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"