Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Floating Cells
Is it possible to have a range of cells or an object float while scrolling.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Floating Cells
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Floating Cells
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Floating Cells
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Floating Cells
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 wrote: Is it possible to have a range of cells or an object float while scrolling. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Floating cells | Excel Worksheet Functions | |||
Floating Cells | Excel Worksheet Functions | |||
Floating Cells | Excel Worksheet Functions | |||
FLOATING CELLS | Excel Worksheet Functions | |||
floating cells | Excel Discussion (Misc queries) |