NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Spreadsheet basics›Convert a table back to a range

Google Sheets · Verified tutorial

Convert a table back to a range in Google Sheets

Convert the existing table back to a normal cell range. Preserve every value in A1:C4.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Convert the existing table back to a normal cell range. Preserve every value in A1:C4.

Step-by-step

1

Select the targetConvert the existing table back to a normal cell range.

2

Apply the changePreserve every value in A1:C4.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

No table covers A1:C4, and all original values remain.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A1:C4 and repeat the final action. No table covers A1:C4, and all original values remain.

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. Convert the existing table back to a normal cell range.
Apply the change. Preserve every value in A1:C4.
No table covers A1:C4, and all original values remain.