limiting the number of rows/columns in worksheet

B

bikebetty2001

Can I limit the number of rows and/or columns in a
worksheet? I don't want hundreds of rows, just maybe 50
per worksheet. Thanks -
 
A

Anders Silven

You can limit the number of *visible* rows/columns (the worksheet will still
have 65535 rows and 256 columns),
- select the rows you want to be invisible and choose Format>Row>Hide. Repeat
with the columns.

HTH
Anders Silven
 

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

Similar Threads

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Macro to select and delete levels of a document 2
Need Help with a VBA subroutine 0
Duplicates and different worksheets 0
formula for arriving net difference 0
Copy addition formula of non-consecutive horizontal cells 2
Multiple IF Statement in Word 5
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Top