 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Need to expand past column IV
Hi, Were using Excel 2003 and ran into the end of colums at IV. Besides upgrading to Office 2007 is there way to extend or add-in more columns. Thanks, BobV Bob, No, but using all 256 columns is often a sign that you should use database data style entry - instead of having a column for each of the ?days(?) enter the column property as a field, with each entry in a separate row. Beyond that, it is hard to be more specific since your question is vague. HTH, Bernie MS Excel MVP > Hi, > Were using Excel 2003 and ran into the end of colums at IV. Besides > upgrading to Office 2007 is there way to extend or add-in more columns. > > Thanks, > BobV Bernie, I have a 2003 spreadsheet. My first column is A1....My last available column is IV1. Is there a way to add more columns in 2003? BobV > Bob, > [quoted text clipped - 12 lines] > > Thanks, > > BobV No. Versions of Excel prior to Excel 2007 have a limitation of 256 columns. There is no way to expand that. Tyro > Bernie, > I have a 2003 spreadsheet. My first column is A1....My last available [quoted text clipped - 3 lines] > > BobV <There is no way to expand that.> Not in the same sheet, that is. You can of course use a second sheet. But it will be difficult to keep the rows together correctly.  SignatureKind regards, Niek Otten Microsoft MVP - Excel | No. Versions of Excel prior to Excel 2007 have a limitation of 256 columns. | There is no way to expand that. [quoted text clipped - 8 lines] | > | > BobV I wouldn't even contemplate that. Tyro > <There is no way to expand that.> > [quoted text clipped - 15 lines] > | > > | > BobV What part of Bernie's "No" did you miss? Gord Dibben MS Excel MVP >Bernie, >I have a 2003 spreadsheet. My first column is A1....My last available column [quoted text clipped - 19 lines] >> > Thanks, >> > BobV > Bernie, > I have a 2003 spreadsheet. My first column is A1....My last available column > is IV1. > Is there a way to add more columns in 2003? > > BobV Those are full cell addresses. Your first column is A. Your last column is IV. The 1 is the row number. The answer is No. Change to Quattro Pro or Excel 2007 or perhaps use a database program instead. What kind of a spreadsheet really needs 256 columns? Bill >> Bernie, >> I have a 2003 spreadsheet. My first column is A1....My last available [quoted text clipped - 7 lines] >database program instead. What kind of a spreadsheet really needs 256 >columns? Some of mine would benefit from more than that - but from what I've heard Excel 2007 is a PITA. SignaturePaul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.