Change the size of the sheet?

Z

zhaoning.zju

Hi, everyone,

I need only 30 rows, 7 columns in my worksheet, and I want column H, I,
J, ... row 31, 32, 33, ... to "disappear" from my worksheet, even the
column/row indicators (i.e. H, I, J, ... at the top, and 31, 32, 33,
.... at the left side of the view).

What can I do?

Thanks.
 
R

Ragdyer

You can't get rid of them!
All you can do is hide them.

Click in the header of Column H, to select,the entire column, then:
<Ctrl> <Shift> <RightArrow>

This will select all the columns, out to IV.
Right click in this selection and choose "Hide".

Click in the row header of Row 31, then:
<Ctrl> <Shift> <DownArrow>,
To select all the rows down to 65536,
And do the same as above to hide these selected rows.
 
Top