Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set up formula to copy format from one worksheet to anoth
How do I set up a formula to copy both value and format from one worksheet to
another? When I use the = sign, it copy the value only. How do I get the format be copied also? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set up formula to copy format from one worksheet to anoth
you can't "link" the formatting in the same way as you link the contents
what you need to do is to copy all the cells in your sheet X A B C ... 1 2 click on the grey square which I have illustrated with the X this selects all the cells in the sheet press control-C (copy) go to your new sheet and select the same X square now do edit paste special format / column width. if you are doing this very frequently, the idea would be to do it once as described above, thus creating a sheet callled TEMPLATE. Then each time you need to have another one, you can just right click on that sheet and do move/copy. HTH -- Allllen "sky" wrote: How do I set up a formula to copy both value and format from one worksheet to another? When I use the = sign, it copy the value only. How do I get the format be copied also? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
Copy Formula Is conditional format | Excel Worksheet Functions | |||
How to copy the format of one worksheet to others in same book? | Excel Discussion (Misc queries) | |||
How do I copy a formula with increasing worksheet numbers | Excel Discussion (Misc queries) | |||
Is it possible to copy a header/footer from one worksheet to anoth | Excel Discussion (Misc queries) |