New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Formatting›Remove table formatting

Google Sheets · Verified tutorial

Remove table formatting in Google Sheets

Select A1:C4 and remove its formatting with Format > Clear formatting or the keyboard shortcut. Keep every value unchanged.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Select A1:C4 and remove its formatting with Format > Clear formatting or the keyboard shortcut. Keep every value unchanged.

Step-by-step

1

Select the targetSelect A1:C4 and remove its formatting with Format > Clear formatting or the keyboard shortcut.

2

Apply the changeKeep every value unchanged.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A1:C4 keeps its data and uses the default cell format.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A1:C4 and repeat the final action. A1:C4 keeps its data and uses the default cell format.

Example spreadsheet data

This is the clean fixture used for the verified run.

Task	Owner	Status
Prepare brief	Anna	Open
Review draft	Ben	Closed
Publish page	Cara	Open

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Select A1:C4 and remove its formatting with Format > Clear formatting or the keyboard shortcut.
Apply the change. Keep every value unchanged.
A1:C4 keeps its data and uses the default cell format.