Advice 1: How to convert Excel to Word

MS Excel is a very useful tool for performing calculations and giving the tabular data. However, in the preparation of the reporting documentation you often need to present tabular information in Word format. It is sometimes necessary to translate not only the direct content of the information but the formatting of the documents.

How to convert Excel to Word
You will need
  • MS Word, MS Excel, computer.
Instruction
1
To translate information from a file saved in Excel format in Word, open a spreadsheet file, highlight it in the desired cells, click the right mouse button and select "Copy". Then, start MS Word, create a blank document (usually created automatically) and insert the copied Excel snippet. Thus, in the created document will be needed to represent the table number of columns, and each row of Excel spreadsheet will be presented as a separate line in the document.
This method is the most simple, however, it lost the original formatting of the document. In addition, further editing be created in Word pseudotable will be very difficult.
2
Below tableprepared in Excel, in Word looked almost as paste the copied information into the previously prepared table. To do this, count how many columns and rows the original table has. Then, in Word, select the menu item "table" and "Paste". Specify in the pop-up window number of columns and rows and click confirm. All the rest (cosmetic) settings can be carried out later.

Now, as in the first case, copy the desired part of the table. Then, with the mouse select the entire table created in Word, click the right mouse button and select "Paste". All data from the source table will be distributed carefully on the empty cells of a Word table. Using formatting tools Word, fix incorrectly placed parts of the table.
This method is optimal for the preparation of the final documentation, however, does not allow to preserve the formulas that would hinder the subsequent resampling of the data.
3
To copy a table from Excel, including formulas and design use is not easy, and "special" insert. This will also copy the necessary fragment of the table, then select from the Word menu items "edit" - "paste Special". Then, select in the dialog the string "Microsoft Excel Worksheet (the object)".
Note the position of the point in the lines "Insert" and "Link". For the preparation of standard documentation leave this pointer to the string "Insert".
If you need that information in the Word document is changed automatically depending on the data in the Excel spreadsheet, select "Link". However, it is necessary to ensure the Word file is continuous access to the Excel file.
Note
As file word convert to JPG? Press print key, then open the paint program, on the edit menu (or edit) click insert, cut right, make a new file in the same way and save as jpg.
Useful advice
The graphic file can be saved in any format including jpg. If necessary, repeat the operation several times on different pages of the document. The second way to translate pdf to jpg — Universal Document Converter, which can convert pages of a PDF document to jpg.

Advice 2: How to save Excel worksheet

Each sheet in the spreadsheet program Microsoft Office Excel contains a workspace for creating spreadsheets. The combination of the sheets is a book that is kept in a single file. Each file can have from one to 255 sheets document. The page of the book is an absolutely independent part of the document and allows the input of information, its processing and editing, but in spite of this, selecting save worksheetas separate from the workbook in Microsoft Excel is not provided.
How to save Excel worksheet
Instruction
1
Select sheet spreadsheet in a separate document and save it as a book, consisting of only one sheetbut if you want to save only one sheet of several. To do this, start the table editor, and then load the workbook that contains, among others, and the sheetthat you are interested in. Search dialog and open a file in Microsoft Excel, you can call standard for the majority of applications by a combination of hot keys ctrl + o.
2
Then right-click the tab for the desired sheetand in the lower left corner of the window the table editor. In the context menu select "Move/copy..." and the program will display a small window with three controls. At the top of them (drop-down list, select "new book". After that, the list of the sheets is placed below the window will be cleared, so there is nothing to choose not required. Check the box "Create a copy" to the original allocated in a separate document sheetand remains in this book. Then click "OK" and Excel will create a new document, which will contain only a copy of one of your chosen sheet. The new books program will make the active document.
3
Save the newly created workbook. The save dialog of the document can be accessed by pressing ctrl + s or by selecting the appropriate item in the menu reveal click on the big round button in the upper left corner of the window the table editor.
Note
Please note that the selected sheet can contain formulas that use data from other worksheets in the workbook. In this case, the separately stored table, deprived of the sources of the data may display invalid values.

Advice 3: As in Excel to copy a table

The copy operation table in Excel consists of three stages: the allocation table, copy, and paste it to a word processing document. There are three ways to perform these actions via the context menu with the keyboard or using the toolbar.
As in Excel to copy a table
Instruction
1
Highlight the table in Excel. To do this, click once between the designations of rows and columns or put the cursor on the first top cell, hold down the left mouse button, move the cursor down and across the entire table, so the cells are selected.
2
To copy the table in Excel: place the cursor on the selected table. Click the right mouse button. In the context menu select "copy" or on the keyboard simultaneously press Ctrl+insert. To copy the table by using the main menu on the toolbar, click on "edit" and click "copy". The boundaries of the copied table part take the form of a running snake. After you insert table in the right place, the snake disappears, the software allows you to paste the table as many times as you need.
3
Open the text document you want to paste the copied table Excel.
4
Install the mouse cursor where you need a table in your document.
5
Click the right mouse button and from the appearing context menu, click "paste". Or paste using Shift+insert. It can also be done via menu "edit" activate the command "paste".
6
If you are working in a text editor, it will be easier to create a table in Exceland then copy it into the document as desired. Especially because Excel lets you perform calculations without a calculator or to quickly and easily copy the cells and their contents.
Note
The allocation of a snake when copying Excel tables will not disappear until you complete the operation. To do this, press Esc or remove the highlight by double-clicking on the table.

Advice 4: In Word insert sheet

While writing large amount of text is the need to insert additional information in the middle of the current document. Or when you make - add the cover page. For implementation of these actions use the function insert a new worksheet.
In Word insert sheet
You will need
  • - Word (Microsoft Office);
  • - the original document.
Instruction
1
Open the source document in a format Word. If you haven't already, open the program via the shortcut on the desktop. Type the text you want.
2
Determine the location in the document where you want to add a blank page. Position the cursor at the insertion point. Be careful: a blank page is formed in the place which you defined the cursor. In case it is installed in the middle of the page, the text will be broken.
3
In the menu, select the Insert tab. In the opened functions, please refer to the first "Page". Use the pointer down to open additional opportunities. Select "Blank page". At the specified place will be added a new clean sheet.
4
If you want to add to the already created document title page with the original data and use the tab "Pages". Additional features select the "Title page". It will always be inserted at the beginning of the document, regardless of the current cursor location.
5
Starting with Office Word 2007, you will be offered templates for the title page. Select the most appropriate design to the current document. Replace the template text to your own. If you do not like the selected cover page, use the commands "Insert > Pages > Cover page > Remove current cover page". Replace the deleted page with a more suitable one.
6
When you insert a cover page, be careful. When you do a "Title page", then it replaces the existing one. A document created in an earlier version of Word (before 2007) does not support template cover page Word 2007 and later.
7
To know the version of Word you can. Right-click on the program shortcut on the desktop. Select "Properties". In the opened window you will see the version of Office installed on your computer.
Is the advice useful?
Search