We help IT Professionals succeed at work.

How can I get the formatting of a field in one worksheet to transfer to subsequent worksheets within a work book.

Joe Brown
Joe Brown asked
on
58 Views
Last Modified: 2016-08-16
I have a field containing text in my first worksheet and it contains some formatting. (e.g. the 3rd word of the sentence is bold, underlined and is in blue and the rest of the text is normal).

In my subsequent worksheets I have referenced this field by way of a formula:  =Distributor!A22
However, the formatting of the referenced field is not coming across to the other worksheets.

Does anyone know how to write the formula so that it will present the field exactly as it is shown on the the referenced worksheet?

Thank you in advance!
Comment
Watch Question

CERTIFIED EXPERT

Commented:
You can't link formatting between cells, with a formula or otherwise. You also can't format the result of a formula as you require - that's only possible with constant values.
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
If the contents of the source cell aren't going to change then copy and paste the formatting to the subsequent sheets.

You can group the sheets and do the paste into all sheets in one go:

Copy the first cell, select the second sheet and select the cell where required and then press Shift and Select the last tab where required. Then Paste Special - Formats.

If the sheets requiring the format are not one after the other, use Ctrl + click to select each tab rather than Shift + click on first and last.

Then select the first sheet to ungroup the sheets.
IT Manager
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
Yes, Camera tool would be an option.

The only downside that I could see with that is if the source cell changes size rather than any other formatting. The size of the image changes in line with the source cell but it does change the size of the cell where the image is overlaid.

Thanks
Rob
Joe BrownIT Manager

Author

Commented:
Yes, this is true. In my case, the size will not change, only some of the wording in the cell. So this works slick for my purpose.
Joe BrownIT Manager

Author

Commented:
Found solution that works

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions