How to increase the number of columns.

[istancutu]

I need more columns in excel (I now it sounds crazy). If there is no
solution, than how to transform columns in rows?
Please … I’m desperate…………….

 

[Franz Verga]

Nel post *istancutu* ha scritto:

I need more columns in excel (I now it sounds crazy). If there is no
solution, than how to transform columns in rows?
Please . I'm desperate......

Before Excel 2007, that will have 16384 columns, other version of Excel
have "only" 256 columns and there is no way to increase this number.

Maybe you should be better to rethink your project...

If you telll us what are you trying to do, maybe we can suggest you a better
way...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[David Z]

You can try copy pasting the contents of the Excel file into a new one
by choosing Edit -> Paste Special... then choosing the Transpose
checkbox.

 

[bill k]

Have a go at copy, paste, paste special, transpose.
Copy the whole range and edit paste special into a1 on a new sheet.

do a dummy run first.

Bill K
NZ

 

[istancutu]

Thank you! the "transpose" works like a charm ...