Google Sheets · Verified tutorial
Verified by JosephineAbout 75 seconds
Copy and paste not working in Google Sheets
Copy A2:B2 and paste it into A5:B5. Do not move or change the original row.
Verified by JosephineAbout 75 secondsQuick answer
Copy A2:B2 and paste it into A5:B5. Do not move or change the original row.
Step-by-step
1
Open the practice sheetUse the example data shown below so the result is easy to check.
2
Copy and paste not workingCopy A2:B2 and paste it into A5:B5. Do not move or change the original row.
3
Check the resultCompare the finished sheet with the expected result and correct the target range if needed.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
A5:B5 is an exact copy of A2:B2.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Re-select A2:B2 and repeat the final action. A5:B5 is an exact copy of A2:B2.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Item | Amount |
| Hosting | 80 |
| Software | 120 |
| Design | 500 |
Video transcript
- Open the prepared Copy repair spreadsheet.
- Open the practice sheet. Use the example data shown below so the result is easy to check.
- Copy and paste not working. Copy A2:B2 and paste it into A5:B5. Do not move or change the original row.
- Check the result. Compare the finished sheet with the expected result and correct the target range if needed.
- A5:B5 is an exact copy of A2:B2.