software

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

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.

JcR wrote:
gt;
gt; How do I create a workesheet that has only 10 rows and 10 columns

--

Dave Peterson


You'll have to settle for hiding the rows and columns that you don't
want showing.--
protonLeah------------------------------------------------------------------------
protonLeah's Profile: www.excelforum.com/member.php...oamp;userid=32097
View this thread: www.excelforum.com/showthread...hreadid=544128Dave,

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

quot;JcRquot; wrote:

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

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

Biff

quot;JcRquot; gt; wrote in message
...
gt; Dave,
gt;
gt; Is there an easy way to select the rows to hide ? ...without scrolling all
gt; the
gt; way to the bottom ?
gt;
gt; quot;JcRquot; wrote:
gt;
gt;gt; How do I create a workesheet that has only 10 rows and 10 columns

Highlight the first row to hide, push lt;ctrlgt;-lt;endgt; then lt;ctrlgt;-lt;right
arrowgt; 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--
bgeier
------------------------------------------------------------------------
bgeier's Profile: www.excelforum.com/member.php...oamp;userid=12822
View this thread: www.excelforum.com/showthread...hreadid=544128Quick 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.
quot;JcRquot; wrote:

gt; Dave,
gt;
gt; Is there an easy way to select the rows to hide ? ...without scrolling all the
gt; way to the bottom ?
gt;
gt; quot;JcRquot; wrote:
gt;
gt; gt; How do I create a workesheet that has only 10 rows and 10 columns