Paste Values, Transpose and Scale a Range in PlanMaker 2026

Scope: PlanMaker 2026 paid desktop, English ribbon interface; official 2026 documentation reviewed on 19 October 2026. NX builds require matching controls; compatibility with every NX build is not established here. Native application verification remains pending. FreeOffice and mobile parity are not claimed.

Turn a live calculation into a frozen snapshot, rotate that snapshot, and apply a controlled multiplier without touching the source. Use separate destinations so you can tell which operation produced each result.

Build the source and preserve it

Enter this complete fixture in A1:D4. Type formulas with the leading equals sign. Use a locale-appropriate decimal separator wherever required.

Row	A: Item	B: Units	C: Unit price	D: Amount
1	Item	Units	Unit price	Amount
2	Kit	4	12	=B2*C2
3	Cable	3	8	=B3*C3
4	Case	2	15	=B4*C4

The amounts are 48, 24 and 30, totaling 102. Reserve F2:F4 for a frozen snapshot, H2:J2 for its rotated copy, and L2:L4 for scaled values. In N2:N4 enter 1.10 in every cell; N1 can say Multiplier. These matching three-cell dimensions avoid depending on how a single copied cell is repeated across a larger selection.

Save the input file as paste-inputs.pmdx, then save a separate paste-work.pmdx. Keep all output destinations empty. The official Paste special options appear when complete worksheet cells have been copied, not merely text selected inside the cell editor.

Freeze the formula results

1. Select D2:D4 and use Copy.
2. Select F2, the top-left destination.
3. Open the arrow under Home → Edit → Paste, then choose Paste special.
4. Enable Paste cell contents and Convert formulas to values. Disable Transpose and Skip empty cells. Set Operation to None. For a content-only exercise, leave the paste-formatting and cell-dimension options unchecked.
5. Confirm. F2:F4 should contain 48, 24 and 30.

Inspect F2 in the edit line: it should contain the number 48, not =B2*C2. Change B2 from 4 to 5. D2 should now be 60, while F2 remains 48. Restore B2 to 4 before the next stage. A frozen snapshot is useful only when you deliberately want it to stop tracking the source.

Transpose without changing the source

Copy F2:F4, select H2, and reopen Paste special. Use Paste cell contents, Operation: None, and enable Transpose. Confirm. Expect H2=48, I2=24 and J2=30. You copied a three-row, one-column range into one row and three columns. F2:F4 and D2:D4 should still be intact.

Keep this lesson in PlanMaker 2026 paid desktop scope. NX builds require matching controls; compatibility with every NX build is not established here. The current 2026 manual documents Transpose, but this tutorial does not assert the same option in FreeOffice or mobile editions. If your dialog lacks it, confirm the installed edition rather than substituting an unrelated Excel shortcut.

Scale only a disposable copy

First copy F2:F4 to L2:L4 with Paste special, content enabled, Transpose off and Operation: None. Check L2:L4 are 48, 24 and 30 before multiplying.

Then copy N2:N4, select L2, reopen the dialog, leave Transpose off, and set Operation to Multiply with destination. Confirm. The independent expected results are 52.8, 26.4 and 33, totaling 112.2. The operation combines copied multipliers with the existing destination values; it is not merely a new display format.

Check D2:D4 and F2:F4 still total 102. If you repeat the multiply command accidentally, the destination becomes 58.08, 29.04 and 36.3, totaling 123.42. Recover by rebuilding L2:L4 from the frozen snapshot with Operation None, then applying the multiplier once. Do not compensate with a guessed inverse or assume Undo will remain available after closing the file.

Change, grow, and reset the workflow

For a new scenario, change N2:N4 to 1.25. Copy F2:F4 to L2 using Paste special with Paste cell contents enabled, Operation: None, and Transpose off to rebuild the unscaled destination. Then copy N2:N4 to L2 with Operation: Multiply with destination and Transpose off. Expect 60, 30 and 37.5, totaling 127.5. Restore N2:N4 to 1.10 and repeat those two explicitly configured pastes for the original result.

To add an item, enter A5 Label, B5 5, C5 2, and D5 =B5*C5. The source total becomes 112. Before rebuilding the four-row snapshot, clear F2:F5 and any previous transposed output H2:K2. Configure every paste explicitly; the preceding arithmetic operation must not carry into a replacement paste.

1. Copy D2:D5 and select F2. Open Paste special; enable Paste cell contents and Convert formulas to values, set Operation: None, and turn Transpose and Skip empty cells off. Confirm. Expect F2:F5 to contain 48, 24, 30 and 10.
2. Copy F2:F5 and select H2. Open Paste special; keep Paste cell contents enabled, set Operation: None, enable Transpose, and leave Skip empty cells off. Confirm. Expect 48, 24, 30 and 10 across H2:K2.
3. Clear L2:L5. Copy F2:F5 and select L2. Open Paste special; keep Paste cell contents enabled, set Operation: None, and turn Transpose and Skip empty cells off. Confirm. Check the unscaled L2:L5 values are 48, 24, 30 and 10 before continuing.
4. Enter 1.10 in N5, matching the restored 1.10 in N2:N4; use your locale’s decimal separator if necessary. Copy N2:N5 and select L2. Open Paste special; keep Paste cell contents enabled, now select Operation: Multiply with destination, and leave Transpose and Skip empty cells off. Confirm. Expect L2:L5 to contain 52.8, 26.4, 33 and 11, totaling 123.2.

Only the final paste multiplies. Each earlier paste replaces its destination with a clean snapshot, so this sequence does not depend on the dialog remembering or resetting its last operation.

Troubleshooting and final verification

A missing option usually means the clipboard holds text rather than whole cells. A vertical result after a transpose attempt means the checkbox was off or an ordinary Paste was used. Unexpected stale values can arise from Skip empty cells: leave it off for these explicit replacements. A destination that changes when the source changes still contains formulas or references; inspect it rather than relying on appearance.

Save and reopen the working copy, then check the source, frozen and scaled regions separately. That is a proposed native acceptance test, not a claimed run. The numeric expectations were calculated independently. Before sending the workbook elsewhere, review PlanMaker file formats.

Official documentation and verification scope

PlanMaker 2026 paid desktop, English ribbon interface; official 2026 documentation reviewed on 19 October 2026. NX builds require matching controls; compatibility with every NX build is not established here. Native application verification remains pending. FreeOffice and mobile parity are not claimed.

• Paste special

No native screenshots are included. These are original practice fixtures and documentation-backed instructions; rendering a website or calculating expected values is not a native application test.