disable scroll and hide unused columns and rows

[gta1216]

I have an Excel file that is only using 5 columns and 10 rows. How can I hide the unused column and rows? I know how to highlight the unused columns and rows and right-click hide, but was wondering if there another method. BTW, column A and row 1 is blank. Data starts on column B and row 2.

Since there are only 5 columns and 10 rows being used, can I disable scrolling without using VBA?

 

[Michael M]

To stop scrolling use
File>>Options>>Advaned>>Display for this workbook>>Uncheck Vertical & Horizontal scroll bars

 

[gta1216]

This only hide the scroll bars, but you can still scroll with the wheel on the mouse. Is there a way to disable scrolling for this specific workbook / worksheet?

 

[Michael M]

Ok try using this snippet of code
When the workbook is opened it will restrict the sheet to the are specified.

Private Sub Workbook_open()
Sheet1.ScrollArea = "A1:L21" 'adjust ranges to suit
End Sub