Paste a large text into a cell

G

Guest

I am pastng a large text (should take more that one line in a cell) into a cell that is designed as a Wrap text, Vertical allignment - Top. But text gets on a bottom of the cell and it's not wraped. If I check properties of that cell it's not wraped and Allignment is set to bottom
Why is that?
 
K

kkknie

If you are pasting from another cell in excel, you will get that cell
formatting. Choose Paste Special | Values to get only the value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format from empty cell below 1
How do I put my text at the top of the cell instead of the bottom? 1
Is there a settings startup file for Excel? 5
Text Running Out of Cell 1
Wraping text to next line 2
Wrapping Text 3
Text displays as #### 1
TEXT BOX (ACTIVEX CONTROLS) 2

Top