Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Cell Formatting
Perhaps this is the wrong forum, however, someone will probably know.
In cell A1 on sheet2: =Sheet1!A1 This copies the contents correctly. Any ideas how to copy the cell formating, specfically the borders, text colors, and shading. I don't really need VBA code, just the simple Excel properties/formulas/functions Thanks in advance, Christmas May |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Cell Formatting
When Sheet1 cell A1 is selected, press Edit-Copy
Select sheet 2 cell a1 Press Edit-Paste-Special-Formats "Christmas May" wrote: Perhaps this is the wrong forum, however, someone will probably know. In cell A1 on sheet2: =Sheet1!A1 This copies the contents correctly. Any ideas how to copy the cell formating, specfically the borders, text colors, and shading. I don't really need VBA code, just the simple Excel properties/formulas/functions Thanks in advance, Christmas May |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Cell Formatting
Formulas can't return this kind of formatting.
Copy|paste (manually or through code) is one way. Another (kind of ugly) way: Select A1 on Sheet1 edit|Copy goto sheet2, A1 Shift-Edit|Paste picture link Leave the formula there (or point back to the original source in all your subsequent formulas). Christmas May wrote: Perhaps this is the wrong forum, however, someone will probably know. In cell A1 on sheet2: =Sheet1!A1 This copies the contents correctly. Any ideas how to copy the cell formating, specfically the borders, text colors, and shading. I don't really need VBA code, just the simple Excel properties/formulas/functions Thanks in advance, Christmas May -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy cell formatting in formula | Excel Worksheet Functions | |||
Copy data to new cell but with different formatting | Excel Discussion (Misc queries) | |||
How to copy formatting when moving from cell to variable to another cell on another worksheet | Excel Programming | |||
Copy Formatting of Cell | Excel Programming | |||
Copy cell with individual formatting | Excel Programming |