Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. -- Adilson Soledade "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste value from a formula | Excel Worksheet Functions | |||
formula or vba to cut and paste | Excel Worksheet Functions | |||
Paste formula every nth row | Excel Discussion (Misc queries) | |||
formula cut and paste | Excel Worksheet Functions | |||
Paste Formula | Excel Discussion (Misc queries) |