Default workbook with specified size

[omiof5]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Have looked but can't find how to do this. I want a default or template document that contains exactly 100 rows and exactly 10 columns. I don't want any other rows or columns to be visible.

I know rows and columns can be hidden but I can't seem to figure out how to hide everything except my 100 rows and 10 columns. In AppleWorks, I could specify that a new document be this size -- is there a way to do this in Excel?

I really have searched on my own. ;-} Don't know if I'm not using the correct search terms or what but this solution continues to elude me.

 

[CyberTaz]

You need to design the workbook the way you want it, hiding all rows/columns
beyond what you need, & save it as a Template in the My Templates folder
then base any new files of that type on the template (via File> Projects
Gallery - New).

Additionally you can make it your default workbook if you wish and/or design
a custom sheet & add it to the Elements Gallery so you can insert one into
any workbook. See Excel Help on:

Change the format and settings for new workbooks, and

Add a custom sheet to the Elements Gallery

HTH |:>)
Bob Jones
[MVP] Office:Mac