| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cell format?
I have two worksheets. One I use to insert data, the other to summarize the data I entered. On the data sheet, I have a few items that are bold/red. I'm using ='data'!b2 to copy the cell contents from the data sheet into the summary sheet, it copies the content, but not the format (bold/red). How can I correct this? JF -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=498038 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy cell format?
Formulas can only return values--not formats.
I think copy|paste special|formats either manually or via a macro is the way to go. (If you need a macro, record one when you do it manually.) Ltat42a wrote: I have two worksheets. One I use to insert data, the other to summarize the data I entered. On the data sheet, I have a few items that are bold/red. I'm using ='data'!b2 to copy the cell contents from the data sheet into the summary sheet, it copies the content, but not the format (bold/red). How can I correct this? JF -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=498038 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| AUTOMATIC way to copy the value of a cell in one spreadsheet | Excel Worksheet Functions | |||
| copy a formatted cell to another sheet as text without format | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
