Reflecting the exact layout of linked cells in excel spreadsheet?
I have set up a spreadsheet for 6 marketing campaigns with an individual worksheet for each campaign. The individual worksheets are calibrated by weeks i.e Week 12 of Campaign, Week 11 of campaign and so on. Next to each week is the action that needs to be taken. If there are multiple actions for a week, I have used alt and enter to put the different actions on to the next line, but in the same cell i.e
campaign commences
email designed
leaflet designed
On the same spreadsheet I have also set up a worksheet linking to the individual campaign tabs which then gives me a week by week summary of for all the campaigns.
However, when I link the cells from the individual tabs into the summary tab the mulitple lines per cell are not reflected and all the information from the cell is listed together in one long line i.e
campaign commencesemail designedleaflet designed
Is there a way that I can link the cells and keep the formatting of the original cell so that the linked cell reflects the original? i.e
campaign commences
email designed
leaflet designed
i think all you need to do is make sure your destination cell has “wrap text” checkmarked
or heres the steps:
- right click on the summary tab with the 1 long line
- click format cells…
- click alignment
- put a checkmark next to Wrap text
- hit ok,
you might have to resize your cell, but that should just work. you might want pre-set the text column with the wrap text format checked. no formula is going to do that…you would need vba that checks for chr(10) and changes the formatting.
if that doesnt work,
- assume your “campaign commences email designed leaflet designed” is in cell A1
- then use this quick formula
=len(a1)
and it should show 50 instead of 48…those 2 extra characters are your alt-enters (char(10))…and if the len(a1) formula shows 50, then the layout is the same.