Removing unused or blank rows and columns

M

Mark F

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

Paul B

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
 
J

JE McGimpsey

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.
 
Top