Delet columns and rows

[shrikant sinnur]

dear sir,

i most of the time use excel.

i want to know that,

i want to keep columns from A to H and Rows from 1 to 55.

i want to delete rest all columns and rows and it should not generate the columns and rows again and again.

pl, help me

thanking you

shrikant

 

[erik.van.geit]

select column I
press SHIFT+CONTROL+RIGHT ARROW
Now columns I till the last column are selected
rightclick within the selection
choose "hide"

same for the rows, of course you will use ARROW DOWN