|
| 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
July 25th, 2004, 09:11 PM
|
|||
|
|||
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
July 25th, 2004, 10:48 PM
|
|||
|
|||
|
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 |
Linear Mode
