Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Cell Size Between Worksheets when performing a copy and paste

When I copy and paste to a new worksheet the formatting of the text comes
across great. However, the size of the cell does not adjust. Is their a way
to automatically copy and paste/adjust the size of the cell with the copy and
paste? These cells contain a soft return (Alt + Enter).

Thanks,
Kara Peterson
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Cell Size Between Worksheets when performing a copy and paste

Go to "Format Cells" Click on "Cell". Go to "Alignment" Tab. Where you
select the cell to be centered - select "Justify"

Hope this helps!

"Kara" wrote:

When I copy and paste to a new worksheet the formatting of the text comes
across great. However, the size of the cell does not adjust. Is their a way
to automatically copy and paste/adjust the size of the cell with the copy and
paste? These cells contain a soft return (Alt + Enter).

Thanks,
Kara Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Excel Worksheet Functions 2 May 9th 23 07:42 PM
how do i copy n paste one cell to another in different worksheets ucastores Excel Worksheet Functions 1 October 3rd 06 01:49 PM
Select cell, Copy it, Paste it, Return to Previous cell spydor Excel Discussion (Misc queries) 1 December 30th 05 01:29 PM
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 15th 05 11:13 PM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 08:58 PM


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"