Hello, everyone who has looked at my blog in search of information about how to create tables in WORD. In fact, according to the plan, the next entry in the "Crib" section was supposed to be an entry about the Gost framework for abstracts, diplomas and other official documents. But, since, in order to make a stamp there, as it should be, you need knowledge of how to make a table in Word. Therefore, I decided to change the order of publication of materials.

So, I know 5 ways to create tables in Word. Four of them are absolutely simple. The fifth one is a bit tricky. But better about everything in order. Go?

Method one - using a template

Let's go to the tab "Insert" and section, respectively, "Table". The first in the drop-down box is a grid that displays rows and columns of your future creation in the form of cells. Highlight the desired number with the cursor. An inscription will be displayed above the grid: "TableX*Y" so you don't make the wrong choice. Thus, in a few seconds, you can get the simplest small plate (see Fig. 1).

rice. one

Its size will be limited to ten rows and eight lines (according to the number of cells in the template). If your table needs to be larger, then use the second method.

Method two - creating tables in Word using the "Insert Table" window

All in the same tab "Insert" section "Tables" click on the line "insert table". In the window that opens, select the desired number of rows and columns. Below, in the section "Auto-selection" you can specify a specific column width or select a parameter on which it will depend:

• The button is enabled by default. "constant". In this case, the Word itself will set the required width if you prefer the value "Auto". However, you can specify a specific column width - constant for the entire table.
• When you select a button "by content" columns will expand as data is entered.
• "width of the window"- the table will automatically take the dimensions of the document.

In line "Default for new tables" the checkbox should be set only if it is necessary that all subsequent tables be a copy of the first one (see Fig. 2).

rice. 2

Method three - drawing

So, set the pencil cursor to the point corresponding to the upper left corner of the future table. With the left mouse button pressed, stretch the borders of the table to the required extent. Then draw internal dividing lines, marking the necessary table cells. Word will take care of the strict verticality or horizontality of your lines (see Fig. 3).

rice. 3

If you draw a line in the wrong place, no problem. As soon as you mark the contours of the future table, a cross will appear in its upper left corner. Double-clicking on it will open a tab in the toolbar "Working with tables" with two sections: "Constructor" And "Layout". Our way to remove extra lines in the table is as follows: "Layout" - "Draw Table" - "Eraser". After that, we click on any unnecessary line of the table and delete it without any problems (see Fig. 4).

rice. 4

By the way, sometimes you need to draw a diagonal line in the cells of a table. When creating a table in WORD by drawing, you can easily do this.

Method four - express tables

You can also make a table in Microsoft Word using the built-in ready-made tables menu. The program offers 9 ready-made templates that can be useful for creating calendars or simple spreadsheets.

Still out of tab "Insert" section "Tables" select the line from the drop down list "Express Tables". Your attention will be offered 9 options for ready-made tables in which you can change the data. The choice, of course, is small, but if there is a suitable option, then it is quite convenient (Fig. 5).

rice. five

Method five - transferring a table from Excel to Word

At the beginning of this article, I called this way of creating tables in Word confusing. In fact, actually importing a table from Excel to Word is not difficult. To do this, in the tab "Insert" section "Tables" click on the line "tableExcel». An Excel sheet with a table will appear in your document (Fig. 6).

rice. 6

The main advantage of this method is the ability to perform mathematical operations with the contents of columns and rows. If there is such a need, then you will need to make a table in the Word using this method. Otherwise, you should not use it, since it is clearly more difficult than all the previous ones.

After entering the data and formatting the table, you need to double-click on the text outside the table, after which it will take on the following form (see Fig. 7).

rice. 7

In this state, nothing can be changed in it. However, do not worry, friends. A double-click inside the table frames is enough, and it will again become susceptible to any changes.

Working with Excel tables requires knowledge and certain skills. We will not deal with this issue now, since this topic is for a separate big conversation. I will definitely return to this issue, but later.

And yet, in addition to the promised five ways to create tables in Word, this article needs to address one more issue. We learned how to make tables. Now it's time to consider removing them.

How to delete a table in Word

Without further ado, I prescribe for you, friends, the path to deleting the Word table: panel "Working with tables"(it opens when you click on the cross to the left of the table or double-click inside the table borders) - tab "Layout"- chapter "Delete"- line "delete table". Voila! Done (see Figure 8). And you can not even go to the top flight control panel. Indeed, when you click on the same upper left cross (and it is called a table move marker), a mini-panel opens in an abbreviated version, but the button "Delete" there is.

rice. 8

But the Excel table can not be removed in this way. But on the other hand, it is very easy to select and cut it by pressing a key. DELETE.

So, dear fans of Word 2016, today we have discussed with you all the ways to create tables in WORD, as well as the method of deleting them. But our conversation about Word tables is not over. We still need to learn how to format them. How to add / remove a row / column, how to change their height / width, how to divide cells and merge them - this will be my next "Cheat Sheet".

For those who prefer to see once than read a hundred times - my new video.

All the best! Your guide to Word 2016 copywriter GALANT.

You may be interested.

Especially for those who work a lot with various kinds of documents, information on how best to work with tables in Word. Most of the methods are described below, and they all work fine in Microsoft word.

1. Apply the "sketch"

Microsoft Word 7, 10 and 13 has an easy table creation feature. Even 2003 "office" has the same feature, but less functional.

In order to enter text into a table in Word 07, 10, 13, you need:
- Go to "Insert" in the top panel;
- Click on the "Table" item;
- When a thumbnail appears with a maximum of ten columns and eight rows available, simply hover over the required number of cells.

In Word 2003, this process looks even different.

You do not need to go to the tabs - in the top panel of the program there is a special menu with a thumbnail, as in the picture below:

Here the table is much smaller. The ability to create a grid is quite scarce and limited. After the table has been added and selected, it can be edited, and to do this, hover over the borders or lines, click on them to move.

Columns or just cells can be deleted individually.

This is done simply: select the desired fragment, and then click on "Delete".

2. Apply the insert window

All versions of Word are the same in terms of windows.

There is one difference in Word 2003 - the "automatic format" feature. She is responsible for making the table grid more beautiful and "stylish".

In more modern versions, the table is adjusted to the selected style automatically. By default, auto-formatting is applied. Such tables will not have filled cells or columns of different lengths.

To add a table in 2007, 13, 10 Word:
- Tab "Insert";
- Select "Tables";
- Item "Insert table".
Next, a window for setting the columns and rows of the table will open. It is the same for any version of the Word, by entering the required number of rows and columns, click "ok".

In Word 2003, such a table is accessed through an item in the "Table" menu. And this means that you need to click on the "Table" on the panel, and then press the "Insert" item and select "Table" in the next window.

Specify the desired parameters and confirm the selection with the "OK" button.

3. Draw a table in Word manually

This method is also the same everywhere. IN Word 2013, 2010, 2007, go to the "Insert" tab and select "Tables". The required menu is "Draw Table". After you click on it, a special pencil will appear. By moving it, you can actually draw the desired type of table.

The advantage of drawing a table in this way is that the user can choose any kind of grid and create it himself. Cells are not auto-formatted and therefore can be of different sizes, and their number can be arbitrary and placed randomly.

4. Import table from Excel to Word

Using the Excel interface, users always have the opportunity to create a table in it.
In the "Table" menu, select the "Insert" item for 07, 10 and 13 versions of the Word, and for word 2003, select the " Excel table».
Now a special Excel spreadsheet should appear on the screen. It looks something like the photo below:

The method provided allows you to use all Excel functions in Word.
As you can see in the picture above, the "Sum" construction is used in the table in order to determine the sum in two or more cells. The appearance of the table is approximately the same as in MS Excel.

Reducing or increasing the size of the table occurs in a standard way. But the shape of the cells cannot be changed.

Considering all the functionality of the provided table, such a disadvantage is insignificant, because with the help of so many operations you can do a lot of things, even work with formulas and so on.

5. Express tables

IN Word 2003 there is no such feature. In all the rest, Word 2007, 2010, 2013, they are, and this section is called "Express Tables".
After activating this item, you will have access to ready-made grids with a different design style. Some tables are rendered with black cells, others are rendered with hidden lines, and so on. There are even templates for lists, calendars, and more.

All templates can be edited by the user

This collection is easily replenished.

To complete the collection, you need:
- Create a "table";
- Select the created table;
- Go to "express tables".

After that, the template will be available to the user who added it. The added templates will not be available to others.

6. Tables made up of figures

A very interesting way, but quite unexpected and unusual for many.
Item 3 (method) involves “drawing” a table with a special tabular pencil, and method 6, that is, this one, involves using figures in order to create the required table.

Most often, simple lines and rectangles are used.
It's simple, go to the "Insert" item and select "Shapes", among which find the ones you need.

Important: in this case, to enter text into the cells, you need to right-click and select "Insert Text" or "Add Text".

A table in Word 2007 is created very simply. But many novice users are intimidated when it comes to tables. Let's take a step-by-step look at what you can do with them. After reading the article, you will be a master in the work and design of tables.

The main thing is to learn how to design and format them, and not just create them. Information is often easier to perceive when it is presented in a user-friendly way. Let's consider everything step by step.

How to create tables in Word

First, open the Word editor. At the top of the panel there is an "Insert" tab (Insert in English versions).

There is a table button. You need to click on it, and then a special menu will appear where you can do the following:

• insert table;
• draw a table
• insert express table;
• insert an Excel spreadsheet;
• convert table.

There are many ways to insert a table. For example, the simplest is to select the required number of rows and columns on a special panel. You can do it like this.

How to create tables in Word in other ways? You can also click on the line in the "Insert Table" menu. As a result, a special window with table settings will open.

Here you can specify the number of columns and the number of rows. You can also specify the width of the columns. Enter everything you need, and then click on the "OK" button.

How to draw a table

In addition, you can draw a table. This is the next line on the menu after inserting a table.

By clicking on this item, you will have a brush tool with which you can draw tables. But this method is usually not used, since it is easy to get confused there. Much more efficient to insert as above.

Express table

How to create tables with pre-made templates in Word? Pretty simple. You need to click on the menu item "Express Tables". After that, you will have a whole list of templates.

You can choose any option that you need and like more.

How to merge cells in Word?

When designing tables, you often need to merge cells. For example, when creating a header. To do this is quite simple. Select several cells and press the right mouse button.

And after that, the selected cells will become one. Such actions can be done as many times as you like, until only one cell remains in the table.

You can merge both vertically and horizontally.

Insert Excel spreadsheet

There is an item "Excel Spreadsheet" in the menu. Click there.

As soon as you click there, you will have a ready-made format table in your usual Excel. Moreover, there will be the same sheets as in the Microsoft Excel editor.

You can work there in exactly the same way as in your native editor. The right click will bring up the menu not "Word", but "Excel".

You will work in Excel while being in the Word editor. It is very convenient. After all, that's what it's designed for.

Adding rows and columns

If you want to enlarge your table, you need to mark a cell with the cursor and call up the menu by pressing the right mouse button. There is a special item "insert". By clicking on it, you will open another additional window with other operations.

The menu is very simple, each item speaks for itself. Everyone can figure it out here.

Table Formatting

There is an item "Border" and "Fill". Click there. You will have the following window.

Initially, you will have the "Fields" tab open. You need to go to the "Paper Source" tab. There is an item "Fill". Choose any color you want and click OK.

But you can fill the cap in another simpler way. At the top of the panel there is a button with a bucket for pouring.

You can choose any color. There is a ready-made palette set with different shades. If none is suitable, then you can choose any other by clicking on the "Other colors" button.

How to create tables with ready-made design in Word? To do this, on the top panel, go to the "Designer" tab. It is important that you are in the table at this moment.

As a result, you will see a large number of pre-prepared design options. You can use any. To familiarize yourself, you can move the cursor over these templates, but do not click on them. The table will be transformed, but the changes will not take effect until you click on the selected option.

If you are thinking about how to divide a table in Word, then it is very simple. Move to the desired line and press Ctrl+Shift+Enter. And it will be divided into 2 parts.

Moving a table

Many are wondering how to transfer a table to Word. It is very easy to move it. Stand on any table. You will see a "cross" in the upper left corner. Click on it and don't let go. Then move the mouse cursor to this table to any place you need.

Please note that when you click on this icon, the table is completely selected. It can be moved in another way. It is enough to press Ctrl + X on the keyboard (you will cut the contents) and press Ctrl + V in the desired position.

As a result, all rows and columns will be in the right place.

fb.ru

How to make tables in word

Continuing the theme of working in word, let's look at how to make tables in word. Tables are an integral part of most documents, especially in manufacturing and business areas.

At its core, the table is designed to structure information and process information. For example, in the field of economics, a lot of numbers, indicators, names, quantities are included in tables for easier perception of information.

Let's analyze the basics of creating tables in Word. And I'll give you some helpful advice. Before you make any document that includes tables, you need to sketch out the structure of the page. Take a sheet of paper and mark out the following areas: title, body and what it includes (text, table picture), footer of the page (signature, contact information). Be sure to write a title first, and then create a table. If you immediately close the table, you will not be able to insert a title and you will have to redo everything.

Let's start creating a simple table step by step.

1 step. Open a Word document. Click on the "Insert" tab. Click on the Table tool. We look at the picture:

Here we see several options for inserting a table:

Table constructor. This tool allows you to visually see the number of columns and rows. The disadvantage is that the maximum table size can be 10 columns and 8 rows.

Insert Table... This tool is a table creation wizard where you enter the number of rows and columns manually.

Draw a table. The tool is designed to create a table in a completely visual-manual mode. After selecting this tool, a miniature pencil will appear behind the cursor. By pressing and holding the left mouse button, we draw a diagonal, as a result of which a rectangle will appear. This table will consist of one column and one row. Now, as on plain paper, we draw the necessary rows and columns.

2 step. We select a tool for creating a table with manually writing the number of rows and columns. In my case 5 columns and 5 rows. We look at the picture:

3 step. Let's start editing the table. To do this, move the cursor to the upper right corner. When a cross appears in the box, right-click to open the context menu. We look at the picture:

4 step. Borders and shading. Here we select the type, color and width of the table lines. We can also set the display of lines. We look at the picture:

5 step. In the context menu, select Align Cells. Here we can set content alignment options for the entire table, as well as for individual rows, columns and cells. We look at the picture:

6 step. In the context menu, select the table properties item. Here we set the height and width of the table. There is an alternative way to set the size of the table using the separators on the ruler. We look at the picture:

7 step. After filling the table with content, we align the height of the rows. This item can be skipped. We look at the picture:

8 step. We make additional rows and columns. In the context menu, select Paste. In order to add lines, just place the cursor in the lower right cell and press the Tab button on the keyboard. We look at the picture:

We figured out how to make a table in a Word, and also learned how to edit the main parameters of the table. And I want to remind you once again that you should first write the title, and then insert the table. Also, do not forget about the table content alignment function, just select the entire table and apply the alignment type. For a more presentable appearance use line and column height alignment. Experiment with the type and color of the table to get creative.

And almost forgot. In order to merge several table cells, you need to select these cells and select the "Merge Cells" item in the context menu.

www.osnov-computer.ru

How can you easily draw a table in Word in several ways?

Good day to all, my dear friends and guests of my blog. Today, if you don't mind, we will continue to tinker with the Microsoft Word text editor. Due to the nature of my activity, I often have to deal with him, so I cannot leave him unattended.

And today we will work with tables. Yes. Without this, our business is simply nowhere. But many do not even know how this can be implemented, and even more so in several ways. Therefore, I will tell you how to draw a table in a Word, using several different options and methods. I will do this as usual in office 2013, but if you have 2010, then this article will also be relevant. Ready? Then let's go!

Insert

The first way we will have is the simplest and most classic, namely the usual insertion of a table. Here we do not need any supernatural abilities. You just need to set the number of rows and columns.

style="display:block" data-ad-client="ca-pub-4066320629007052" data-ad-slot="5193769527"

data-ad-format="auto">

Enter the Word and go to the "Insert" menu, then select "Table" and visually choose how your table will look in real time using the squares. If everything suits you, then just press the left mouse button at the desired point. True, this line has a limited number of rows and columns. In this case, another option will help us.

To set a certain number of columns and rows, we need to enter the same section again, only this time select the "Insert Table" item.

We will see a new window where you will be prompted to select the desired number of rows and columns.

Drawing

A fairly convenient way to create a plate is to draw it. That is, here you yourself choose initially how it will look for you. In order to bring this to life, we need in the same paragraph "Insert" - "Table", well, then click on "Draw Table". Your cursor should change to a pencil.

With this pencil we will draw our plate. To do this, we hold down the left mouse button from one edge and move it to the other lower edge, after which we release our rodent.

Now start drawing your vertical lines from where you would like them to go. This will be the division between our columns.

And to top it off, start drawing horizontal lines from beginning to end in the same way so that we have a full-fledged table. By the way, we can lead some lines not from beginning to end, but from any other place, for example, from the second line. In which case, you can always finish what we lack.

other methods

I will briefly cover two other methods, namely the insertion of an excel table and an express table. If we use an excel table, then naturally it will be loaded. This thing is convenient in that you can enjoy all the benefits of excel in a Word document, such as sum cells.

Spreadsheets are simply ready-made templates that will help make your sign more interesting in terms of design. For example, with the help of them you can create a calendar in one click. But these functions are usually used less often.

Other features

If you select a table or part of it, then you will have a new temporary menu in the ribbon, which will be called "Working with Tables". This menu will in turn include two tabs: Layout and Design.

In the "Constructor" we will be able to fill our entire structure or individual cells with any color, in addition, you can choose one of the templates that slightly changes the appearance of your table. Well, at the same time you can change the color and thickness of the borders.

But on the "Layout" I would like to dwell a little more. Here we have an abundance of various functions that will come in handy. For example, if you select "Eraser", then thanks to it you can erase any line inside the table, an entire cell, etc. Sometimes this thing is just necessary. I often use it myself.

In addition, you can add new rows or columns anywhere, even in the middle. To do this, select one of the items: insert above, below, right, left. Although for good, inserting another line can be easier. To do this, just put the cursor at the end of the line after which you want to create a new one.

Another great feature is "Sorting". For example, you can easily sort the values ​​in any column. Let's for the sake of interest, I will write the numbers in the first column out of order and we will have 5, 2, 16, 1, 2, 13. Now I will select this column and click on the "Sort (A-Z)" button.

After that, a new window will appear where you need to select a specific column by which sorting will be performed, as well as a sign (number, date, text). But if you have selected a specific column, then all values ​​will be substituted automatically. Well, then click OK and now everything will be in order.

Sincerely, Dmitry Kostin.

koskomp.ru

How to make a table in Word - A thousand and one ways for all versions

Those who often work with documents a lot will do well to learn how to work with tables in Word. Most of the methods that will be described below work in all versions of Microsoft Word.

In MS Word 2007, 2010 and 2013, it is possible to insert it into the text by simply clicking on the table thumbnail. Their grandfather, Word 2003, also has such a useful feature, though not so extensive.

So, to add a table to the text using its sketch in Word-2007/2010/2013, you need to:

• Go to the "Insert" tab on the top panel of the program window;
• Click on the "Table" button;
• When a thumbnail appears with 10 columns and 8 rows, by simply hovering over the desired number of cells, you can add a grid of the desired configuration to your text.

The process of adding with sketch in MS Word 2007, 2010 and 2013

In Word 2003, this whole process happens a little differently.

There you do not need to go to any tabs - already in the start window of the program on the top panel there is a menu with a thumbnail.

Sketch menu in MS Word 2003

As you can see, there are fewer columns and rows here - 5 and 4, respectively. Therefore, we can say that in this version the ability to create a grid is somewhat limited.

After adding a table, you can edit it - just hover over the lines and borders, click on them, and start moving (the cursor will change its appearance).

Certain cells or even entire columns and rows of the finished table can be deleted.

This is done by selecting an unnecessary fragment and pressing the Delete button on the keyboard. This is true for tables created by any of the methods described here. Let's move on to the next method.

Back to menu

In all versions of Word, the insert window looks the same.

There is one functional difference - Word 2003 has an AutoFormat option. She is responsible for ensuring that the mesh is beautiful and according to the chosen style.

In other, later versions, the program "adjusts" the table to the selected style itself, automatically. By default, standard auto-formatting is used - the table will not have any special elements such as filled cells, columns of different lengths, and the like.

Different happens in different ways. In newer versions (Word 2007, 2010 and 2013) the method is as follows:

• Go to the "Insert" tab;
• Click on "Tables";
• Click the "Insert Table" button.

A window opens in which you need to specify the number of columns and rows. Actually, this window is the same for all versions of Word. We indicate the quantity we need there and click "OK" at the bottom of the window.

Insert window and access to it in Word 2007/2010/2013

In Word 2003, this window is accessed through the "Table" menu. This means that on the top panel you need to click on "Table", then hover over the item "Insert" and in the drop-down list again click on the item "Table".

Accessing the insert window in MS Word 2003

As you can see, the Word 2003 menu has an interesting feature, converting text to a table grid. You can select a piece of text, then click on "Transform" and the text will be placed in an automatically created cell. It is worth saying that in most cases the program creates a table that is not at all what the user wants. Apparently, therefore, this function is no longer present in new versions.

back to menu

This method also works in all versions in the same way. In Word 2007, 2010 and 2013, the desired button is accessed through the "Insert" tab and the "Tables" button, and in Word 2003 through the "Tables" menu. The menu we need is called "Draw Table". After clicking on it, the cursor turns into a pencil. By moving it appropriately, you can quickly and easily draw the desired kind of grid.

Accessing the table drawing tool

The advantage of this method is that the user can create a grid of any desired configuration. The cells in it can be of different sizes, the cells themselves can be an arbitrary number and they can be arranged as you like.

When working with documents in MS Word, you may often need to create a table inside which you need to place certain data. The software product from Microsoft provides very wide opportunities for creating and editing tables, having in its arsenal a large set of tools for working with them.

In this article, we will talk about how to create a table in Word, as well as what and how you can do in it and with it.

To insert a base (template) table into a document, do the following:

1. Click the left mouse button in the place where you want to add it, go to the tab "Insert" where you need to click on the button "Table".

2. Select the desired number of rows and columns by moving the mouse over the table image in the drop-down menu.

3. You will see a table of selected sizes.

At the same time as you create a table, a tab will appear on the Word control panel. "Working with tables" which has many useful tools.

Using the presented tools, you can change the style of the table, add or remove borders, frame, fill, insert various formulas.

Insert a table with custom width

Creating tables in Word does not have to be limited to the standard options available by default. Sometimes, after all, you need to create a table of a larger size than the finished layout allows you to do.

1. Press the button "Table" in the "Insert" tab .

2. Select an item "Insert Table".

3. A small window will appear in front of you, in which you can and should set the desired parameters for the table.

4. Specify the required number of rows and columns, in addition, you need to select the option to select the width of the columns.

• Constant: default is set to "Auto", that is, the width of the columns will change automatically.
• By content: Narrow columns will initially be created, the width of which will increase as content is added.
• Window width: The table will automatically change its width to match the size of the document you are working with.

5. If you need the tables that you will create in the future to look exactly like this one, check the box next to "Default for new tables".

Creating a table according to your own parameters

This method is recommended for use in cases where you need a more detailed setting of the table parameters, its rows and columns. The basic grid does not provide such wide possibilities, therefore it is better to draw a table in Word on your own in size using the appropriate command.

Selecting an item "Draw Table", you will see the mouse pointer change to a pencil.

1. Set the borders of the table by drawing a rectangle.

2. Now draw rows and columns inside it, drawing the corresponding lines with a pencil.

3. If you want to delete some element of the table, go to the tab "Layout" ("Working with tables"), expand the button menu "Delete" and select what you want to remove (row, column or entire table).

4. If you need to delete a specific line, in the same tab, select the tool "Eraser" and click them on the line that you do not need.

Create a table from text

While working with documents, sometimes for greater clarity, it is required to present paragraphs, lists, or any other text in the form of a table. The built-in tools in Word easily allow you to convert text into a table.

Before starting the conversion, you must enable the display of paragraph characters by pressing the corresponding key in the tab "Home" on the control panel.

1. To indicate where to split, insert delimiters—this can be commas, tabs, or semicolons.

2. Using paragraph marks, indicate where lines should begin, and then highlight the text that you want to present in a table.

Note: In the example shown below, tabs (arrowheads) represent table columns, and paragraph marks represent rows. Therefore, this table will 6 columns and 3 lines.

3. Go to the tab "Insert", click on the icon "Table" and select "Convert to Table".

4. You will see a small dialog box in which you can set the desired parameters for the table.

Make sure that the number indicated in paragraph "Number of columns" matches what you need.

Select a table type in the section "AutoFit Columns".

Note: MS Word automatically selects the width for the columns of the table, but if you need to set your own parameters, in the field "constant" enter the desired value. Autofit option " by content" will change the width of the columns to match the size of the text.

Parameter "window width" allows you to automatically resize the table when the width of the available space changes (for example, in view mode "web document" or in landscape orientation).

Specify the separator character that you used in the text by selecting it in the section "Text Separator"(in the case of our example, this is a tab character).

After you click on the button "OK", the selected text will be converted to a table. This is how it should look like.

The dimensions of the table can be adjusted if necessary (depending on which option you selected in the presets).

That's all, now you know how to make and change a table in Word 2003, 2007, 2010-2016, as well as how to make a table from text. In many cases, this is not only convenient, but really necessary. We hope this article was useful for you and thanks to it you will be able to work more productively, more comfortably and simply faster with documents in MS Word.

The Microsoft Excel program is convenient for drawing up tables and making calculations. A workspace is a set of cells that can be filled with data. Subsequently - to format, use to build graphs, charts, summary reports.

Working in Excel with tables for beginners may seem daunting at first glance. It differs significantly from the principles of constructing tables in Word. But we'll start small: creating and formatting a table. And at the end of the article, you will already understand that you can’t imagine a better tool for creating tables than Excel.

How to Create a Table in Excel for Dummies

Working with spreadsheets in Excel for dummies is not rushed. There are many ways to create a table, and for specific purposes, each method has its own advantages. Therefore, first visually assess the situation.

Look carefully at the spreadsheet worksheet:

This is a set of cells in columns and rows. Basically a table. The columns are marked with Latin letters. Rows are numbers. If we print this sheet, we get a blank page. Without any boundaries.

First, let's learn how to work with cells, rows and columns.



How to select a column and row

To select the entire column, click on its name (Latin letter) with the left mouse button.

To select a line - by line name (by number).

To select multiple columns or rows, left-click on the title, hold and drag.

To select a column using hot keys, place the cursor in any cell of the desired column - press Ctrl + space. To select a line - Shift + Space.

How to change cell borders

If the information does not fit when filling out the table, you need to change the borders of the cells:

To change the width of columns and the height of rows at once in a certain range, select an area, increase 1 column / row (move manually) - the size of all selected columns and rows will automatically change.

Note. To return to the previous size, you can click the "Cancel" button or the hot key combination CTRL + Z. But it works when you do it right away. Later will not help.

To return lines to their original borders, open the tool menu: "Home" - "Format" and select "Autofit Line Height"

For columns, this method is not relevant. Click "Format" - "Default Width". Let's remember this number. We select any cell in the column whose borders need to be "returned". Again, "Format" - "Column Width" - enter the indicator specified by the program (as a rule, this is 8.43 - the number of characters in the Calibri font with a size of 11 points). OK.

How to insert a column or row

Select the column/row to the right/below where you want to insert the new range. That is, the column will appear to the left of the selected cell. And the line is above.

Right-click - select "Paste" in the drop-down menu (or press the hot key combination CTRL + SHIFT + "=").

Select the column and click OK.

Advice. To quickly insert a column, select the column at the desired location and press CTRL+SHIFT+"=".

All these skills will come in handy when creating a spreadsheet in Excel. We will have to expand the boundaries, add rows / columns in the process.

Step by step creation of a table with formulas

Now, when printing, the borders of columns and rows will be visible.

Using the Font menu, you can format Excel spreadsheet data as you would in Word.

Change, for example, the font size, make the header “bold”. You can set the text to the center, assign hyphenation, etc.

How to create a table in Excel: step by step instructions

The simplest way to create tables is already known. But in Excel there is a more convenient option (in terms of subsequent formatting, working with data).

Let's make a "smart" (dynamic) table:

Note. You can go the other way - first select a range of cells, and then click the "Table" button.

Now enter the necessary data into the finished frame. If you need an additional column, put the cursor in the cell intended for the title. Enter a name and press ENTER. The range will automatically expand.

If you need to increase the number of lines, hook in the lower right corner of the autocomplete marker and drag it down.

How to work with a table in Excel

With the release of new versions of the program, work in Excel with tables has become more interesting and dynamic. When a smart table is formed on the sheet, the tool "Working with tables" - "Designer" becomes available.

Here we can name the table, change the size.

Various styles are available, the ability to convert the table to a regular range or summary report.

Features of dynamic spreadsheets MS Excel are huge. Let's start with basic data entry and autocomplete skills:

If you click on the arrow to the right of each header subheading, then we will get access to additional tools for working with table data.

Sometimes the user has to work with huge tables. To see the results, you need to scroll through more than one thousand lines. Deleting rows is not an option (the data will be needed later). But you can hide. For this purpose, use numerical filters (picture above). Uncheck the boxes next to the values ​​that should be hidden.