Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel columns do they exceed IV?
Hi there, I am arranging some data on excel for my college course and for
some reason I cannot go further than 'IV' on the columns at the top, is this just the way Excel 2000 is or this there something I can do to amend this? Thanks for reading my question and I look forward to your answers. Many thanks, James 'Disgruntled Student' |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel columns do they exceed IV?
256 columns (up to IV) is as far as you can go pre-2007.
16384 columns in Excel 2007: http://office.microsoft.com/en-gb/ex...ksheetWorkbook -- David Biddulph "James Dalton" <James wrote in message ... Hi there, I am arranging some data on excel for my college course and for some reason I cannot go further than 'IV' on the columns at the top, is this just the way Excel 2000 is or this there something I can do to amend this? Thanks for reading my question and I look forward to your answers. Many thanks, James 'Disgruntled Student' |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel columns do they exceed IV?
Hi James
Versions of XL from 97 up to 2003 all have a maximum of 256 columns, which makes the last column IV. XL 2007 has a limit of 16384 columns, and the last column is XFD -- Regards Roger Govier "James Dalton" <James wrote in message ... Hi there, I am arranging some data on excel for my college course and for some reason I cannot go further than 'IV' on the columns at the top, is this just the way Excel 2000 is or this there something I can do to amend this? Thanks for reading my question and I look forward to your answers. Many thanks, James 'Disgruntled Student' |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel columns do they exceed IV?
James, I meant to add before (hitting the send button), what is it you
are trying to achieve? If you give a description, maybe someone will be able to suggest alternative ways of achieving your result. -- Regards Roger Govier "James Dalton" <James wrote in message ... Hi there, I am arranging some data on excel for my college course and for some reason I cannot go further than 'IV' on the columns at the top, is this just the way Excel 2000 is or this there something I can do to amend this? Thanks for reading my question and I look forward to your answers. Many thanks, James 'Disgruntled Student' |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel columns do they exceed IV?
Sun, 10 Jun 2007 03:33:00 -0700 from <?B?SmFtZXMgRGFsdG9u?=
<James : Hi there, I am arranging some data on excel for my college course and for some reason I cannot go further than 'IV' on the columns at the top, is this just the way Excel 2000 is or this there something I can do to amend this? Yes, it's how Excels up through 2003 are. If you can't rearrange things, and you don't want to use an additional worksheet, you can buy Excel 2007 and get much larger worksheets. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel columns do they exceed IV?
To go along with Roger's 2nd post - knowing how you're trying to get
information into the worksheet(s) would be helpful, and knowing your goal. If you are importing from an ASCII text file that could be considered as a ..csv type (fields separated by comma, semi-colon, pipe or tab) then this Excel file might help you - it enables you to import such files that have more than 256 columns into pre-2007 versions of Excel (still limited to that version's sheet row limit). http://www.jlathamsite.com/uploads/I...umnsOfData.xls "James Dalton" wrote: Hi there, I am arranging some data on excel for my college course and for some reason I cannot go further than 'IV' on the columns at the top, is this just the way Excel 2000 is or this there something I can do to amend this? Thanks for reading my question and I look forward to your answers. Many thanks, James 'Disgruntled Student' |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel columns do they exceed IV?
Hi there Roger,
Thanks for your speedy reply (and all others that have also helped). Basically I am doing a construction programme of a hotel. My home PC does not have MS Projects so I thought I could use Excel, so I guess the easiest thing for me to do would be to just expand onto another worksheet. Thanks again to all that have replied. James. "Roger Govier" wrote: James, I meant to add before (hitting the send button), what is it you are trying to achieve? If you give a description, maybe someone will be able to suggest alternative ways of achieving your result. -- Regards Roger Govier "James Dalton" <James wrote in message ... Hi there, I am arranging some data on excel for my college course and for some reason I cannot go further than 'IV' on the columns at the top, is this just the way Excel 2000 is or this there something I can do to amend this? Thanks for reading my question and I look forward to your answers. Many thanks, James 'Disgruntled Student' |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exceed Scale | Charts and Charting in Excel | |||
Footer exceed max characters | Excel Worksheet Functions | |||
how do I ensure that the sum of two cells does not exceed a set fi | Excel Worksheet Functions | |||
exceed maximum rows | Excel Discussion (Misc queries) | |||
determining slopes that exceed x | Excel Discussion (Misc queries) |