|
Chapter
1, 2,
3, 4,
5, 6,
7, 8,
9,
10, 11,
12,
13
Version 1.11 by Kirt Blattenberger RF Cafe Website (www.rfcafe.com)
Chapter 2
2 Adding or Deleting Rows
Adding or deleting a row (or rows) is a simple process, but care
must be taken to be certain that the cascaded formula sequences are not lost. Here is a step by step method
that assures cascade integrity. One simple rule applies to adding and deleting rows:
Never Select the First Two Rows
Or the Last Two Rows
There are other methods of adding or deleting rows, but this one
seems to be the most foolproof. When adding or deleting rows, be sure to make the same changes to all
worksheets that tie into the main “Inband” worksheet: “Filter-Mixer,” “DC Power,” and BOM.”
2.1 Adding
Rows |
|
|
|
|
|
|
|
-- Use the Ctrl+C keyboard combination to copy the rows to the Windows clipboard.
|
|
|
|
-- Use the Ctrl+V keyboard combination to paste the rows into the worksheet from
the Windows clipboard.
|
|
|
Re-number the “Item” column and enter the new component
parameters. Now perform the identical series of operations on the “Filter-Mixer,” “DC Power,” and “BOM”
worksheets. |
2.2 Deleting
Rows |
|
|
|
|
|
|
|
-- Use the Ctrl+C keyboard combination to copy the rows to the Windows clipboard.
|
|
|
|
-- Use the Ctrl+V keyboard combination to paste the rows into the worksheet from
the Windows clipboard.
|
|
|
|
Re-number the “Item” column and enter the new component parameters. Now perform
the identical series of operations on the “Filter-Mixer,” “DC Power,” and “BOM” worksheets.
|
|
Chapter
1, 2,
3, 4,
5, 6,
7, 8,
9,
10, 11,
12,
13
|
Version 1.11 by Kirt Blattenberger RF Cafe Website (www.rfcafe.com)
|
Chapter 2
|
|