Can I add more columns beyond col. IV?
I realize this may be a elementary question to most, but I hope there's a fix.
I'm making a spreadsheet that requires about 10 more columns (beyond column IV) than the normal new Excel file allows (to the would-be column JE). Is there any way for me to extend the sheet and add more columns?
Thanks.
No, you are limited to 256 columns
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"Rick_B" <[email protected]> wrote in
message news:[email protected]...
>
> I realize this may be a elementary question to most, but I hope there's
> a fix.
>
> I'm making a spreadsheet that requires about 10 more columns (beyond
> column IV) than the normal new Excel file allows (to the would-be
> column JE). Is there any way for me to extend the sheet and add more
> columns?
>
> Thanks.
>
>
> --
> Rick_B
> ------------------------------------------------------------------------
> Rick_B's Profile:
> http://www.excelforum.com/member.php...fo&userid=5964
> View this thread: http://www.excelforum.com/showthread...hreadid=393438
>
You can't. Maybe you need to think about switching to Access??
--
Regards,
Zack Barresse, aka firefytr
"Rick_B" <[email protected]> wrote in
message news:[email protected]...
>
> I realize this may be a elementary question to most, but I hope there's
> a fix.
>
> I'm making a spreadsheet that requires about 10 more columns (beyond
> column IV) than the normal new Excel file allows (to the would-be
> column JE). Is there any way for me to extend the sheet and add more
> columns?
>
> Thanks.
>
>
> --
> Rick_B
> ------------------------------------------------------------------------
> Rick_B's Profile:
> http://www.excelforum.com/member.php...fo&userid=5964
> View this thread: http://www.excelforum.com/showthread...hreadid=393438
>
> You can't. Maybe you need to think about switching to Access??
Why, that has even less with only 255 :-)
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"Zack Barresse" <[email protected]> wrote in message
news:%[email protected]...
> You can't. Maybe you need to think about switching to Access??
>
>
> --
> Regards,
> Zack Barresse, aka firefytr
>
>
> "Rick_B" <[email protected]> wrote in
> message news:[email protected]...
>>
>> I realize this may be a elementary question to most, but I hope there's
>> a fix.
>>
>> I'm making a spreadsheet that requires about 10 more columns (beyond
>> column IV) than the normal new Excel file allows (to the would-be
>> column JE). Is there any way for me to extend the sheet and add more
>> columns?
>>
>> Thanks.
>>
>>
>> --
>> Rick_B
>> ------------------------------------------------------------------------
>> Rick_B's Profile:
>> http://www.excelforum.com/member.php...fo&userid=5964
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=393438
>>
>
>
Hmm, was thinking rows I guess .. LOL!
That's what I get for having the screen too far from my eyes .. <sg>
--
Regards,
Zack Barresse, aka firefytr
"Ken Wright" <[email protected]> wrote in message
news:%[email protected]...
>> You can't. Maybe you need to think about switching to Access??
>
> Why, that has even less with only 255 :-)
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------*------------------------------*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------*------------------------------*----------------
>
>
> "Zack Barresse" <[email protected]> wrote in message
> news:%[email protected]...
>> You can't. Maybe you need to think about switching to Access??
>>
>>
>> --
>> Regards,
>> Zack Barresse, aka firefytr
>>
>>
>> "Rick_B" <[email protected]> wrote in
>> message news:[email protected]...
>>>
>>> I realize this may be a elementary question to most, but I hope there's
>>> a fix.
>>>
>>> I'm making a spreadsheet that requires about 10 more columns (beyond
>>> column IV) than the normal new Excel file allows (to the would-be
>>> column JE). Is there any way for me to extend the sheet and add more
>>> columns?
>>>
>>> Thanks.
>>>
>>>
>>> --
>>> Rick_B
>>> ------------------------------------------------------------------------
>>> Rick_B's Profile:
>>> http://www.excelforum.com/member.php...fo&userid=5964
>>> View this thread:
>>> http://www.excelforum.com/showthread...hreadid=393438
>>>
>>
>>
>
>
LOL :-)
"Zack Barresse" <[email protected]> wrote in message
news:[email protected]...
> Hmm, was thinking rows I guess .. LOL!
>
> That's what I get for having the screen too far from my eyes .. <sg>
>
> --
> Regards,
> Zack Barresse, aka firefytr
>
>
> "Ken Wright" <[email protected]> wrote in message
> news:%[email protected]...
>>> You can't. Maybe you need to think about switching to Access??
>>
>> Why, that has even less with only 255 :-)
>>
>> --
>> Regards
>> Ken....................... Microsoft MVP - Excel
>> Sys Spec - Win XP Pro / XL 97/00/02/03
>>
>> ------------------------------*------------------------------*----------------
>> It's easier to beg forgiveness than ask permission :-)
>> ------------------------------*------------------------------*----------------
>>
>>
>> "Zack Barresse" <[email protected]> wrote in message
>> news:%[email protected]...
>>> You can't. Maybe you need to think about switching to Access??
>>>
>>>
>>> --
>>> Regards,
>>> Zack Barresse, aka firefytr
>>>
>>>
>>> "Rick_B" <[email protected]> wrote in
>>> message news:[email protected]...
>>>>
>>>> I realize this may be a elementary question to most, but I hope there's
>>>> a fix.
>>>>
>>>> I'm making a spreadsheet that requires about 10 more columns (beyond
>>>> column IV) than the normal new Excel file allows (to the would-be
>>>> column JE). Is there any way for me to extend the sheet and add more
>>>> columns?
>>>>
>>>> Thanks.
>>>>
>>>>
>>>> --
>>>> Rick_B
>>>> ------------------------------------------------------------------------
>>>> Rick_B's Profile:
>>>> http://www.excelforum.com/member.php...fo&userid=5964
>>>> View this thread:
>>>> http://www.excelforum.com/showthread...hreadid=393438
>>>>
>>>
>>>
>>
>>
>
>
Just a thought .. since Ken didn't talk about this <g>
If the number of rows are all and always <= 256,
maybe transposing the sheet layout would be an option ?
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
You might consider Quattro Pro. It doesn't have a 256 column limit.
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"Rick_B" <[email protected]> wrote in
message news:[email protected]...
>
> I realize this may be a elementary question to most, but I hope there's
> a fix.
>
> I'm making a spreadsheet that requires about 10 more columns (beyond
> column IV) than the normal new Excel file allows (to the would-be
> column JE). Is there any way for me to extend the sheet and add more
> columns?
>
> Thanks.
>
>
> --
> Rick_B
> ------------------------------------------------------------------------
> Rick_B's Profile:
http://www.excelforum.com/member.php...fo&userid=5964
> View this thread: http://www.excelforum.com/showthread...hreadid=393438
>
LOL - Good point :-)
"Max" <[email protected]> wrote in message
news:OO%[email protected]...
> Just a thought .. since Ken didn't talk about this <g>
>
> If the number of rows are all and always <= 256,
> maybe transposing the sheet layout would be an option ?
>
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks