Excess columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Paul, Thanks for the response. I do know how to hide the columns.
Thanks for the help.
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top