Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I add more columns in Excel past column IV
Well, that sucks!! I need to add more rows!
Ok, Access it is then. I am not too familiar with Access, so this will be a good experience for me. "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 | |||
Can I add more columns in Excel past column IV | Excel Discussion (Misc queries) | |||
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 |