copy / paste format

  • Thread starter Thread starter marco g 3284
  • Start date Start date
M

marco g 3284

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?
 
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
 
Back
Top