| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I add more columns in Excel past column IV
Yes, I would definitely like to see 366 Columns.
"Gord Dibben" wrote: Paul Why? Most people would like to see 366 so's they could have one for each day in the year. Sometimes you have just too many rows to transpose. Gord Dibben Excel MVP On Wed, 13 Oct 2004 15:56:59 +0100, "Paulw2k" wrote: Hi My immediate thought is why? Why do you need to use so many columns? The number of columns - 256, is fixed, and for most purposes that is more than sufficient. Are you using the sheet as a database? Better to use a proper database such as Access. Is it a database download? Split the download, with a common field in each sheet. Use summarising table, consoldation tables, pivot-tables... to analyse the data. If the table is using dates in the first row, transpose the table and work row-wise. Regards Paul "Confucious" wrote in message ... I need to extend an excel spreadsheet past the last available column. There seem to be loads of rows in an excel sheet but the number of columns is quite limiting for what I need. I presume the number of columns is limited for memory reasons but I can lose some rows if that helps. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| print 3 column range in six columns | Excel Discussion (Misc queries) | |||
| in excel just want to add 4 columns and total in next column | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Linear Mode
