ExcelBanter - copy / paste format

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - copy / paste format (https://www.excelbanter.com/excel-worksheet-functions/198606-copy-paste-format.html)

marco g 3284

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?

Gord Dibben

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?

All times are GMT +1. The time now is 04:50 PM.