hello,
I'm working with a form and I'll be interested to show only this form, with
no option to run throught the rest of the worksheet that content no data.

It's possible to customize the number of rows and columns?

I tried to hide the rows/columns but there's a too much rows to hide them
all.
What do you think it's the best solution...?
Thank you in advance!!! ;-))

Personally, I don't like to hide rows or columns.

I think that most people who use excel understand that the worksheet grid may
show more than what is actually used.

And for those people who are just getting started with excel, I don't see a
reason to hide all the rows/columns from them.

That said, I do try to reset the last used cell so the "elevator" on the
scollbars doesn't overshoot the "real" range.

Debra Dalgleish shares some tips on how to reset this last used cell:
http://contextures.com/xlfaqApp.html#Unused

Tuckland wrote:

hello,
I'm working with a form and I'll be interested to show only this form, with
no option to run throught the rest of the worksheet that content no data.

It's possible to customize the number of rows and columns?

I tried to hide the rows/columns but there's a too much rows to hide them
all.
What do you think it's the best solution...?
Thank you in advance!!! ;-))

--

Dave Peterson

I tried to hide the rows/columns but there's a too much rows to hide them
all.

It's the same amount of effort no matter how many rows there are. An
example of hiding all rows after row 10:

-Select A11.
-Hold Ctrl and Shift down and press the Down arrow key.
Now A11:A65536 are selected.
-Hide then via the Format menu or using the shortcut Ctrl-(

--
Jim
"Tuckland" wrote in message
...
| hello,
| I'm working with a form and I'll be interested to show only this form,
with
| no option to run throught the rest of the worksheet that content no data.
|
| It's possible to customize the number of rows and columns?
|
| I tried to hide the rows/columns but there's a too much rows to hide them
| all.
| What do you think it's the best solution...?
| Thank you in advance!!! ;-))

Thank you very much Jim and Dave

Your indications Jim was very helpful


"Jim Rech" wrote:

I tried to hide the rows/columns but there's a too much rows to hide them
all.

It's the same amount of effort no matter how many rows there are. An
example of hiding all rows after row 10:

-Select A11.
-Hold Ctrl and Shift down and press the Down arrow key.
Now A11:A65536 are selected.
-Hide then via the Format menu or using the shortcut Ctrl-(

--
Jim
"Tuckland" wrote in message
...
| hello,
| I'm working with a form and I'll be interested to show only this form,
with
| no option to run throught the rest of the worksheet that content no data.
|
| It's possible to customize the number of rows and columns?
|
| I tried to hide the rows/columns but there's a too much rows to hide them
| all.
| What do you think it's the best solution...?
| Thank you in advance!!! ;-))