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 |
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 |
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 |
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 |
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 |
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 |
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 -- |
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" 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 |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com