Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I transpose columns and rows | Excel Discussion (Misc queries) | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
How do you select two cells in different rows and columns with ou. | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Making Rows into Columns | Excel Discussion (Misc queries) |