Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can A Spreadsheet Get Any Wider?
I realize this may be an elementary question to most, but I hope there's a fix. I'm making a spreadsheet that requires about 10 more columns (beyond column number 256 --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=393453 |
#2
|
|||
|
|||
Good evening Rick B Unfortunately not. Excel is limited to 256 columns and there are no workarounds or hacks to avoid this as it is hard coded into the program. It is a fairly big limitation and the source of constant gripes from users but Microsoft have just seen fit to ignore it so far. If you want to use Quatro Pro, that utilises 18,278 columns, as does the spreadsheet in the Microsoft Office Web Compenents - but you do lose a lot of functionality. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=393453 |
#3
|
|||
|
|||
Thanks DominicB. That stinks, though. -- Rick_B ------------------------------------------------------------------------ Rick_B's Profile: http://www.excelforum.com/member.php...fo&userid=5964 View this thread: http://www.excelforum.com/showthread...hreadid=393453 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) | |||
Importing Data From Another Spreadsheet | Excel Discussion (Misc queries) |