Making a few cells static

mejayne · May 13th, 2002, 02:36 PM

I need to make just 4 cells "static". My spreadsheet has hundreds of rows, and only 4 columns. In column 6, I have a color bar I use to color all the rows a particular order. It's a legend of sorts. What I need is to keep those 4 cells in column 6 viewable at all times, yet still be able to scroll the first 4 columns. Freezing the rows/columns do not work. It freezes more than just those cells, which I do not want. Please help. This is a project I'm doing for work and it's got me stumped!

MeJayne

Chris Davison · May 13th, 2002, 02:43 PM

Quote:

On 2002-05-13 13:36, mejayne wrote:
I need to make just 4 cells "static". My spreadsheet has hundreds of rows, and only 4 columns. In column 6, I have a color bar I use to color all the rows a particular order. It's a legend of sorts. What I need is to keep those 4 cells in column 6 viewable at all times, yet still be able to scroll the first 4 columns. Freezing the rows/columns do not work. It freezes more than just those cells, which I do not want. Please help. This is a project I'm doing for work and it's got me stumped!

MeJayne

Would cutting column F and inserting it infront of column A.... then freeze panes with cell B5 selected, be an option ?

[ This Message was edited by: Chris Davison on 2002-05-13 13:44 ]

Mark W. · May 13th, 2002, 04:03 PM

Use the Window | New Window menu command to open an "new window" (e.g., Book1:2) onto your worksheet. Click the minimize worksheet button. Scroll and resize the new window to show only the cells you want. Position the new window so that it's visible when needed.

Ivan F Moala · May 13th, 2002, 04:07 PM

Quote:

On 2002-05-13 13:43, Chris Davison wrote:

Quote:

On 2002-05-13 13:36, mejayne wrote:
I need to make just 4 cells "static". My spreadsheet has hundreds of rows, and only 4 columns. In column 6, I have a color bar I use to color all the rows a particular order. It's a legend of sorts. What I need is to keep those 4 cells in column 6 viewable at all times, yet still be able to scroll the first 4 columns. Freezing the rows/columns do not work. It freezes more than just those cells, which I do not want. Please help. This is a project I'm doing for work and it's got me stumped!

MeJayne

Would cutting column F and inserting it infront of column A.... then freeze panes with cell B5 selected, be an option ?

[ This Message was edited by: Chris Davison on 2002-05-13 13:44 ]

Chris, I'm suprised you didn't recommend the
Camera Tool

to take a picture > place it
in a position where you Can freeze the rows/cols....

Chris Davison · May 13th, 2002, 05:00 PM

Ivan,

well yeah, but if we were going to freeze the columns and rows for an image, we may aswell just use the column the original colours are in.... I *was* tempted though

Derek · May 13th, 2002, 10:21 PM

Hi Guys
Been experimenting trying picture (screen shot) to remain stationary whilst scrolling. I didn't succeed with scrolling but this event macro will place the picture immediately to the right of any cell you doubleclick, from where you can move it around if you want. By altering the additional numbers you can place it where you want in relation to the cell you doubleclick.
Or use SelectChange and it will follow you about.
Presumably if someone knows the code that determines which is the top row visible on screen it could be tied to that and remain stationary whilst scrolling ?????
If anyone can do that I'd be interested to know

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With ActiveSheet.Shapes("Picture 1")
.Placement = xlFreeFloating
.Top = ActiveCell.Top + 5
.Left = ActiveCell.Left + (ActiveCell.Width) + 10
End With
End Sub

regards
Derek

[ This Message was edited by: Derek on 2002-05-13 21:23 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 02:36 PM	#1
mejayne New Member Join Date: May 2002 Posts: 1	I need to make just 4 cells "static". My spreadsheet has hundreds of rows, and only 4 columns. In column 6, I have a color bar I use to color all the rows a particular order. It's a legend of sorts. What I need is to keep those 4 cells in column 6 viewable at all times, yet still be able to scroll the first 4 columns. Freezing the rows/columns do not work. It freezes more than just those cells, which I do not want. Please help. This is a project I'm doing for work and it's got me stumped! MeJayne

May 13th, 2002, 04:03 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Use the Window \| New Window menu command to open an "new window" (e.g., Book1:2) onto your worksheet. Click the minimize worksheet button. Scroll and resize the new window to show only the cells you want. Position the new window so that it's visible when needed.

May 13th, 2002, 05:00 PM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Ivan, well yeah, but if we were going to freeze the columns and rows for an image, we may aswell just use the column the original colours are in.... I was tempted though

May 13th, 2002, 10:21 PM	#6
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Guys Been experimenting trying picture (screen shot) to remain stationary whilst scrolling. I didn't succeed with scrolling but this event macro will place the picture immediately to the right of any cell you doubleclick, from where you can move it around if you want. By altering the additional numbers you can place it where you want in relation to the cell you doubleclick. Or use SelectChange and it will follow you about. Presumably if someone knows the code that determines which is the top row visible on screen it could be tied to that and remain stationary whilst scrolling ????? If anyone can do that I'd be interested to know Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) With ActiveSheet.Shapes("Picture 1") .Placement = xlFreeFloating .Top = ActiveCell.Top + 5 .Left = ActiveCell.Left + (ActiveCell.Width) + 10 End With End Sub regards Derek [ This Message was edited by: Derek on 2002-05-13 21:23 ]