« Random sort | Main | Charting: Creating a Candlestick chart »
October 09, 2005
Paste Special III: Merging rows
It has been decided to merge the Mungits and Wingdings product lines. We will use Paste Special to merge the sales totals in the spreadsheet below.
Step 1: Select C6:F6 and Edit - Copy
Step 2: Select C5:F5 and Edit - Paste Special
The Paste Special dialog opens. In this situation, we apply the ADD operator to the paste operation which has the effect of adding the pasted data to the existing contents of the selected cells.
Having merged the data, we can safely delete the Wingdings row in the table.
Posted by Dave at October 9, 2005 08:28 PM