Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATTING CELLS
I want to just do a formula to have one sheet in a workbook = another. When I just use "=" sign, though, everything comes over in the default text size and font. Is there a way to do this and retain the original font sizes and boldness?
Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATTING CELLS
Did you try Edit, paste special to paste the formats?
Robert Flanagan Add-ins.com LLC http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel On Jun 7, 11:56*am, wrote: I want to just do a formula to have one sheet in a workbook = another. *When I just use "=" sign, though, everything comes over in the default text size and font. *Is there a way to do this and retain the original font sizes and boldness? Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATTING CELLS
On Thursday, June 7, 2012 9:56:33 AM UTC-6, (unknown) wrote:
I want to just do a formula to have one sheet in a workbook = another. When I just use "=" sign, though, everything comes over in the default text size and font. Is there a way to do this and retain the original font sizes and boldness? Steve Yeah, Tried that. It didn't work. It didn;t default to the worksheets font, but it did make everything the same font and boldness of whatever was in the first cell that I copied. Still need some help on this. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATTING CELLS
Formulas can return values only...............they cannot return
formats. You could use Conditional Formatting on source cells to achieve the formatting then use that same CF on the target cells. Gord On Tue, 12 Jun 2012 11:05:55 -0700 (PDT), wrote: On Thursday, June 7, 2012 9:56:33 AM UTC-6, (unknown) wrote: I want to just do a formula to have one sheet in a workbook = another. When I just use "=" sign, though, everything comes over in the default text size and font. Is there a way to do this and retain the original font sizes and boldness? Steve Yeah, Tried that. It didn't work. It didn;t default to the worksheets font, but it did make everything the same font and boldness of whatever was in the first cell that I copied. Still need some help on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tagging formatting (cells with mixed formatting) | Excel Programming | |||
condionally formatting based on another cells formatting? | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
How can I have formatting options like merge cells ,Bold,active for the unlocked cells of the protected worksheet.Is it possible in excel? | Excel Programming | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions |