I'm trying to create a template and I need a few cells to be wrapped texted. When I paste text into those cells it some how changes back to no wrapped text. Is there a way to keep (lock) the cell so it is always wrapped text?
if you have users that are going to copy/paste into the template, the only way I can think of to ensure that a certain range of cells are wrapped text is to force it with VBA. Try putting the following code in the worksheet (right-mouse click on the worksheet tab and choose View Code. Then paste the code below into the blank white space)
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A2:C10")) Is Nothing Then
Target.WrapText = True