Removing unused or blank rows and columns
 

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

Mark, you cannot remove them, but you can hide them, select the rows or
columns and format row or column and hide

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

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

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?