Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For example, cell A1 contains the text "Hello World" which is in bold.

In cell A2, I use the formula =A1. Therefore cell A2 now also contains "Hello World", but it is not in bold. How can I modify the formula to also copy the formatting (in this case, bold) of A1?

A more complex example is strikethrough properties, i.e. A1 contains "Orange/Red". How do I show the same content in cell A2 dynamically, so that any changes made in A1 will update A2 as well?

share|improve this question
Is with VBA an option for you? – pnuts Oct 17 '12 at 10:38
Has to be an option, I don't know anyway to solve this just with formulars, so without VBA or some other Magic, this won't work. There might be some way to use conditional formatting for this, but this will have quite some restirctions to it. – Jook Oct 17 '12 at 11:21

Using only formulas and no custom add-ons nor VBA: you can't. At least not with Excel up to 2007 (and quite probably all later versions as well)

First of all, there is no built-in formula that catches any form of formating.

Second, formulas only display their values. They don't influence formatting unless you use Conditional Formatting. But even if you do, there is no easy option to "copy formatting from the other cell". Besides, conditional formatting is limited in what it can format compared with "manual mouse clicking".

share|improve this answer
so is there any alternative? – Alvin Lim Oct 19 '12 at 9:03
Yes. As I've written: VBA or custom add-ons. – Adam Ryczkowski Oct 19 '12 at 13:39
I think it could be argued that "there is no built-in formula that catches any form of formating" is not precisely correct see - but, I'd accept, at least a fair approximation! – pnuts Apr 3 '13 at 17:14
@pnuts Yes. A good remark. I didn't think about it! – Adam Ryczkowski Apr 4 '13 at 8:55

Copy the cell then hit Alt-E-S-A-Enter Alt-E-S this opens up the paste special then A copies all properties

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.