Use smart fill in Google Sheets
Use Google Sheets Smart fill to complete the missing value in C3 from the surrounding examples. It must become Ben Patel. Keep every other cell unchanged.
Verified by JosephineAbout 60 secondsUse Google Sheets Smart fill to complete the missing value in C3 from the surrounding examples. It must become Ben Patel. Keep every other cell unchanged.
Step-by-step
Select the targetUse Google Sheets Smart fill to complete the missing value in C3 from the surrounding examples.
Complete the next actionIt must become Ben Patel.
Apply the changeKeep every other cell unchanged.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The Full name column is completed consistently for every row.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Re-select C3 and repeat the final action. The Full name column is completed consistently for every row.
Example spreadsheet data
This is the clean fixture used for the verified run.
| First name | Last name | Full name |
| Anna | Lopez | Anna Lopez |
| Ben | Patel | |
| Cara | Nguyen | Cara Nguyen |
| Dev | Martin | Dev Martin |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Use Google Sheets Smart fill to complete the missing value in C3 from the surrounding examples.
- Complete the next action. It must become Ben Patel.
- Apply the change. Keep every other cell unchanged.
- The Full name column is completed consistently for every row.