Can't. Each worksheet has exactly 256 columns and 65536 rows. If you
want to hide the unused columns/rows you can. For example, if you're
using A1:J50, enter

K:IV

in the name box (at the left side of the formula toolbar), press Enter
to select the columns, and choose Format/Column/Hide.

Likewise enter

51:65536

in the Name box, press Enter, and choose Format/Rows/Hide.

In article ,
Mark F wrote:

I'm creating a worksheet and want to remove the blank rows and columns that
fall outside the used range. How is this done?