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