Any way to remove wayward columns?

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
 
G

Gord Dibben

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
 
D

DC

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

Colin Higbie

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
 
Top