Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 26th 06, 08:52 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
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  
Old October 27th 06, 04:08 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
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
how do i copy n paste one cell to another in different worksheets ucastores Excel Worksheet Functions 1 October 3rd 06 01:49 PM
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Excel Worksheet Functions 1 March 11th 06 05:44 AM
Select cell, Copy it, Paste it, Return to Previous cell spydor Excel Discussion (Misc queries) 1 December 30th 05 02:29 PM
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 16th 05 12:13 AM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 09:58 PM


All times are GMT +1. The time now is 04:11 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017