How to draw a table in Excel

Excel spreadsheets are great tools for calculating numbers. In this article, you can help Excel table guys as quickly as possible.

How to draw a table in Excel Picture 1

Step 1: After creating the data table to draw the table, you just need to select the data area you want to draw the table -> go to the Home tab, click the Border icon -> click All Border:

How to draw a table in Excel Picture 2

The results of the data are plotted as shown below:

How to draw a table in Excel Picture 3

Step 3: Edit the content of the data table with the title to merge cells (if you do in the process of creating data, skip this step). Here, the headings of columns No., First and last name, Points, Sum of points need to be drawn, for example, the points of the Column cells:

How to draw a table in Excel Picture 4

Step 4: After joining the cell, you need to adjust the position of the text in the middle of the cell by selecting the cell to format -> right-click and choose Format Cell:

How to draw a table in Excel Picture 5

Step 5: A dialog box appears and select the Alignment tab in the Alignment section to change the values ​​of Horizontal, Vertical to Center -> click OK:

How to draw a table in Excel Picture 6

As a result, you have formatted the table:

How to draw a table in Excel Picture 7

Step 6: The last thing you need to do is adjust the outer border of the table beautifully and distinguish it from the inside border. Select the table -> right-click Format Cells -> dialog box appears Border selection, select the border style for the border outside the table in Style -> select the border color in Color -> click Outline - > click OK:

How to draw a table in Excel Picture 8

As a result, you can draw tables and edit them as you want, in addition, after drawing tables you can fill the background color for each row and column as you like:

How to draw a table in Excel Picture 9

In case you do not want to draw the table, but use the formats available in Excel that apply to the table, simply select the data area you want to create the table -> go to the Home tab -> Format as Table -> select the type of table to create:

How to draw a table in Excel Picture 10

A dialog box appears, select the My Table has Header box if the table creation content already includes the title, otherwise deselect if the selected area does not contain a title -> click OK:

How to draw a table in Excel Picture 11

The result is plotted, but if the title contains content that needs to be merged in this way, Merge Cell cannot be merged :

How to draw a table in Excel Picture 12

So depending on the table content you can draw the table in many ways as you like. Good luck!

4 ★ | 22 Vote

May be interested

  • How to use Track Changes in WordPhoto of How to use Track Changes in Word
    how to use track changes in word when you share a text document, it is difficult to see the change if you use it with your normal eyes to control the change in your text. the following article helps you control changes t
  • The numbering of pages in Word follows a symmetric parity pattern similar to a printed bookPhoto of The numbering of pages in Word follows a symmetric parity pattern similar to a printed book
    the numbering of pages in word follows a symmetric parity pattern similar to a printed book. textbooks (2-sided) have a very good page numbering and science. the odd pages 1, 3, 5 are numbered on the right margin, even pages 2, 4, and 6 are numbered in the left margin.
  • How to frame text in WordPhoto of How to frame text in Word
    how to frame text in word in this article, you can frame the cover page, the whole document or just framed a paragraph in word.
  • Instructions on how to create and use macros in Excel Create macros, save macros, run macrosPhoto of Instructions on how to create and use macros in Excel Create macros, save macros, run macros
    instructions on how to create and use macros in excel create macros, save macros, run macros. creating a simple macro will make it easier for you to understand and from there you will learn more advanced with macros in excel. if you want to know how to create, save and run macros in
  • Delete background colors and backgrounds in ExcelPhoto of Delete background colors and backgrounds in Excel
    delete background colors and backgrounds in excel. in excel, you can use images as the background for a spreadsheet for the purpose of displaying only, since it is not printed. but if you use background color, it will be printed with data in exc worksheet
  • How to delete notes, comments in ExcelPhoto of How to delete notes, comments in Excel
    how to delete notes, comments in excel. comments in excel help you annotate for a data cell or all worksheets, making the document easier to understand even when others use it. but when you don't need the notes, you can delete them