Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Averaging columns | New Users to Excel | |||
interchange columns with rows | Excel Discussion (Misc queries) |