caop / paste formula

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

Adilson Soledade

If you'll use formulas is not possible to copy the formats from one cell to
another. To have also the formats copied use the Paste Special, option Format.
 

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

copy / paste format 1
How to paste this down? 3
Select Text to End of Footnote 9
Paragraph numbering in Word 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Dealing with a Pivot Table (when I don't want to) 0
Copy addition formula of non-consecutive horizontal cells 2
Paste to excel from word - auto format problem 1

Top