ExcelBanter - how do i limit my worksheet size to say 11 columns and 11 rows.

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how do i limit my worksheet size to say 11 columns and 11 rows. (https://www.excelbanter.com/new-users-excel/106894-how-do-i-limit-my-worksheet-size-say-11-columns-11-rows.html)

Richard

how do i limit my worksheet size to say 11 columns and 11 rows.

Gord Dibben

how do i limit my worksheet size to say 11 columns and 11 rows.

You cannot have less than the default number of rows and columns Excel provides
with your version.

You can hide the ones you don't want to see.

Using VBA you could limit the scrolling range to only those 11 columns and 11
rows.

Gord Dibben MS Excel MVP

On Thu, 24 Aug 2006 09:03:02 -0700, richard
wrote:

All times are GMT +1. The time now is 04:46 PM.