Good afternoon, comrades! I'll tell you a story from my practice. It was precisely this that formed the basis for writing this article.
In the middle of the day, I received a call from a colleague from the accounting department and, as it seemed to me then, the simplest question: “How can I transfer a table from Excel to Word, but so that everything fits on one page and then can be edited?” Then I thought that my colleague was tired, because she had never asked such “simple” questions before.
We have:
- an Excel table that needs to be edited in Word;
- unloading was carried out from 1C using standard means;
- The table does not want to fit onto the sheet as it should.
Answer: “Command “Copy”, go to document, command “Paste”. If it doesn’t help, go to the “Insert” tab, “Table” button, then “Excel Table”, insert your data into the area that appears, if the area is small, stretch it. If you want it to just be pasted, you can select the table in Excel, click on the triangle after the “Copy” button and select “Copy as picture”, go to Word, paste.”
Indeed, in most cases these two methods will help. As always, there is one “But”. If the table is small. I'll demonstrate.
We see that actions with the clipboard are simple and commonplace. But, as was written earlier, we must check what will happen if we insert a complex table, especially one prepared in another program?
For this we need big table in Excel. I won’t post it in full in the article; the file with the example will be in the links.
Now we select it, copy it, go to Word and paste it. The picture will be next.
Even if you reduce the margins, the picture will remain the same - the document will not fit on the page. Our actions:
- select the table inserted into Word;
- go to the “Layout” tab, in the “Cell Size” button block, click “Auto-fit”;
- select the “Auto-select by content” value.
Let's get what we need.
We dealt with his tables. The thing, of course, is good and necessary, but sometimes very naughty. In this article I will try to describe the main points that will allow you to avoid stepping on the rake that you encounter when working with tables.
When working with the width of any column, make sure that any part of the table is not allocated as a block. Otherwise Word editor will think that you are changing only the range allocated in the block and will skew the entire table.
It happens that when inserting information, the right side of the Word table flies beyond the visible limits of the sheet. In this case, you need to reduce the width of the expanded column. This can be done using the column tow marker if it is visible on the ruler. If the marker is not visible, then click right button mouse in this column opens a window Table properties, in which on the tab Column in field Width a certain size of 3-4 cm is indicated. After this, the column will decrease to the specified dimensions and should be more carefully trimmed.
If text data is placed in the rows of a table, then the rows often have different heights, which spoils appearance. To make them the same, you should select the rows down from the table header (otherwise it will also fall under alignment) and select Working with tables – Layout – Align row heights.
When the table Word document is very large and is placed on several sheets, it is advisable to display its title at the beginning of each sheet of the table. This improves the perception of the document and its readability. Everything is simple here. To do this, you can go to the tab on the menu bar Working with Tables – Layout – button Repeat header lines. You can also right-click in the table header row and in the window Table properties on the tab Line check the option Repeat as heading on every page.
When placing numeric information in the rows of a table, you may find that there are more characters in the column headers than in the rows. To avoid making the columns wide because of this, the text in the column headings can be positioned vertically (sideways). To do this, select the cells in which you want to expand the text and use the button - Text direction, which is located on the tab Working with Tables – Layout – region Alignment.
Often there is a need to insert a table (for example, from a Word or Excel document) onto a website page. However, the table is not always displayed correctly. Below are the main problems that arise when inserting tables: frames disappear, the table goes beyond the page. How your table will look and behave depends on the design theme you choose.
Table frame
Some themes have their own table styles that style the tables differently (the styles determine the appearance of elements), so the table frame may not appear on your site page.
The table below shows which themes do and do not display table borders.
Subject | External borders |
Horizontal borders |
Vertical borders |
Coraline | There is | There is | No |
Twenty Eleven | No | There is | No |
Twenty Twelve | No | There is | No |
Sunspot | There is | There is | No |
Riddle | No | No | No |
Quintus | There is | There is | There is |
Pilcrow | There is | There is | There is |
Cheer | No | No | No |
Bouquet | There is | There is | No |
Sundance | No | There is | No |
When inserting tables from office Word programs and Excel WordPress removes almost all table formatting, even down to displaying frames.
If the theme supports displaying a table frame, then you can manually add the border attribute in the html code, which is responsible for the thickness of the table frame.
To do this, after inserting the table into the page, you need to go to the Text tab (page code editing mode), then find the tags
1px is the width of the frame.
#808080 — color number.
Code for a sign with a frame, you can use it as a blank:
To add or remove columns and rows, use the Table button on the toolbar.
Table width
What to do if the table spreads, covering the side column and going beyond the page?
1. In edit mode in the page attributes, change the base template to a full-width template, without a side column. And it will be more convenient for users to watch, and it will be displayed neatly.
2. If the table still does not fit on the page, then edit the width of the source table (in your document).
3. You can also change the width of the table directly in the page code. The width is determined by the width attribute; the attribute value can be set in percentages, pixels, and also with the auto parameter, it adjusts the width of the table to the width of the topic column.
To do this, after inserting the table into the page, you need to go to the Text tab (page code editing mode), find the tag