Wipe the spittlebug foam off plants to control small infestations. A white foamy substance appearing on the leaves of plants is a sure sign you have a spittlebug infestation on your hands. Thankfully, this frothy foam in small amounts isnât harmful to people, mammals or plants, and spittlebugs are more of an annoyance than a threat.
To copy data from one cell to another using Excel's menu commands: 1  Place the cursor in the cell you want to Copy From. 2  Select Copy. 3  Select the cell to Copy To (it's actually Paste To)  Select 1  Paste. In other words, Copy From and Paste  To.
Turn on Record.. Write this code in the formula box. (A1) is the cell you want to duplicate. (B1) is the place in which you desire to paste your information. Write this code in the formula box to copy and paste an entire column. Write this code to copy and paste an entire row from 1 to 2.