Any way to remove wayward columns?

  • Thread starter Thread starter Colin Higbie
  • Start date Start date
C

Colin Higbie

I'm not sure why, but for some reason on 1 page in one of my workbooks, the
columns go all the way out to IV. On that sheet, I'm only actually using
columns out to J. I'm running Excel 2003.

Is there any way to remove the extra columns so Excel doesn't think the
worksheet has hundreds and hundreds of columns?

Thanks,
Colin
 
Colin

Not sure what your probem is:

Excel has 256 columns and 65536 rows.

You cannot delete these.

You can hide unused cols and rows.

On the other hand, if your problem is that Excel thinks your used range
extends to column IV when you hit CRTL + END then you can reset the range by
selecting all unused columns and Edit>Delete then SAVE and Close the workbook.

Re-open to see new used range.

Note: it seems contradictory for me to say "you cannot delete these" and then
tell you to Edit>Delete.

What you're doing is deleting any extraneous usage of those columns.

Gord Dibben Excel MVP
 
Colin Higbie said:
Is there any way to remove the extra columns so Excel doesn't think the
worksheet has hundreds and hundreds of columns?
Click to expand...

sure, highlight all the columns past J, right click Delete, and re-save the
document. Now press CTRL+End to verify that the last column is J.
 
Yeah, you and DC were correct. I had tried exactly that before I posted and
it appeared not to help. But when I saved it and re-opened the document (as
both of you instructed), the extra columns were indeed gone.

Thanks,
Colin
 
Back
Top