Is There a Formula that copies another cell exactly in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm Creating an excell spreadsheet with many worksheets. I need to find a
formula that allows me to only change the cell in the first worksheet so that
all of the rest will change and look the same. I've tried just using the =
(equal sign), but the problem is that the cell I want to copy has two formats
in it, a part that is bold and a part that isn't. When I use = it just makes
the cell either all bold or all not. Any help would be great.
Thanks
 
Can you give more information on what part needs to be bold and what part
doesn't. (i.e. a certain number of characters, after a key word, etc.) Is
their other formatting other than bold/not bold?

-Chris
 
Formatting cannot be transferred via a linked cell formula.


Gord Dibben MS Excel MVP

 
I Have two lines, one on top of the other. The first line is bold the second
isn't. Like this:

CF-43 Envelope, Booklet, Grey (all of that being bold)
9-1/2 x 12-1/2 First Class (and all of this not)

-Ron
 
Back
Top