|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
02-21-2003, 09:32 AM
|
#1 |
|
Premium Member
Join Date: Jun 1999
Posts: 9,231
|
MS-Excel Help
Was wondering, if there was any way to limit the number of rows or columns in a spreadsheet on a per spreadsheet basis. For example, I want no more than 500 rows on my spreadsheet. Is it possible to do so? If so how?
Thanx a heap. |
|
|
|
02-21-2003, 10:34 AM
|
#2 |
|
Member (11 bit)
Join Date: Dec 2001
Location: Shakopee MN
Posts: 1,293
|
can't answer that myslelf, but www.mrexcel.com has had some good answers for me in the past
|
|
|
|
|
02-21-2003, 11:24 PM
|
#3 |
|
Member (12 bit)
Join Date: Dec 1999
Location: Oklahoma
Posts: 3,261
|
There is probably an excel guru out there somewhere that will know the answer to this one, but I don't think there is a way to reduce the limit.
You can hide any rows or columns that you don't want to be used. The bad thing about hiding them is you can still scroll to those areas but it will just be blank making it rather difficult to know exactly where you are. |
|
|
|
|
02-22-2003, 06:26 AM
|
#4 |
|
Premium Member
Join Date: Jun 1999
Posts: 9,231
|
Thanx for the tips.
|
|
|
|
|
02-23-2003, 04:23 PM
|
#5 |
|
Member (10 bit)
Join Date: May 2000
Location: New Zealand
Posts: 546
|
I normally just use the hide option myself.
Most users don't know how to unhide, and if they do, they are probably sophisticated enough to realise that it was done for a good reason. If you want to go further, you could use VBA to either disable, or generate a warning, if the unhide option was used. HTH, David. |
|
|
|
|
03-03-2003, 10:27 AM
|
#6 |
|
Member (5 bit)
Join Date: Jan 2002
Location: North Carolina
Posts: 21
|
sdkfz . . . . Thank you . . . Thank you . . . Thank you . . . for that Mr. Excel link . . . that place is Nirvana to a number geek like me .. . of course I am not worthy and they are wayyyyyyy ahead of me . . . but what a great resource!!
Thanks again!!  Just out of curiosity , , why do you want to limit the rows and columns? I haven't had a need to do this, but I believe that, if nothing else is available, then the Hide option, as mentioned, would be your best bet. Last edited by mgreene; 03-03-2003 at 10:49 AM. |
|
|
|
|
03-03-2003, 11:10 AM
|
#7 |
|
Member (11 bit)
Join Date: Dec 2001
Location: Shakopee MN
Posts: 1,293
|
m greene, I have to agree about the mr excel, it has saved me several times, the hardest thing about all of these apps is knowing "what that functionality is called" I can not tell you how many people I have told what concatenation is. They all tried the typical words to 'merge' two text fields (merge, add etc) and of course if you are not trying concatenation you get nowhere
glad to help |
|
|
|
|
03-04-2003, 01:25 AM
|
#8 |
|
Member (4 bit)
Join Date: Feb 2003
Location: Townsville Australia
Posts: 14
|
You can use many rows in columns i asked that my self in class the other day when we were working excel i'm still trying to work out the cell and formar, I have to get it fix befor i go ahead on my Assessment.
|
|
|
|
|
03-04-2003, 11:05 AM
|
#9 |
|
Member (5 bit)
Join Date: Jan 2002
Location: North Carolina
Posts: 21
|
sdkfz, you're right. I would think of `merge` or something like it long before the word `concatenation` would occur to me. But without it, a search gets you nowhere.
 Merri |
|
|
|
|
03-04-2003, 05:27 PM
|
#10 | |
|
Member (10 bit)
Join Date: May 2000
Location: New Zealand
Posts: 546
|
Hi RainMaker,
Please can you elaborate on this: Quote:
Hopefully we can help. David. |
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
