The simplest answer to the question: "How to create a table in Excel?"

In this article, we'll look at the process of creating spreadsheets. The most common editor for this is MS Office Excel. This program is an office application, and it is installed automatically with the entire package of office programs Microsoft Office.

Basically, Excel is used to perform complex calculations, create charts and diagrams, and create tables. How to create a table in Excel? To answer this not very complicated question, you first need to determine the version of office programs installed on your PC. Let's turn to the 2003 version.

First, open the program:

• "Start" button

• The menu section "All Programs"

• Section "Microsoft office"

• Subsection "Microsoft Office Excel 2003"

By default, only two main panels of the used tools appear on the first sheet of the editor: "Standard" and "Formatting". When you directly create a table, you need a toolbar called "Formatting." So, the editor is open, but how to create a table in Excel?

Each sheet cell (cell) has its own individual address, consisting of the line number and the column name. Determine the number of rows and columns of the future table and select the required number of cells. To select the desired fragment, you must place the cursor in the cell that will be in the upper left corner of the table, and without releasing the left mouse button, bring the cursor to the bottom rightmost cell. With the correct action, you will see a blue transparent background of the future table in a black frame.

The further sequence of actions is to find the button "Borders" on the toolbar with the name "Formatting" and select the boundaries of the future table. How to make the table in Excel the right size? To do this, determine the width of the columns and rows. The simplest thing is simply to expand the columns and lines "by eye", so to speak, by the method of selecting the width and height. When you move the cursor to the border between adjacent columns or rows (on the sheet header), a vertical line icon appears with two horizontal arrows. You can expand columns or rows only if you have such an icon with the left mouse button pressed.

Note that when the above symbol appears, the "width" or "height" with the specified numerical value of the cell size appears to resize the columns and rows next to it. With frequent work with tables in the Excel editor, it's easiest to set dimensions in numbers at once, rather than picking "by eye".

How to create a table in Excel, if some "windows" of the table need to be connected together? In order to merge a part of the cells with each other, it is necessary to select those that are to be connected and use the "Merge and place in the center" button. Instead of a few cells, one larger screen appears on the screen.

How to create a table in Excel of a different color? If you need to highlight a table in a color in the document, you must:

1. Select the table.

2. Right- click the context menu.

3. Select the "Format Cells" item.

4. Go to the "View" tab.

5. Select the desired fill color.

The following functions are also available in the "Format Cells" menu:

• change the number format of cells;

• change the position of the contents of the cell (alignment);

• editing the direction of the text;

• change the orientation of the label;

• choice of style and font style, its color and size;

• Change the cell / table boundaries, as well as the type and color of the lines used.

Let's move on to the 2010 version of Microsoft Office Excel. How to create a table in Excel 2010? In the new version, it is done with exactly the same algorithm as described above, even much simpler. The ease of use is that in Excel 2010 the toolbar is much more convenient than in 2003. There are almost all necessary and frequently used buttons, which in the previous version were only available when using context menus and calling additional windows.

Excel - one of the most convenient programs for easy creation of tables! We hope that after reading this article and taking advantage of the above tips, you will see this in your own example!