copy / paste format

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

caop / paste formula 1
How to paste this down? 3
Paste to excel from word - auto format problem 1
Dealing with a Pivot Table (when I don't want to) 0
Select Text to End of Footnote 9
Paragraph numbering in Word 1
Need Help with a VBA subroutine 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0

Top