restrict worksheet columns

[MetLife]

Hi,

I am looking at a spreadsheet provided by a colleague. It appears to have restricted the column's viewable.

So I can only scroll over to column AH, and then it just ends. This must be a setting, it is not like the extra columns are hidden.

Does anyone know how to alter these settings? This is excel 2010.

Thanks

 

[Tetra201]

Try opening the VB editor and looking for ScrollArea in the worksheet Properties.

 

[MetLife]

OK thanks, that was it!

 

[Tetra201]

You are welcome.