Excess columns
 

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?

Karen, you can not, but you can hide them ,select them and format columns
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

"Karen" wrote in message
...
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?

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

"Paul B" wrote:

Karen, you can not, but you can hide them ,select them and format columns
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

"Karen" wrote in message
...
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?

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

Same for rows.


Gord Dibben Excel MVP

On Tue, 11 Jan 2005 11:45:05 -0800, "Karen"
wrote:

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?

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


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



"Karen" wrote in message ...
Hi Paul, Thanks for the response. I do know how to hide the columns.
Thanks for the help.

"Paul B" wrote:

Karen, you can not, but you can hide them ,select them and format columns
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

"Karen" wrote in message
...
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?