Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy / paste format
i'm trying to copy a cell (both text and format) from one tab to another tab
within the same document but keep getting just the text. is there a formula aside from '=Sheet1!' that will work for it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy / paste format
No
Formulas cannot copy formatting. If the formatting on source sheet is from Conditional Formatting, you could CF the target cell the same. Or use two steps.............copy values then copy formats. Gord Dibben MS Excel MVP On Tue, 12 Aug 2008 10:35:01 -0700, marco g 3284 wrote: i'm trying to copy a cell (both text and format) from one tab to another tab within the same document but keep getting just the text. is there a formula aside from '=Sheet1!' that will work for it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
copy paste format problem | New Users to Excel | |||
Copy and Paste in certain format | Excel Worksheet Functions | |||
format changes after copy/paste | Excel Discussion (Misc queries) | |||
Copy and Paste and keep format the same | Excel Discussion (Misc queries) |