Microsoft Office Tutorials and References
In Depth Information
Finding, Editing, Moving, and Copying Data
The choices under the Operation category offer some interesting ways to perform
mathematical operations on a cell or range using the contents of the Clipboard. Let’s say you
have a worksheet containing a year’s worth of daily temperature data. You discover that for
a two-week period in June, the thermometer was off, giving results 3 degrees lower than
they should have been.
The ix? In a blank cell, enter the number you want to use as a constant—in this case, 3.
Select that cell and press Ctrl+C to copy its contents to the Clipboard. Now select the cells
in the 14 rows containing the incorrect temperature data, click the arrow under Paste, and
click Paste Special. Click Add and then click OK. The content on the Clipboard (3) is added
to the contents of all cells in the current selection.
You can use this same technique to apply an across-the-board 5 percent price hike to a list
of prices. Enter 1.05 in a blank cell and copy it to the Clipboard. Then select all the prices to
be adjusted and use the Multiply option in the Paste Special dialog box.
The last check box, Transpose, is our favorite. Want to convert all your rows to columns or
vice versa? Select a range and use this option, with or without any of the choices above it.
Pasting Text and Formats into Multiple Worksheets
Entering data into multiple worksheets simultaneously is a useful trick when you’re building
a complex workbook. If you have many individual worksheets that share a common
structure, you can enter text and format those common ranges without a lot of repetitive work.
You can select multiple worksheets one at a time by Ctrl+clicking each sheet tab, or use
Shift+click to select a contiguous group of tabs.