Set table column types in Google Sheets
Set the "Task" table column type to Text and the "Budget" table column type to Currency. Keep all values and the Owner column unchanged.
Verified by JosephineAbout 60 secondsSet the "Task" table column type to Text and the "Budget" table column type to Currency. Keep all values and the Owner column unchanged.
Step-by-step
Select the targetSet the "Task" table column type to Text and the "Budget" table column type to Currency.
Apply the changeKeep all values and the Owner column unchanged.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The table covers A1:C4, with Task typed as Text and Budget typed as Currency.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Undo the last change, reselect the intended range, and try again. The table covers A1:C4, with Task typed as Text and Budget typed as Currency.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Task | Owner | Budget |
| Prepare brief | Anna | 120 |
| Review draft | Ben | 240 |
| Publish page | Cara | 80 |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Set the "Task" table column type to Text and the "Budget" table column type to Currency.
- Apply the change. Keep all values and the Owner column unchanged.
- The table covers A1:C4, with Task typed as Text and Budget typed as Currency.