Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a linked cell
The problem I have is I have many worksheets that are linked to one data
worksheet, if the information that is typed into the data sheet exceeds the space I have allowed per line on the linked sheet then I don't see all the data in the cell in the linked sheet , unless I click on the cell and format it and click "wrap" I have set all the mapped cells to "Wrap" but it does not make any difference. I still have to click on the cell and click wrap off and then on again...then it works. Can this be set to wrap automatically ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a linked cell
If you change the data on the data sheet, that does not automatically re-wrap
the destination. This little macro will examine every cell in your worksheet and if the format is wrap, the cell is re-wrapped: Sub re_wrap() For Each r In ActiveSheet.UsedRange If r.WrapText = True Then r.WrapText = False r.WrapText = True End If Next End Sub -- Gary's Student "richard" wrote: The problem I have is I have many worksheets that are linked to one data worksheet, if the information that is typed into the data sheet exceeds the space I have allowed per line on the linked sheet then I don't see all the data in the cell in the linked sheet , unless I click on the cell and format it and click "wrap" I have set all the mapped cells to "Wrap" but it does not make any difference. I still have to click on the cell and click wrap off and then on again...then it works. Can this be set to wrap automatically ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a linked cell
Thank-you for your help.
"Gary''s Student" wrote: If you change the data on the data sheet, that does not automatically re-wrap the destination. This little macro will examine every cell in your worksheet and if the format is wrap, the cell is re-wrapped: Sub re_wrap() For Each r In ActiveSheet.UsedRange If r.WrapText = True Then r.WrapText = False r.WrapText = True End If Next End Sub -- Gary's Student "richard" wrote: The problem I have is I have many worksheets that are linked to one data worksheet, if the information that is typed into the data sheet exceeds the space I have allowed per line on the linked sheet then I don't see all the data in the cell in the linked sheet , unless I click on the cell and format it and click "wrap" I have set all the mapped cells to "Wrap" but it does not make any difference. I still have to click on the cell and click wrap off and then on again...then it works. Can this be set to wrap automatically ? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a linked cell
You are very welcome.
-- Gary's Student "richard" wrote: Thank-you for your help. "Gary''s Student" wrote: If you change the data on the data sheet, that does not automatically re-wrap the destination. This little macro will examine every cell in your worksheet and if the format is wrap, the cell is re-wrapped: Sub re_wrap() For Each r In ActiveSheet.UsedRange If r.WrapText = True Then r.WrapText = False r.WrapText = True End If Next End Sub -- Gary's Student "richard" wrote: The problem I have is I have many worksheets that are linked to one data worksheet, if the information that is typed into the data sheet exceeds the space I have allowed per line on the linked sheet then I don't see all the data in the cell in the linked sheet , unless I click on the cell and format it and click "wrap" I have set all the mapped cells to "Wrap" but it does not make any difference. I still have to click on the cell and click wrap off and then on again...then it works. Can this be set to wrap automatically ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Format of a cell | Excel Discussion (Misc queries) | |||
preserving cell format between linked documents | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |