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?
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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
> >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 Format>Hide.
Same for rows.
Gord Dibben Excel MVP
On Tue, 11 Jan 2005 11:45:05 -0800, "Karen" <[email protected]>
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" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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?
>> >
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks