Using Paste Special

Excel Tip. You can use the Paste Values ( toolbutton instead of the Paste Special... menu command. See Chapter 19 for instructions on how to make this button, and many others, available. 

If you press one of the Operation buttons in the Paste Special dialog box, the value in the destination cell will be added to, subtracted from, multiplied by or divided by the value in the copied cell. 

C Comments C Validation C All except borders C Column widths 

If the cell in either the source or the destination contains a formula, then the formula will be enclosed in parentheses and joined to the contents of the destination cell by the arithmetic operator. Relative references in the source will be changed in the same way as in a normal Paste operation. You can also Copy cells that contain formulas and press both the Values button and one of the Operation buttons to either Add, Subtract, Multiply or Divide. 

If you check the Skip Blanks check box, only non-blank cells in the source will be pasted. 

---

When you Copy a cell and Paste it. Excel transfers the cell s contents, format and any comment. You can choose to transfer only some of these cell attributes by using Paste Special. The Paste Special dialog box (Figure 1-14) permits you to paste only Formulas, Formats or Comments. In addition, you can convert formulas to constants by choosing Values. 

USING PASTE SPECIAL TO TRANSPOSE ROWS AND COLUMNS... 

Figure 1-15. Rows and columns transposed. (Left) Before using and (Right) after using Paste Special (Transpose).

There are two ways to enter an external reference in a formula. With the first method, you begin typing the formula in the destination cell, then enter the external reference by selecting the appropriate range in the source document. With the second method, you copy the range in the source document, then use Paste Special... to paste it into the formula in the destination cell. These two methods are described in the following sections. 

Figure 5-7. Using Paste Special... for charts to add a data series.

The tick marks were added to the chart by copying the table of tick mark values (C20 D30), then using Paste Special to add the new series (Series 3), then formatting the series to remove the marker points and change the color of the line to black. 

When this approach is applied to Series 3 to provide Tick Mark Labels, you ll get two superimposed data labels at each x value (for example, 12 and 11.8 if you chose to display values.) This means that you ll have to select one of the two labels and delete it, then select the other label and edit it. A better way to add the data labels is to add a fourth data series with a single point for each tick mark in this example, select C20 D20,C23 D23,C26 D26,C29 D29 and Copy, add this as a new series. Series 4, using Paste Special, then format the series to set both Line and Marker to None. Then add data labels, either values (Y values) or labels (X values), to this series. Change the Alignment of the data labels to Above. Edit the data labels individually, replacing them with the desired text. 

The transpose is obtained by using the worksheet function TRANS POSE (array) or the Transpose option in the Paste Special... menu command (see "Using Paste Special to Transpose Rows and Columns" in Chapter ) ... 

Occasionally, menu commands and dialog box options are combined for clarity and conciseness "... use Paste Special (Values)...". 

Copy, move to the upper, left-most cell of the new area and choose Paste. Be careful because this will copy all formulas, too. If you want only the values from a spreadsheet, copy the part you want and choose Paste Special then choose the desired option (such as Value). You can also paste into Word. If you simply use Paste, you can manipulate the spreadsheet inside Word (resize it, change the font, etc.). If you use Paste Special, one option is to paste the spreadsheet as a picture. In that case the whole image is frozen before it is put into Word. 

In order to plot the corresponding titration curves, copy (using Paste Special => Values) the column for Vb/Va) t below that for Vb/Vai and make a second, double-length column for pH to the right of the existing data in the spreadsheet to facilitate plotting the pH versus (VbIVa) and VbIVa)t. Plot the titration curves. 

Although widely used in the past and still used in special cases, the industrial sulfation with chlorosulfonic acid presents several problems which have caused the decline of this technique in favor of the more advantageous sulfation method with sulfur trioxide. These problems consist of evolution of the highly corrosive hydrogen chloride, heat transfer characteristics of the reaction, and the comparatively high level of chloride ion in the sulfated product compared with alcohol and alcohol ether sulfates obtained with sulfur trioxide. 

In our tests, we used pasted mixtures of carbon-carbon electrode components with KOH solution having a density of 1,26 g em"3. Positive and negative electrodes were pasted onto the conductive polymer film, separated by ionoconductive separator, made out of special paper, pressed between external collectors of nickel-plated copper with pressure of 8 kgf-ern 2. 

Dry cells have been well-known for over 100 years and form the technical basis of today s modern dry cell industry. Zinc carbon cells are the most widely used of all the primary batteries worldwide because of their low cost, availability, and acceptability in various situations. The two major separator types ever used or in use are gelled paste and paper coated with cereal or other gelling agents such as methyl-cellulose. The paste type is dispensed into the zinc can, and the preformed bobbin is inserted, pushing the paste up the can walls between the zinc and the bobbin. A typical paste electrolyte uses zinc chloride, ammonium chloride, water, and starch or flour as the gelling agents. The coated-paper type uses a special paper coated with flour, starch, regenerated cellulose. 

A specialized approach is to use historical data to infer or identify potential causes. In this case, the investigators use past experience to look for patterns consistent with failure hypotheses. The technique is only as good as the records, and if data have not been put in the files, or are in error, then misleading inferences may result. In addition, if this type of event has not occurred before, the approach will not work. Failure data for the system under investigation are presented in a timeline that can be correlated with overall plant history. Two things are sought ... 

Within MS Word, you can use any of the techniques to paste a graphic into your document. I will select Edit and then Paste, but if you have experience with Word you can use the Paste Special menu selection or type CTRL-V. 

Aerosol OT Surfactant is used in special formulations that are applied directly to glass surfaces to prevent fogging under adverse weather conditions. Some of these formulations give durable films that stand up under severe tests. An example of an excellent "Antifog" paste is as follows ... 

In the past perfumes were made using flower and herb extracts and natural animal musk. These were very expensive and only used at special occasions. Nowadays perfume is 95 percent petrochemical substances (chemicals extracted from petroleum) and is much less expensive than the original rose water of yore, thus its use has become an everyday occurrence. Modern perfume can consist of hundreds of separate ingredients, and not all of these are tested for their effects upon health. Some ingredients could be toxic at certain dosage levels. Yet many still don t believe this, as if perfume is still just innocent natural extracts. 

About 2 years after we made the movie, I had occasion to show this to Douglas Shearer, Technical Director of Metro-Goldwyn-Mayer, then one of the major movie studios. I was surprised to learn that MGM was interested in novel imaging materials that could be employed in films for drive-in movie theaters, where the intense heat of the projection apparatus adversely affected the silver-based films. He thought my film was a nice piece of work and said MGM could have made a great film about our materials using their special-effects department. But, then, he was the owner of 20 Oscars for his past work. 

---