Spreadsheet width

[books4cars]

How do I make the horizontal scrolling limited? I don't want to see more than 20 columns by using the scroll bar with the mouse. I can do it vertically by having no data in lower rows.

 

[villy]

Try to remove the Horizontal scrolbar by goint into Tolls|Options then uncheck horizontal scrolbar

 

[Jaafar Tribak]

or maybe you can use the ScrollArea Property

With ActiveSheet
    .ScrollArea = "a1:t" & .Rows.Count
End With

 

[books4cars]

Where do I insert this code?

 

[neilp]

Press Alt + F11

on the left side, double click This workbook and in the white space that appears on the right side, paste

Private Sub Workbook_Open()
With ActiveSheet
    .ScrollArea = "a1:t" & .Rows.Count
End With

End Sub

Save and close the workbook (with macros enabled) and reopen it