|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 7th 12, 04:56 PM
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 
|
| Ads |
|
#2
June 7th 12, 05:41 PM
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
June 12th 12, 07:05 PM
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
June 12th 12, 11:54 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Tagging formatting (cells with mixed formatting) | Fred Goldman | Excel Programming | 0 | April 25th 10 03:44 PM |
| condionally formatting based on another cells formatting? | Derrick | Excel Discussion (Misc queries) | 2 | July 31st 09 08:05 PM |
| Formatting cells in a column with conditional formatting? | shamor | Excel Discussion (Misc queries) | 8 | May 19th 08 10:11 PM |
| How can I have formatting options like merge cells ,Bold,active for the unlocked cells of the protected worksheet.Is it possible in excel? | divya | Excel Programming | 2 | July 20th 06 02:04 PM |
| Conditional Formatting Multiple cells based on 2 cells | Louis Markowski | Excel Worksheet Functions | 2 | June 1st 05 05:26 PM |
Linear Mode
