ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I add more columns in Excel past column IV (https://www.excelbanter.com/excel-discussion-misc-queries/84739-re-can-i-add-more-columns-excel-past-column-iv.html)

Aaron Oxford

Can I add more columns in Excel past column IV
 
Yes, and 640K of memory is enough for anyone.

This is a prime example of when MS refuses to do actual work on their
software to make it useful to users.

"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?






All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com