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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Dave,

Is there an easy way to select the rows to hide ? ...without scrolling all the
way to the bottom ?
 
Hit function key F5
Enter 11:65536
OK (or ENTER)
Right click, select Hide
F5 (again)
Enter A1
OK (or ENTER)

Biff
 
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
 
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.
 
Back
Top