Inporting data to cell that exceeds the size of the cell.

[SOSK]

When I import data to the excel-document that exceed the size of the cell, the cell will expand vertical. I want the text to be horizontal. How can I do that? I use text-boxes for import.

When I use the fuction display "full screen" in some of my excel documents, I dont see the full screen. It is problably someting in the setup, but what

Can somebody help please?

 

[Bernie Deitrick]

SOSK,

Prior to the import, set the column width of the cell that will be receiving
the data to be as wide as you want it to be after the import. That will
allow Excel to spread the data out rather than expanding the row vertically.

HTH,
Bernie
MS Excel MVP

When I import data to the excel-document that exceed the size of the cell,

the cell will expand vertical. I want the text to be horizontal. How can I
do that? I use text-boxes for import.

When I use the fuction display "full screen" in some of my excel

documents, I dont see the full screen. It is problably someting in the
setup, but what?