copy / paste format

's Computer Specifications

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?

's Computer Specifications

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
<(E-Mail Removed)> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Copy, Paste and Format	Vlad999	Microsoft Excel Programming	2	2nd May 2006 05:01 AM
Copy and Paste in certain format	sa02000	Microsoft Excel Worksheet Functions	3	25th Mar 2006 06:04 AM
Lock Cell Format - Allow copy and paste of data without format change	Chris12InKC	Microsoft Excel Worksheet Functions	1	11th Mar 2006 04:44 AM
Copy and Paste and keep format the same	=?Utf-8?B?QnJpYW4gQ2FyYWhlcg==?=	Microsoft Excel Misc	1	17th Mar 2005 02:05 PM
How copy format, font, color and border without copy/paste?	Michel	Microsoft Excel Programming	1	5th Nov 2003 04:43 PM