Copy and Paste and keep format the same

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to copy and paste selected rows from varios workbooks into one
master workbook. When I copy and paste a range of cells I find the rows
collapse and show only one line of text. How can I copy and paste this
information and automatically show all text in that cell? Some rows have one
or two lines of text, others have up to 12 to 14 lines of text.
 
It sounds like you just have to adjust the cell's formatting for word wrap.

Select your cells
format|cells|Alignment tab|check "wrap text"

These are cells that have multiple lines within the cell--caused by
alt-enters????
 
You must log in or register to reply here.

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

Copy & Paste 2
I can't copy and paste equations 0
Copying and Pasting 10
copy and paste 4
Copy and Past Values AND Formatting AND Text 1
Copy & Paste cell that has alt + enter 2
HELP - A formula or sheet you want to move or copy contains the name .... 0
pasting content copied from nonadajacent cells 1

Back
Top