How to remove table formatting in Google Sheets and Excel

While working with Google Sheets or Excel, formatting is a common field. It allows users to make the dataset more eye-catching, readable, and visible. However, in some cases, you may need to clear the formatting in the dataset. This should not stress you because this article has got you covered.

To remove Table formatting in Google Sheets

Google Sheets does not have the table feature. However, one can easily create a table from its row and column cells. These methods can be used:

a) Using the Format tool

Steps:

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account). From Google Apps, click on the Sheets icon and select the existing sheet containing the formatting you want to remove.

2. Highlight the table that contains the formatting.

3. Click on the Format tab on the menu.

4. From the drop-down menu, choose the Clear formatting option.

b) Using Keyboard shortcuts

Steps:

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account). From Google Apps, click on the Sheets icon and select the existing sheet containing the formatting you want to remove.

2. Highlight the table that contains the formatting.

3. On your keyboard, press these keys CTRL + \ buttons.

c) To copy and paste without the formatting

under this, two methods can be used:

a) Keyboard shortcuts

Steps:

1. Click on the table that you want to copy.

2. Press CTRL + C to copy the content.

3. Locate where you want to paste the content without the formatting.

4. Press CTRL + SHIFT + V keys on your keyboard.

b) Using the right-click tool

Steps:

1. Click on the table that you want to copy.

2. Press CTRL + C to copy the content.

3. Locate where you want to paste the content without the formatting.

4. Right-click and hover the cursor over the Paste Special button.

5. Finally, click on the Values only option.

To remove Table formatting in Excel.

Unlike Google sheets which do not have the table feature, Excel has a table that can be formatted.

a) To remove table formatting

Steps:

1. Open the Excel document that contains the document you want to remove the formatting.

2. Highlight the table that contains the formatting.

3. Click on the Design tab in the table tools section.

4. Click on the More design icon in the Table Styles section.


5. Then, click on the Clear button from the menu.

b) To paste the table without formatting.

Steps:

1. Click on the table that you want to copy.

2. Press CTRL + C to copy the content.

3. Locate where you want to paste the content without the formatting.

4. Right-click and hover the cursor over the Paste Special button.

5. Choose the Values options

Alternatively:

1. Click on the table that you want to copy.

2. Press CTRL + C to copy the content.

3. Locate where you want to paste the content without the formatting.

4. Click on the Home tab and locate the Paste drop-down button.

Leave a Comment