Enter, edit, autofill and paste data safely in Excel

Quick answer: Give Auto Fill enough starting values to establish the intended pattern, and choose Paste Values when you want a fixed result rather than a copied formula. Check both the destination cells and their formulas before trusting a large fill or paste.

Version and platform: Microsoft 365 Excel for Windows desktop; Mac, Excel for the web and Excel 2013 interfaces not covered. Use a disposable workbook for the exercise.

Prepare a clear source and destination

Use a blank worksheet. Enter Sequence in A1, Quantity in B1, Double quantity in C1 and Snapshot in E1. Enter 1 in A2 and 2 in A3. Put 5, 8 and 11 in B2:B4, then type =B2*2 in C2. Leave C3:C4 and E2:E4 empty. The first formula result should be 10.

Work with this small block before repeating the technique on a long list. Copying into cells that already contain data can overwrite them, and ordinary paste transfers more than just what you can see on screen.

Fill a series and a formula

1. Select A2:A3, including both 1 and 2. Drag the fill handle at the selection’s lower-right corner down to A4. Expect 1, 2, 3 in A2:A4.
2. Select C2 and drag its fill handle down through C4. Expect 10, 16, 22.
3. Inspect C3 and C4 in the formula bar. Their formulas should be =B3*2 and =B4*2, not references that all remain fixed on B2.
4. If Auto Fill offers an unintended copy rather than the desired series, inspect Auto Fill Options and choose the suitable behavior, or undo and repeat with both starting values selected.

One seed value can intentionally produce repeated values. Microsoft contrasts a single 2, which can fill 2, 2, 2, with two seeds 2 and 4, which establish 2, 4, 6. Decide whether you need repetition or a series before dragging; the fill handle does not know the meaning of your record IDs.

Paste a fixed snapshot

Select C2:C4 and copy it. Select E2, open Home → Paste, and choose Values. E2:E4 should show 10, 16 and 22, while the formula bar for E2 shows a value rather than =B2*2. Ordinary Ctrl+V would paste formulas and other cell attributes, which is a different operation.

Change B3 from 8 to 9. C3 must become 18, but E3 should remain 16. This is the key changed-input check: the calculated column is live, whereas the snapshot intentionally preserves the earlier results. A snapshot that changes unexpectedly may contain formulas or links rather than values.

For a different task, Home → Paste → Paste Special or Ctrl+Alt+V lets you choose formulas, formats, validation and other specific attributes. Pick only what the destination needs; pasting a whole cell can replace existing validation or formatting without making that obvious from the displayed number.

Recover and save

If the fill goes too far, undo it immediately and repeat with the exact destination. If pasted formulas refer to the wrong inputs, inspect relative, absolute and mixed references before using the result. Do not fix the displayed answer manually while leaving an incorrect formula behind. Keep header cells out of the numeric fill selection.

Save the workbook as XLSX and reopen it. Verify A2:A4, the three C formulas and the fixed E values. Both formula and snapshot columns should survive, but they must retain their different purposes. The tutorial covers Microsoft 365 Excel for Windows; Mac and web controls are not assumed to share these exact paste dialogs or keyboard shortcuts.

Official references

• Paste options
• Fill data automatically in worksheet cells

Documentation snapshots retrieved 20 October 2026. These instructions and example checks are documentation-based; no native Excel run or application screenshot is claimed.