Locking cells in place?

[ianharper68]

Hi All,

Is it possible to lock cells in place so they remain in the same place? I want to do a top and side border where I have highlighted (see image) where I can add navigation buttons, print buttons etc but if I freeze pains say in cell 7C then they still scroll off the page or off the left of the page.

 

[KillerOfGiants]

Is there any information ever beyond column M or below row 37? If this is the entirety of information to ever be on this tab, then I would make column M and row 37 (or first column/row without any information) as small as possible, freeze panes there, and hide all columns beyond M and all rows beyond 37.

 

[ianharper68]

Is there any information ever beyond column M or below row 37? If this is the entirety of information to ever be on this tab, then I would make column M and row 37 (or first column/row without any information) as small as possible, freeze panes there, and hide all columns beyond M and all rows beyond 37.

Perfect that works great

 

[Peter_SSs]

Or without the need to freezing panes anywhere or hide anything, you could run this small vba code (adjusting the range if required)

Sub Set_Scroll_Area()
  ActiveSheet.ScrollArea = "A1:L36"
End Sub