formatting a worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stevenb - 02 Sep 2004 16:15 GMT

Thanks for taking the time to look at my question.

I am drawing a blank.... I cannot remember how to control the numbe
of columns in a worksheet. I have a little app that I have pu
together, and it only takes up about 15 columns. I would like to mak
the total number of columns for the worksheet 17 columns, but just can
remember how to do it....

thanks in advance!:

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Frank Kabel - 02 Sep 2004 16:39 GMT

Hi
you can't :-) The only thing you can do is hide the other columns
(Format - Columns - Hide)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Thanks for taking the time to look at my question.
>
> I am drawing a blank.... I cannot remember how to control the number
> of columns in a worksheet. I have a little app that I have put
> together, and it only takes up about 15 columns. I would like to

make

> the total number of columns for the worksheet 17 columns, but just

cant

> remember how to do it....
>
> thanks in advance!:)
>
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

Paul B - 02 Sep 2004 16:45 GMT

Stevenb, you could select a cell in column R, hold ctrl+shift and right
arrow to select all the columns then format column hide

Signature

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 2000 & 2003
** remove news from my email address to reply by email **

> Thanks for taking the time to look at my question.
>
[quoted text clipped - 8 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message