Column headings: make always visible?

[ATL]

I have not been able to find a posting on this topic. Is there a way
to make the column headings stationary? I want to be able to scroll
down the rest of the grid and have the Row 1 headings always visible.

In other words, I want Row 1 to stay put and let the rest of the rows
disappear underneath it as I scroll down.

 

[leef_me]

Uh, this is a posted to a Powerpoint newsgroup.
Your question seems more specific to a spread- sheet program, perhaps
MS Excel.Maybe that is why you can't find a posting on the topic.

That said, if your question is about Excel, look up 'column headings
stationary' in the Help File that comes with Excel.

HTH, Leef_me

 

[ATL]

I'm using PowerPoint 2003.

 

[Steve Rindsberg]

I have not been able to find a posting on this topic. Is there a way
to make the column headings stationary? I want to be able to scroll
down the rest of the grid and have the Row 1 headings always visible.

In other words, I want Row 1 to stay put and let the rest of the rows
disappear underneath it as I scroll down.

Is this an Excel question that made it into the PowerPoint group by mistake?

If so, you'll want to use one of the Excel specific groups next time you have a
question, but for now, here's what you need to do:

At the very top of the vertical scrollbar in Excel, just above the up-arrow,
there's a little horizontal bar you can grab and pull down. It splits the
window in two independently scrollable windows.

To make the second window go away, drag the little horizontal bar back up to
the top

 

[Bill Dilworth]

Again, as you said Steve, a wayward post ...

.... however, I think he's talking about freezing the panes. In Excel,
select the cell that is immediately below and to the right of the areas that
you want to remain visible. Then select Windows => Freeze panes. Now the
headings on top and on the left will remain visible as you scroll away into
the sunset.

More so however, this can only be set from the Excel program, not from
within the edit worksheet object inside PowerPoint. So if you want to set
this in a presentation (in case the OP was not really lost), you will need
to use the route of ... select the spread sheet on the slide, right click =>
Worksheet Object =>Open =(new Excel instance)=> select the cell below and to
the right of the panes you wish to lock => Windows => Freeze panes => File
=> Close & Return to PresentationX.

On the other hand (oh good heavens, Bill), Excel spread sheets can only
display the top and left most section from within a PowerPoint show, and it
is only when they are edited within PowerPoint that he window freeze feature
would have any usefulness, which makes me thing the OP was lost rather than
incredibly innovative.


Oh, and try news://msnews.microsoft.com/microsoft.public.excel for general
excel questions.

--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
yahoo2@ Please read the PowerPoint
yahoo. FAQ pages. They answer most
com of our questions.
www.pptfaq.com
..
..

 

[Echo S]

I'm using PowerPoint 2003.

In that case, you'll need to be more specific about what you mean by "Row
1." Row 1 of *what,* exactly? A datasheet on a graph? An embedded Excel
spreadsheet? Something else?

Remember, we can't see what you're doing there, so you have to be specific
in your descriptions.

 

[Steve Rindsberg]

Again, as you said Steve, a wayward post ...

.... however, I think he's talking about freezing the panes. In Excel,
select the cell that is immediately below and to the right of the areas that
you want to remain visible. Then select Windows => Freeze panes. Now the
headings on top and on the left will remain visible as you scroll away into
the sunset.

Ah, THAT's where it is. Thanks, Bill. I was thinking of including that in my
reply also but I can never find the sucker when I need it.

On the other hand (oh good heavens, Bill)

Indeed. You're up to what, four now, and do you have any idea how silly it
looks when you wiggle the fingers on the one growing there behind your left
ear?