If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
limiting the number of rows/columns in worksheet
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 - |
#2
|
|||
|
|||
limiting the number of rows/columns in worksheet
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 FormatRowHide. Repeat with the columns. HTH Anders Silven "bikebetty2001" skrev i meddelandet ... 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 - |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |
Event for Worksheet Name Change | Drew Lettington | Worksheet Functions | 3 | July 15th, 2004 10:49 PM |
Limiting the number of records that can be created | Ant | General Discussion | 2 | June 23rd, 2004 07:09 AM |
Excel- Inserting a varying number of rows | Ken Wright | Worksheet Functions | 1 | March 20th, 2004 10:20 PM |
counting number of occurances | Phillip | Worksheet Functions | 5 | January 13th, 2004 09:46 PM |