Freeze Panes - Can I freeze a specific set of cells?

Good Morning,

I am currently working on a spreadsheet which shows our product sales for the last 3 years. (attached)

My problem lies when I try to freeze the panes from Cell E30 on 'Door' (ignore 'All' that is my figures sheet)

I freeze the panes, this holds Row 29 in place, Which I Want.

But upon holding colum E as I try to scroll to the right, the line chart moves with it.

My question is:

Is there a way I can scroll through the figures, keeping columns A-C in place(D is hidden) and allowing the line graph to stay in view?

Many Thanks
Ross



BreadButter2 - COPY.xlsx

Have you tried the Camera tool? May do what you want.

Chris

Hi Chris,

Camera Tool??

I've never heard of it, Could you elaborate on this for me.

Thanks
Ross

When Freezing panes what cell are you selecting? If it's A30 then this just freezes the top rows if you select E30 then all the rows above 30 are frozen and all the columns A-D are also frozen.

Is this what you want?

Chris

Hi Chris,
I am selecting Cell E30 so colums A-D are from and all rows above are froze aswell.

My issue is that when i click left on the scroll bar, the graph moves with it, So I lose part of the graph with each left click.

I want everything above row 28 to stay completely visible.

Many Thanks
Ross