Removing unused or blank rows and columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Having Blank Cells, etc. ? 1
Row height setting problem 8
counting blank cells within two columns 2
Hide Column If Usedrange of Column ISBLANK Follow-up 1
Display index of column headers in column A 9
Allowing row deletion in worksheet with locked cells 2
Deleting/removing unused rows in a worksheet 3

Back
Top