Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Wrapping Text
Excel 2007
XP SP3 How do I get a cell to automatically resize itself when you paste text that extends beyond the cell after changing the allignment to "wrap text"? Thanks for reading and your help 8^ |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Wrapping Text
Try paste special - radio button, values, ok
i'm assuming you'd already formatted cell to wrap "WSR" wrote: Excel 2007 XP SP3 How do I get a cell to automatically resize itself when you paste text that extends beyond the cell after changing the allignment to "wrap text"? Thanks for reading and your help 8^ |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Wrapping Text
Hi,
The problem is that you are copying the cell format from the original cell which is wiping out the wrap text formatting in the target cell. By using Paste Special, Values or Formulas, you will not copy the format. -- Thanks, Shane Devenshire "WSR" wrote: Excel 2007 XP SP3 How do I get a cell to automatically resize itself when you paste text that extends beyond the cell after changing the allignment to "wrap text"? Thanks for reading and your help 8^ |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Wrapping Text
Try placing the cursor in the cell where you want the merging to start and
Clicking ALT+ENTER "WSR" wrote: Excel 2007 XP SP3 How do I get a cell to automatically resize itself when you paste text that extends beyond the cell after changing the allignment to "wrap text"? Thanks for reading and your help 8^ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrapping text | Excel Worksheet Functions | |||
text wrapping when text is pasted in excel | Excel Discussion (Misc queries) | |||
I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
Text Wrapping | Excel Worksheet Functions | |||
Wrapping Text | Excel Discussion (Misc queries) |