Prev: Trim function
Next: Adding to an existing Pivot Table
From: dwake on 19 May 2010 10:29
Is it possible to have a range of cells or an object float while scrolling.
From: Gary''s Student on 19 May 2010 10:46
You can freeze rows or columns while scrolling by using:

Windows > Freeze panes
--
Gary''s Student - gsnu201003


"dwake" wrote:

> Is it possible to have a range of cells or an object float while scrolling.
From: dwake on 19 May 2010 11:11
right, but I'm not looking to freeze cells, I'm looking at having a specific
range float while scrolling. I already have cells frozen for column heading
viewing, I also want to make a definition key visible while scrolling through
columns of data.

"Gary''s Student" wrote:

> You can freeze rows or columns while scrolling by using:
>
> Windows > Freeze panes
> --
> Gary''s Student - gsnu201003
>
>
> "dwake" wrote:
>
> > Is it possible to have a range of cells or an object float while scrolling.
From: Tom Hutchins on 19 May 2010 12:13
I don't think you make a range "float" stationary above the rest of the
workbook. You might try using New Window to open a second window of the same
workbook. In XL2007 it's in the Window section of the View ribbon. In earlier
versions it's on the Window menu. Then select View Side by Side (called
Compare Side by Side With before XL2007). One of the windows will have :1
added to the title bar; the other will have :2 added to its title. In XL2007
you can turn off synchronous scrolling, so that one window remains static
while you move around in the other. You can also freeze panes independently
in the two windows. Close either window to return to a normal view.

Hope this helps,

Hutch

"dwake" wrote:

> right, but I'm not looking to freeze cells, I'm looking at having a specific
> range float while scrolling. I already have cells frozen for column heading
> viewing, I also want to make a definition key visible while scrolling through
> columns of data.
>
> "Gary''s Student" wrote:
>
> > You can freeze rows or columns while scrolling by using:
> >
> > Windows > Freeze panes
> > --
> > Gary''s Student - gsnu201003
> >
> >
> > "dwake" wrote:
> >
> > > Is it possible to have a range of cells or an object float while scrolling.
From: Chip Pearson on 19 May 2010 17:54

You can use the Camera tool.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com


On Wed, 19 May 2010 07:29:01 -0700, dwake
<dwake(a)discussions.microsoft.com> wrote:

>Is it possible to have a range of cells or an object float while scrolling.
 | 
Pages: 1
Prev: Trim function
Next: Adding to an existing Pivot Table