Paste special options in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant managing monthly expense reports.

📋 Request: Your manager wants you to copy expense data from one sheet to another but only paste the values, not the formulas or formatting.

📊 Data: You have a sheet with expense data including formulas for totals and some colored cells for categories.

🎯 Deliverable: Create a new sheet with the same expense values but without any formulas or formatting.

Sample Data

Item	Cost	Tax (10%)	Total
Paper	20	=B2*0.1	=B2+C2
Ink	35	=B3*0.1	=B3+C3
Stapler	15	=B4*0.1	=B4+C4

1

Step 1: Select the range A1:D4 containing the expense data including formulas and formatting.

No formula needed; just select the cells.

Expected Result

Cells A1 to D4 are selected.

2

Step 2: Copy the selected range (Ctrl+C or Command+C).

No formula needed; use keyboard shortcut or menu.

Expected Result

Data copied to clipboard.

3

Step 3: Go to a new sheet where you want to paste the data.

No formula needed; click on the new sheet tab.

Expected Result

New sheet is active.

4

Step 4: Right-click on cell A1 in the new sheet and choose 'Paste special' > 'Paste values only'.

Use menu: Edit > Paste special > Paste values only

Expected Result

Only the values from the original range are pasted without formulas or formatting.

5

Step 5: Verify that the pasted cells show numbers instead of formulas and have default formatting.

Check cells A2:D4; no formulas should appear.

Expected Result

Cells show values: Paper, 20, 2, 22; Ink, 35, 3.5, 38.5; Stapler, 15, 1.5, 16.5 with no color or formula.

Final Result

New Sheet - Values Only Paste

| Item    | Cost | Tax | Total |
|---------|------|-----|-------|
| Paper   | 20   | 2   | 22    |
| Ink     | 35   | 3.5 | 38.5  |
| Stapler | 15   | 1.5 | 16.5  |

✓Paste special 'values only' removes formulas and formatting.

✓This method keeps the data intact but prevents accidental formula changes.

✓Useful for sharing clean data without underlying calculations.

Bonus Challenge

Try using 'Paste special' > 'Paste format only' to copy just the colors and fonts without values or formulas.

Show Hint

After copying the original range, use Edit > Paste special > Paste format only on the new sheet.