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

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
 
G

Guest

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
 
G

Gord Dibben

Formatting cannot be transferred via a linked cell formula.


Gord Dibben MS Excel MVP

 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top