Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subscript
When copying a cell with mixed format
i.e. H2O with the 2 in subscript is in cell A1, If another cell contains =A1 the subscript format on the 2 is lost and H2O is displayed. Is there anyway other than copy and paste to retaing the formatting? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
subscript
The short answer is no. You have to copy the cell. Formulas return values.
They do not return formats. -- HTH... Jim Thomlinson "Bender" wrote: When copying a cell with mixed format i.e. H2O with the 2 in subscript is in cell A1, If another cell contains =A1 the subscript format on the 2 is lost and H2O is displayed. Is there anyway other than copy and paste to retaing the formatting? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
subscript
You could copy the formatted cell as a *picture*, therefore displaying it
with it's formats. Select the formatted cell, and from the Menu Bar, Hold <Shift and click on EDIT. This gives you a slightly different drop down window. Click on "Copy Picture", then <OK, then paste anywhere. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Bender" wrote in message ... When copying a cell with mixed format i.e. H2O with the 2 in subscript is in cell A1, If another cell contains =A1 the subscript format on the 2 is lost and H2O is displayed. Is there anyway other than copy and paste to retaing the formatting? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
subscript
You could use the camera tool
"Bender" wrote: When copying a cell with mixed format i.e. H2O with the 2 in subscript is in cell A1, If another cell contains =A1 the subscript format on the 2 is lost and H2O is displayed. Is there anyway other than copy and paste to retaing the formatting? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
subscript
You can use special fonts where sub- and superscripts occur as individual
characters. For facilitating the task: http://www.tech-archive.net/Archive/.../msg00189.html -- Petr Bezucha "Bender" wrote: When copying a cell with mixed format i.e. H2O with the 2 in subscript is in cell A1, If another cell contains =A1 the subscript format on the 2 is lost and H2O is displayed. Is there anyway other than copy and paste to retaing the formatting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subscript | Excel Discussion (Misc queries) | |||
subscript | Excel Discussion (Misc queries) | |||
Subscript shortcut? | Excel Discussion (Misc queries) | |||
superscript/subscript | Excel Discussion (Misc queries) | |||
Excel: how can I add a subscript 2 in H2O | Excel Discussion (Misc queries) |