How to limit number of rows and column in worksheet?

[Hrishi]

Generally when we creat 'new' - blank Worksheet, it has 65536 rows and upto
'IV' columns by default.
We could see some excle worksheet customized to have only limited rows and
columns as per requirements.
Similarly suppose i want only 100 rows and wirst 25 coulmns only how to
limit this.

 

[Francois via OfficeKB.com]

Generally when we creat 'new' - blank Worksheet, it has 65536 rows and upto
'IV' columns by default.
We could see some excle worksheet customized to have only limited rows and
columns as per requirements.
Similarly suppose i want only 100 rows and wirst 25 coulmns only how to
limit this.

You can hide the rows / columns you don't need.

Highlight the rows

right click the mouse

choose hide