| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. -- 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 |
|
#2
|
|||
|
|||
|
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" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
You can't. Maybe you need to think about switching to Access??
-- Regards, Zack Barresse, aka firefytr "Rick_B" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
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" wrote in message ... You can't. Maybe you need to think about switching to Access?? -- Regards, Zack Barresse, aka firefytr "Rick_B" wrote in message ... 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 |
|
#5
|
|||
|
|||
|
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" wrote in message ... 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" wrote in message ... You can't. Maybe you need to think about switching to Access?? -- Regards, Zack Barresse, aka firefytr "Rick_B" wrote in message ... 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 |
|
#6
|
|||
|
|||
|
LOL :-)
"Zack Barresse" wrote in message ... 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" wrote in message ... 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" wrote in message ... You can't. Maybe you need to think about switching to Access?? -- Regards, Zack Barresse, aka firefytr "Rick_B" wrote in message ... 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 |
|
#7
|
|||
|
|||
|
LOL - Good point :-)
"Max" wrote in message ... 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 -- |
|
#8
|
|||
|
|||
|
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 -- |
|
#9
|
|||
|
|||
|
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns | Excel Discussion (Misc queries) | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
| can't insert columns between columns | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Linear Mode
