This question arises if you stumble on the Internet on some data presented in the form of a table, and want to save them in format Microsoft Word. (Perhaps previously edited). If you just open the saved HTML page in Word and then try to save it "how document Word."You will have the initial page format that is hardly acceptable as an independent document, and it is impassable from all over - tortured.
The simplest thing is to transfer the table through the clipboard. This can be done directly from any browser or after saving the page in the disk file, and then opening it in Word. In the last option, it is easier to highlight exactly the table, without capturing no extra elements, - when you hover the cursor to the table, all versions of Word after XP are shown next to the table in the left upper corner The icon, when you click on which the entire table is highlighted (you can also click on the key combination
You can change the type of frame such a table by choosing a new style for it. In Word 2003 This is done through the menu with a non-obvious name Table | Automatic table and subsequent choice from a list of one of the frame styles (the simplest is called Table 1 mesh). In the new versions it is even easier, because several styles of the table are glowing directly on the Constructor tab, and the remaining few dozen are available through the bottom button to the right of them (the cursor indicates on fig. C.3). Including there there is also the simplest table with thin black lines.
Fig. C.3. Office 2007 Tables Styles
This is usually not enough - you have to change the font, to ask him a black color, take a hyperlinks (colored fonts when printing on the usual black and white laser printer will be displayed as ugly shades of gray in a small mesh), format as paragraphs. But it is still incomparably easier than to create such a table from scratch by carrying its cell over the cell.
PDF -designed as a format for presenting books and magazines on computers. In everyday life and business is most often used to create, so to speak unchanged documents. For example, you created a table with tariffs or a contract and you need to send it to the client so that the client does not change anything there is best saved in PDF. After all, Excel can be easily, even if you are protected by a password.
Xml - Designed as a language convenient for processing documents with programs and convenient and understandable to work with a person's document. You can say the format specifically created for the Internet. Very often through such a universal language exchanges between two programs. For example, automatic unloading from Access and load in 1C.
A complete list of available formats is shown in the picture:
As shown earlier, to save Excel in PDF you need to go to the menu, select Save as - Next PDF or XPS (in the first picture).
XPS is also a special format to protect the content of the document, you can say an electronic sheet of paper.
Excel in JPEG or PNG
For the picture format there is no special save function, but it is quite simple to make Windows tools.
First of all, almost on each keyboard there is a special PRINT SCREEN button (Screen Screenshot), it is right than F12. It is written on it most often something like PRTSCN or PRT SC.
After pressing this button, the image image is saved and you can insert it anywhere: in the letter, in Word or in the Paint program. From Paint can already be saved in JPEG and PNG.
If you want to copy only the active window, press Alt + PRTSCN - described in more detail.
It is even easier to find the scissors program (starting in Windows 7 built). Start - All Programs - Standard There are these whiskers - Now you can highlight any fragment and immediately save in the desired figure format. Conveniently - I recommend those who do not use.
If you have Mac - for the screenshot, press Shift + Command + 3
Sust Excel in XML
Again, as shown in the big picture with the left mouse button on Save how - next to the save window in the window of the file type is looking for XML data (* .xml).
Share our article in your social networks:If an error occurs when saving, save the XML 2003 table in the format, also is listed. Most often it happens because XML Document may not perceive more than 65 thousand lines, and the 2003 format cuts them off!
In this lesson, you will learn how to use the Save and save commands as you will learn how to save a book in compatibility mode with Excel 97-2003and how to save a book in format PDF..
Whenever you create a new document in Excel, you need to know how to save it for further access and editing. Excel allows you to save documents in several ways.
To use the Save Team as:
To use the Save command:
If you save the book for the first time and select Save, then the Save As dialog box appears.
To take advantage of autosogery:
Excel automatically saves your books while working on a temporary folder. If you forget to save changes or the Excel program will have any failure, then you can restore the autoscit file.
- Open the book that has been closed without saving before.
- Click the File tab and select Details in the pop-up menu.
- If the auto stops of your book exist, they will be shown in the section Version. Click on the file to open it.
- Under the tape of the book will appear yellow warning. To restore this version of the book, click Restore, and then OK.
By default, Excel automatically saves the book every 10 minutes. If you work with a table less than 10 minutes and closed without saving or fails, then Excel will not have time to make auto storage.
If you do not see the file that are looking for, or you are looking for a file that has no previous versions, you can view all auto stop files by clicking the version control button and selecting Restore the unsaved books in the drop-down menu.
To save the book in the format Book Excel 97-2003:
To save the file in PDF format:
Saving your book in Adobe Acrobat Document format, which is called PDF, can be especially useful if recipients do not have and do not work in Excel. Saving in PDF format enable recipients to see the contents of the book, although they will not be able to edit it.
By default, Excel retains only an active sheet. If you have several sheets in your book, and you want to save them all in one PDF file, then press the Parameters button. The Parameters dialog box appears. Select All Book and click OK.
XLSX and XLS formats- main toolbar Save in other formats ... File>Save document as>Workbook Microsoft Excel. 97-2003 .
Council. Save>XLSX Dialogue Settings (menu Service>Settings ...).
Registration of document
The selection of the design mode depends on how you use the created document hereinafter ::
- Formatted text
In the received document, the font is stored and the size of the font, partitioning to paragraphs, but the location of the objects on the page will not be saved arctic intervals. Thus, a solid text with alignment to the left edge will be obtained. For text, in which the reading order on the right left, the alignment will be on the right edge.
Comment. Any text with vertical orientation in this mode will be displayed horizontally.
- Simple text
In this mode, text formatting will not be saved.
Text
- Save numeric data in "Figures" format
Indicates that when the recognized text is saved in XLS format, the numbers will be saved in the "Figures" format. This format in Excel is used to execute arithmetic operations Over cells containing numbers.
- Save footers
Check this option if you want the text of the footer to be saved. If this option is disabled, the text of the footer will not be saved.
- Create a separate table for each page (XLSX only)
Quality of pictures
When saving in XLSX format, you can also save illustrations. If recognized text contains a large number of Illustrations, the size of the destination file can be very large. The quality of the pictures and the size of the received file depends on the selected value in the drop-down list Quality of pictures.
Tip:
- In order to set pictures save settings, select item. Custom .... In the opened dialog box Custom settings Select the required values \u200b\u200band click OK.
- If you do not want to save illustrations in recognized text, make sure the option Save pictures (XLSX only) Not marked.
CSV format
- Click on the arrow near the Resist button on the main toolbar and select Save Format from the list. If the desired format is not in the list, select Save in other formats ..., and in the saving dialog that opens, select the desired format. You can also save documents using the menu command. File>Save document as>Document CSV..
Council. If necessary, you can configure additional save options on the tab. Save>CSV. Dialogue Settings (menu Service>Settings ...).
This tab contains the following groups of settings:
Text saving options
- Ignore text outside table
Indicates that only tables will be saved to the file.
- Share Pages Symbol End Page (# 12)
Indicates that when saving recognized text in CSV format, the division on the pages will be the same as in the source document.
- Delimiter
Specifies a character that will divide the data columns in the CSV format file.
Encoding
Program ABBYY FineReader. Automatically selects the code page. If you want to change the codes, select the desired value in the drop-down list in the section Encoding.
Tools for working with tables in MS Word are implemented very convenient. This, of course, not Excel, however, create and modify the tables in this program, and more often, and not required.
So, for example, copy the finished table in the Word and insert it into another place of the document, and even in a completely different program, will not be difficult. The task is noticeably complicated if you want to copy the table from the site and paste it into Word. It is about how to do it, we will tell in this article.
The tables presented on various sites on the Internet may noticeably differ not only visually, but also by their structure. Consequently, after inserting in Word, they can also look different. And yet, in the presence of a so-called skeleton filled with data, which are divided into columns and strings, you can always give the table desired view. But first, of course, you need to insert it into the document.
1. Go to the site from which you need to copy the table and select it.
- Tip:Start allocating the table from its first cell located in the upper left corner, that is, where it is originated by its first column and line. To complete the selection of the table is necessary at the diagonally opposite corner - the right lower.
2. Copy the selected table. To do this click "Ctrl + C" Or right-click on the selected table and select "Copy".
3. Open the Word document to which you need to insert this table, and click the left mouse button in the place where it should be located.
4. Insert the table by pressing "Ctrl + V" Or selecting item "Paste" in context menu (called by one click right-click).
5. The table will be inserted into the document in almost the same form in which it was on the site.
Note: Be prepared for the fact that the "cap" table can move to the side. This is due to the fact that it can be added on the site as separate element. So, in our case, it is just text above the table, not the cell.
In addition, if there are elements in cells that do not support Word, they will not be inserted at all in the table. In our example, there were mugs from the "Form" column. Also, the symbolism command "trimmed".
Changing the appearance of the table
Looking ahead, let's say that the table copied from the site and inserted into Word in our example is quite complicated, since in addition to text there are also graphic elements, there are no visual column separators, but there are only rows. Most tables will have to be tinted much less, but on such a difficult example, you exactly learn how to give any table "human" view.
To make it easier for you to understand how and what operations we will do below, be sure to read our article on the creation of tables and work with them.
Alignment size
The first thing that can and should be done is to adjust the sizes of the table. Just click on its upper right corner to display the "working" area, and then pull the marker located in the lower right corner.
Also, if necessary, you can always move the table to any place page or document. To do this, click on a square with a plus card inside, which is in the upper left corner of the table, and pull it in the desired direction.
Display of table borders
If in your table, as in our example, the boundaries of strings / columns / cells are hidden, for greater convenience, it is necessary to turn on their display. To do this, follow these steps:
1. Highlight the table by clicking on the "plus card" in its upper right corner.
2. In the tab "The main" in a group "Paragraph" Click on the button "Borders" and select "All borders".
3. The borders of the table will be visible, now combine and align a separate hat with the main table will be much easier.
If necessary, you can always hide the borders of the table by making them completely invisible. On how to do it, you can learn from our material:
As you can see, there are empty columns in our table, as well as missing cells. It all needs to be corrected, but before we align the cap.
Leveling caps
You can align the table with a table in our case manually, that is, you need to cut the text from one cell and insert it to another in which it is on the site. Since the "Form" column was not copied with us, we just delete it.
To do this, click on the empty column right mouse button, in the top menu, click "Delete" and select "Delete column".
In our example of empty columns two, but in the header of one of them there is a text that should be completely in another column. Actually, it's time to move to the alignment of the header. If you have cells (columns) in the header as much as in the entire table, simply copy it from one cell and move to the one where it is on the site. Repeat a similar action for the rest of the cells.
- Tip: Use to highlight the text the mouse, drawing attention to the fact that only the text is allocated, from the first to the last letter of the word or words, but not the cell itself.
In order to cut the word from the same cell, press the keys. "Ctrl + X"To insert it, click in the cell, in which it needs to be inserted, and click "Ctrl + V".
If for some reason you can not insert the text in empty cells, You can convert text to the table (only if the cap is not an element of the table). However, it will be more convenient to create a single-line table with the same number of columns as in the one that you copied, and enter the corresponding names from the cap in each cell. How to create a table, you can read in our article (reference above).
Two separate tables you have created a single-line and basic, copied from the site, you need to combine. To do this, use our instructions.
Directly in our example in order to align the header, and at the same time also remove the empty column, you must first separate the cap from the table, perform the necessary manipulations from each of its parts, and then combine these tables again.
Before the combination, the two of our tables look like this:
As you can see, the number of columns is still different, and therefore, it is not necessary to combine the two tables normally so far. In our case, we will proceed as follows.
1. Remove the "Form" cell in the first table.
2. Add at the beginning of the same table the cell in which it will be indicated "No.", since the first column of the second table there is a numbering. We also add a cell with the name "Team", which is not in the header.
3. Remove the column with the symbols of the teams, which, firstly, was cope with the site, secondly, we simply do not need.
4. Now the number of columns in both tables coincides, it means that we can combine them.
5. Ready - a table copied from the site has a completely adequate view that you can then change as you like. Our lessons will help you with this.
Now you know how to copy the table from the site and insert it into Word. In addition, from this article you also learned how to cope with all the difficulties of changing and editing, with which you can sometimes encounter. Recall that the table in our example was really difficult, in terms of its execution. Fortunately, most of the tables do not cause such problems.
