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

On Fri, 17 Dec 2004 17:39:20 -0500, "Colin Higbie"
<(E-Mail Removed)> wrote:

>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 Higbie" <(E-Mail Removed)> wrote in message
> Is there any way to remove the extra columns so Excel doesn't think the
> worksheet has hundreds and hundreds of columns?

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.


--
Disclaimer: This post is solely an individual opinion and does not speak on
behalf of any organization.

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


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news(E-Mail Removed)...
> 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
>
> On Fri, 17 Dec 2004 17:39:20 -0500, "Colin Higbie"
> <(E-Mail Removed)> wrote:
>
>>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
>>
>