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/61639-re-can-i-add-more-columns-excel-past-column-iv.html)

Jamie

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?






All times are GMT +1. The time now is 05:46 AM.

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