Excess columns

K

Karen

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?
 
P

Paul B

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
 
K

Karen

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

Gord Dibben

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
 
R

Ron de Bruin

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

Top