How To Remove Table Formatting In Excel But Keep Data

Lesson 21: Tables

/en/excel2013/groups-and-subtotals/content/

Introduction

One time yous've entered information into a worksheet, yous may want to format your information as a table. Just like regular formatting, tables can amend the look and feel of your workbook, simply they'll also assistance to organize your content and make your information easier to utilize. Excel includes several tools and predefined tabular array styles, allowing you to create tables quickly and easily.

Optional: Download our exercise workbook.

To format information every bit a table:

1. Select the cells you lot desire to format as a table. In our example, we'll select the cell range A4:D10.

   Selecting a prison cell range to format as a table

2. From the Domicile tab, click the Format every bit Table control in the Styles group.

   Clicking the Format equally Table command

3. Select a table fashion from the drop-downwardly menu.

   Choosing a table style

4. A dialog box will announced, confirming the selected cell range for the tabular array.
5. If your table has headers, check the box next to My table has headers, and then click OK.

   Clicking OK

6. The cell range volition be formatted in the selected table style.

   The cell range formatted as a table

Tables include filtering by default. You lot can filter your information at any time using the drop-down arrows in the header cells. To learn more than, review our lesson on Filtering Data.

Modifying tables

It's easy to alter the wait and feel of any table after adding it to a worksheet. Excel includes different options for customizing a table, including calculation rows or columns and changing the table style.

To add rows or columns to a tabular array:

If you need to fit more than content in your table, Excel allows you to change the table size by including boosted rows and columns. There are two simple means to change the table size:

• Brainstorm typing new content after the final row or column in the table. The row or cavalcade will exist included in the tabular array automatically.

  Typing a new row below an existing tabular array

• Click, concur, and drag the bottom-right corner of the table to create additional rows or columns.

  Dragging the tabular array border to create more rows

To change the table style:

1. Select whatever cell in your table, then click the Design tab.

   Clicking the Pattern tab

2. Locate the Table Styles group, and then click the More drib-down pointer to come across all available table styles.

   Clicking the More drop-downwardly arrow

3. Select the desired style.

   Choosing a new table style

4. The selected table style will announced.

   The new table fashion

To modify the table style options:

You can plow diverse options on or off to alter the appearance of any table. There are several options: Header Row, Full Row, Banded Rows, First Column, Last Cavalcade, Banded Columns, and Filter Push button.

1. Select any prison cell in your table.
2. From the Design tab, check or uncheck the desired options in the Tabular array Style Options grouping. In our example, we'll bank check Total Row to automatically include a total for our tabular array.

   Checking the Total Row option
   

3. The table style volition exist modified. In our example, a new row has been added to the table with a formula that volition automatically calculate the total value of the cells in cavalcade D.

   The table with a total row

These options tin can affect your tabular array manner in diverse means, depending on the type of content in your table. You may demand to experiment with a few dissimilar options to observe the exact mode yous want.

To remove a table:

Sometimes you may not want to utilize the boosted features included with tables, such as the Sort and Filter driblet-down arrows. You lot can remove a tabular array from the workbook while still preserving the table's formatting elements, like font and jail cell color.

1. Select any prison cell in your table. The Pattern tab will appear.
2. Click the Catechumen to Range control in the Tools group.

   Clicking Convert to Range

3. A dialog box will appear. Click Yes.

   Removing a tabular array

4. The range will no longer be a table, simply the cells will retain their data and formatting.

   The cell range formatted as a normal range
   

Challenge!

1. Open an existing Excel workbook. If you lot want, y'all can utilise our practice workbook.
2. Format a range of cells as a table. If you lot are using the example, format the cell range A2:E13.
3. Add together a row or column to the tabular array.
4. Cull a new table fashion.
5. Change the table style options. If you are using the example, add a total row.
6. Remove the tabular array.

/en/excel2013/charts/content/

Source: https://edu.gcfglobal.org/en/excel2013/tables/1/

Posted by: stevensonmilty1985.blogspot.com

Share this post