set the rows and columns to 10 rows and 10 columns on the sheet

[Guest]

How do I create a workesheet that has only 10 rows and 10 columns

 

[Dave Peterson]

You can't.

But you could hide columns 11:256 and rows 11:65536 if you really wanted to.

My opinion is that most people are aware of how excel works and would be more
distracted by the hidden rows/columns than by seeing those empty cells.

 

[protonLeah]

You'll have to settle for hiding the rows and columns that you don't
want showing.

 

[Guest]

Dave,

Is there an easy way to select the rows to hide ? ...without scrolling all the
way to the bottom ?

 

[Biff]

Hit function key F5
Enter 11:65536
OK (or ENTER)
Right click, select Hide
F5 (again)
Enter A1
OK (or ENTER)

Biff

 

[bgeier]

Highlight the first row to hide, push <ctrl>-<end> then <ctrl>-<right
arrow> and all of the rows from your selected row to the end will be
selected.
Right click on any selected cell, on the pop-up, click hide.
Repeat for the columns

 

[Guest]

Quick Keyboard method to achieve this. You may want to record this as a
macro if you are going to do it often:

choose Edit | Goto
Enter IV65536 in the Reference entry area, click [OK]
[Ctrl]+[Shift]+[Home]
Hold [Shift] and press the Down Arrow to unselect rows 1-10
Format | Row | Hide
[Ctrl]+[Home] to get back to A1
Select K1
[Ctrl]+[Shift]+[Right Arrow]
Format | Column | Hide

Hope this helps some.