Paste special

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. 

Because the ionic strength of a 1 1 electrolyte is equal to the concentration, copy the value 0.041 23 from cell B10 into cell B4. (To transfer a numerical value, rather than a formula, COPY cell B10 and then highlight cell B4. In the EDIT menu, select PASTE SPECIAL and then choose Value. The numerical value from B10 will be pasted into B4.) This procedure gives new activity coefficients in cells B6 and B8 and a new concentration in cell B10. Copy the new concentration from cell BIO into cell B4 and repeat this procedure several times until you have a constant answer. 

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. 

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. 

USING PASTE SPECIAL TO TRANSPOSE ROWS AND COLUMNS... 

First Copy the cells, then select a cell or range in which you want the transposed values to be placed. Choose Paste Special and check the Transpose box, then press OK. 

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

Enter the value 1 in cell A1, enter the formula =A1+1 in cell A2 and then use Fill Down to create the series. You can then use Copy and Paste Special (Values) to convert the formulas to values. 

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. 

To use this method. Copy the cell or range in the source document, then switch to the destination. Select the cell or range where the contents are to be pasted, choose Paste Special... from the Edit menu and press the Paste Link button. 

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

You can control how the data is added to the chart by choosing Paste Special... instead of Paste from the Edit menu. This allows you to add new data as new points or as a new series, independent of how the new selection aligns with the original data. 

Choose Paste Special... from the Edit menu. In the Paste Special for charts dialog box (see Figure 5-8), press buttons for New Series and X-Values In First Column, then OK. 

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. 

While the range is still highlighted. Copy the values and Paste Special (Values). This is necessary because we are going to Sort the values in the next step. 

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 ) ... 

A new random number is generated each time the worksheet is recalculated. You may need to Copy and Paste Special (Values) to prevent a random-number series from changing each time you change anything on a worksheet. 

Example Does the same thing as Paste Special (Transpose) from the Edit menu. 

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

The practice of using aerobic specimens for the measurement of free calcium should be abandoned because of the widespread availability of blood gas analyzers measuring free calcium and the use of evacuated gel tubes by reference laboratories. In the past, specialized free calcium analyzers equilibrated aerobic specimens with a carbon dioxide (5.3 kPa) air mixture to adjust their pH to near 7.4 (7.2-7.6), and then mathematically corrected the free calcium to pH 7.4, using an algorithm relating free calcium and In the event that aerobic free calcium results are corrected to pH 7.4 after equilibration with a mixture of CO2 and air, only the free calcium at pH 7.4 should be reported with appropriate identification. The normalized or adjusted free calcium at pH 7.4 has been reported to accurately reflect the free calcium status of normal persons and individuals without acid-base disturbances. However, aerobic handling of specimens with correction of the free calcium to pH 7.4 has been increasingly criticized. The free calcium value... 

Figure 3-8 Option window for the Edit/Paste Special... command in Excel.

Figure 8-5 Generating 10 random numbers from 1 to 1000 by use of a spreadsheet. The random number function in Excel [=RAND ) ] generates random numbers between 0 and 1. The multiplier shown in the documentation ensures that the numbers generated in column B will be between 1 and 1000. To obtain integer numbers, we use the Format/Cells. .. command on the menu bar, choose Number and then 0 decimal places. So that the numbers do not change with every recalculation, the random numbers in column B are copied and then pasted as values into column C using the Edit/Paste Special.

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. 

A fourth matrix operation, TRANSPOSE, is performed as part of the Edit => Paste Special operation. 2 Matrix inversion and matrix multiplication work only on data arrays, i.e., rectangular blocks of cells, but not on single cells. To enter these instructions, enter the array with CRTL + SHIFT + ENTER (on the Macintosh COMMAND + RETURN). 

When you want to copy the values rather than the formulas of cells or blocks of cells, use special paste values instead of paste following Ctrl + c click on Edit => Paste Special d>, then click on Values => OK. 

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. 

Highlight the data in AA6 AA206, copy that column with Ctrl + c to the clipboard, highlight the appropriate target cell in row AB6 AI6, then use Edit => Paste Special => Values to copy the values in column AA to the column for that particular value of p. 

---