How Do You Make A Table On Excel

Download Article

Download Article

This wikiHow teaches yous how to create a table of information in Microsoft Excel. You can do this on both Windows and Mac versions of Excel.

1. one

   Open your Excel document . Double-click the Excel document, or double-click the Excel icon and so select the document's proper noun from the dwelling folio.

   • You lot tin also open a new Excel document by clicking Blank Workbook on the Excel dwelling house page, but you'll need to input your data earlier continuing.

2. 2

   Select your table'south information. Click the cell in the elevation-left corner of the information group you want to include in your table, then hold downwardly ⇧ Shift while clicking the bottom-right cell in the information group.

   • For example: if you have data in cells A1 downward to A5 and over to D5, yous would click A1 and and so click D5 while holding ⇧ Shift .

   Advertisement

3. 3

   Click the Insert tab. It'southward a tab in the green ribbon at the top of the Excel window. Doing so will display the Insert toolbar below the green ribbon.

   • If you lot're on a Mac, brand sure you don't click the Insert carte du jour detail in your Mac's menu bar.

4. iv

   Click Table . This option is in the "Tables" department of the toolbar. Clicking it brings up a pop-up window.

5. 5

   Click OK . It'southward at the bottom of the pop-upwardly window. Doing so volition create your tabular array.

   • If your data grouping has cells at the top of information technology that are defended to column names (east.g., headers), click the "My table has headers" checkbox before you click OK.

   Advertisement

1. 1

   Click the Pattern tab. It's in the light-green ribbon near the top of the Excel window. This will open a toolbar for your tabular array's design straight below the green ribbon.

   • If you don't see this tab, click your table to prompt information technology to appear.

2. 2

   Select a design scheme. Click one of the colored boxes in the "Table Styles" department of the Pattern toolbar to use the color and design to your table.

   • Yous tin can click the downwardly-facing arrow to the correct of the colored boxes to scroll through different design options.

3. 3

   Review the other design options. In the "Table Style Options" section of the toolbar, check or uncheck whatsoever of the following boxes:

   • Header Row - Checking this box places column names in the summit prison cell of the data grouping. Uncheck this box to remove headers.
   • Full Row - When enabled, this choice adds a row at the bottom of the table that displays the full value of the correct-most column.
   • Banded Rows - Check this box to colour in alternating rows, or uncheck information technology to leave all rows in your table the same color.
   • First Column and Last Cavalcade - When enabled, these options brand the headers and data in the outset and/or last columns bold.
   • Banded Columns - Check this box to colour in alternate columns, or uncheck it to go out all columns in your table the same colour.
   • Filter Button - When checked, this box places a drib-down box adjacent to each header in your table that allows you to change the information displayed in that cavalcade.

4. 4

   Click the Home tab over again. This will accept you back to the Home toolbar. Your table's changes will remain.

   Advertisement

1. 1

   Open up the filter menu. Click the drop-down arrow to the correct of the header for the column whose information you want to filter. A driblet-down card will appear.

   • In gild to do this, y'all must have both the "Header Row" and the "Filter" boxes checked in the "Tabular array Way Options" department of the Design tab.

2. two

   Select a filter. Click 1 of the following options in the drop-down menu:

   • Sort Smallest to Largest
   • Sort Largest to Smallest
   • You may as well have additional options such as Sort by Color or Number Filters depending on your data. If so, you can select one of these options and then click a filter in the pop-out menu.

3. 3

   Click OK if prompted. Depending on the filter you cull, yous may also have to select a range or a different type of data before you can continue. Your filter will be applied to your table.

   Advertisement

Add New Question

• Question

  How practise I resize the columns?

  

  Identify your mouse between the columns until the cursor changes into a double arrow pointing to the left and to the correct. Left click and concur. Drag the mouse, while holding the left button, to the left to shrink or to the right to enlarge the cavalcade.

• Question

  How do I change the width of a column in Excel?

  

  If you go up to "Format," and select "Width" yous volition be able to modify the size.

• Question

  How do I brand a table in Excel fit the size of a paper?

  

  In Excel 2013, click the "Page Layout" tab, then click the "Size" dropdown menu. Nigh printers use viii.5 x eleven inch paper.

• Question

  How do I capitalize the kickoff word in a table?

  

  Select the prison cell to the right of the name, and blazon =PROPER(jail cell with the incorrect proper noun ie. a1) Then y'all can drag that down and it will right for the rest.

• Question

  How do y'all make two separate tables, where editing in 1 table doesn't affect the other table?

  

  Y'all could create (re-create/paste, or create from scratch) the second table in a separate worksheet and label the sheets (Format: Rename sheet) accordingly.

• Question

  How do I label the columns?

  

  Hover your mouse over the existing cavalcade label (A, B, C, and then on). Move your pointer effectually slowly until it changes. Then, right-click and select the "Rename" pick from the menu that appears.

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertizement

Video

• If you no longer need the table, you tin either delete it entirely or turn it dorsum into a range of data on the spreadsheet page. To delete the table entirely, select the tabular array and printing your keyboard "Delete" primal. To modify information technology back to a range of data, right-click whatsoever of its cells, select "Table" from the popup bill of fare that appears, and then select "Convert to Range" from the Tabular array submenu. The sort and filter arrows disappear from the column headers, and whatsoever table proper noun references in the cell formulas are removed. The cavalcade header names and the table formatting remain, even so.

• If you place your table then that the header for the first column is in the upper left corner of the spreadsheet (Jail cell A1), the column headers will replace the spreadsheet'southward column headers when you scroll upwardly. If yous identify the table anywhere else, the column headers volition scroll out of view when you scroll up, and you'll need to use Freeze Panes to proceed them constantly displayed.

Advertisement

About This Commodity

Article Summary X

ane. Open up a file with data.
2. Select information for the tabular array.
iii. Click Insert.
4. Click Tabular array.
5. Click OK.

Did this summary assist you?

Thanks to all authors for creating a folio that has been read 538,310 times.

Is this article up to date?

Source: https://www.wikihow.com/Make-Tables-Using-Microsoft-Excel

Posted by: clarkcasits.blogspot.com

Share this post