Excess columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen - 11 Jan 2005 19:45 GMT

I have set up my worksheet, but have a tremendous number of columns left
unused. I have tried to delete them, but they don't go away. How can I get
rid of them?

Reply to this Message

Paul B - 11 Jan 2005 20:07 GMT

Karen, you can not, but you can hide them ,select them and format columns
hide

Signature

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

>I have set up my worksheet, but have a tremendous number of columns left
> unused. I have tried to delete them, but they don't go away. How can I
> get
> rid of them?

Reply to this Message

Karen - 11 Jan 2005 21:11 GMT

Hi Paul, Thanks for the response. I do know how to hide the columns.
Thanks for the help.

> Karen, you can not, but you can hide them ,select them and format columns
> hide
> >I have set up my worksheet, but have a tremendous number of columns left
> > unused. I have tried to delete them, but they don't go away. How can I
> > get
> > rid of them?

Reply to this Message

Ron de Bruin - 11 Jan 2005 22:59 GMT

Hi Karen

Select the first column header to the right of your data.
Then Use "Ctrl-Shift-right Arrow" to select all other columns

Right click on the selection and choose Hide

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Hi Paul, Thanks for the response. I do know how to hide the columns.
> Thanks for the help.
[quoted text clipped - 5 lines]
>> > get
>> > rid of them?

Reply to this Message

Gord Dibben - 11 Jan 2005 21:23 GMT

Karen

Excel has 256 columns and 65536 rows for your use. You cannot get rid of
them.

You can hide them.

Select those columns you don't want to see and Format>Hide.

Same for rows.

Gord Dibben Excel MVP

>I have set up my worksheet, but have a tremendous number of columns left
>unused. I have tried to delete them, but they don't go away. How can I get
>rid of them?

Reply to this Message