Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is There a Formula that copies another cell exactly in Excel?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is There a Formula that copies another cell exactly in Excel?
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 "Dhbomb2k1" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is There a Formula that copies another cell exactly in Excel?
Formatting cannot be transferred via a linked cell formula.
Gord Dibben MS Excel MVP On Thu, 6 Jul 2006 11:01:02 -0700, CWillis wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is There a Formula that copies another cell exactly in Excel?
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 "CWillis" wrote: 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 "Dhbomb2k1" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |