Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Karen
 
Posts: n/a
Default 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   Report Post  
Paul B
 
Posts: n/a
Default

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   Report Post  
Karen
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 09:13 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 07:37 PM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 09:13 PM
Averaging columns rhodesv New Users to Excel 1 December 16th 04 09:14 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 06:40 PM


All times are GMT +1. The time now is 02:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"