Only want part of worksheet

  • Thread starter Thread starter mushy_peas
  • Start date Start date
M

mushy_peas

Is it possible to limit the size is a worksheet. say A1:h400.
So there are no cells beyond this range, its just completley blank and
there are no cells.

CHeers
 
Hi mushy

You can't delete the rows in Excel.
But you can hide them if you want like this

1) Select row 401(Click on 401to select the whole row)
2) Ctrl-Shift-down Arrow to select all rows below row 401
3) Right click on the selection
4) Choose Delete first to be sure that all the cells are empty
5) Right click on the selection again and choose Hide
 
Back
Top