 |
 | 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 / General Excel Questions / March 2008I need more columns
How do i increase the number of columns in a worksheet? there only seems to be 150 - 200 or so and i could do with around 400. I've tried "insert" - "column" but the amount of columns available doesnt increase! In Excel versions prior to 2007 you were limited to 256 columns (column IV), and there is no way you can increase this. Excel 2007 has over 18,000 of them, so you might consider upgrading to that version. Alternatively, you can split your data into two sheets, and use 200 columns in each. Hope this helps. Pete On Mar 25, 5:09 pm, jackrobyn1 <jackrob...@discussions.microsoft.com> wrote: > How do i increase the number of columns in a worksheet? there only seems to > be 150 - 200 or so and i could do with around 400. I've tried "insert" - > "column" but the amount of columns available doesnt increase! hi i am assuming that you do not have xl2007. prior to xl2007 the maximum number of columns available was 256. no way to increase that. (or decrease) 2007 has 16384 columns so i can only recommend that you looking into xl2007. it may be your only solution to this problem. Regards FSt1 > How do i increase the number of columns in a worksheet? there only seems to > be 150 - 200 or so and i could do with around 400. I've tried "insert" - > "column" but the amount of columns available doesnt increase! If you can easilt upgrade to 2007, have you tried flipping the data, so the columns become the rows and the rows become columns? > How do i increase the number of columns in a worksheet? there only seems to > be 150 - 200 or so and i could do with around 400. I've tried "insert" - > "column" but the amount of columns available doesnt increase! |
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.