Custom view

[kras]

Hi,

When I use horizontal and vertical scrollbars in an excell worksheet I would like to see only a specified area of that sheet, ex. A1 to AB30. Is it possible?

Thank you,

kras

[starguy]

Hi,

When I use horizontal and vertical scrollbars in an excell worksheet I would like to see only a specified area of that sheet, ex. A1 to AB30. Is it possible?

Thank you,

kras

You can hide columns and rows
click on any cell in column AC and press Ctrl+Shift+Right arrow key and press Ctrl+0 to hide columns.
click on A31 and press Ctrl+Shift+Down arrow key and press Ctrl+9 to hide rows.

[kras]

Thanks, starguy

[starguy]

Thanks, starguy

You're welcome.

[kras]

Hi Starguy,

Is there a way to lock the view only on those cells, without the need to hide the rest rows/columbs?

kras