How to limit number of rows and column in worksheet?

H

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.
 
F

Francois via OfficeKB.com

Hrishi said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top