Adding Columns

[tco9998]

Good afternoon.

I would like to ask how to add collumns to excel 2007. I would to compare data and i need more colummns.

Thnanks.

[xladept]

Hi tco9998,

Highlight the column that you want to insert before - right click and choose insert.

[ben_hensel]

How to insert blank cells, rows, or columns.

Well, that's pretty basic; do you need them created automatically or as part of another input? That would require a macro. (Which is pretty advanced).

[tco9998]

I have 400 rows and i would like to do 400 columns. And my excel sheet stops to column name "IV", not allowing to add more columns to the end. How to add more columns in order to transform 400 rows to 400 columns?

[tco9998]

Please help me......

[xladept]

Hi tco9998,

Excel 2007 is supposed to have 16384 columns are you exceeding that limit?

Excel 2000 and 2003 have only 256 columns and we can't help you there!

Or are your columns hidden?

[tco9998]

Thanks a lot.

[xladept]

OK - You're welcome