Most often today, tables are created, stored and distributed in the format of the Microsoft Office Excel spreadsheet editor. A little less often the word processor Microsoft Office Word is used for these purposes. Both applications make it easy to print a spreadsheet, having previously selected the best option for its placement on the sheet.
Necessary
- - table editor Microsoft Office Excel 2007 or 2010;
- - word processor Microsoft Office Word 2007 or 2010.
Instructions
Step 1
If, in addition to the table in the document loaded into the word processor Microsoft Word, there is also text or any other elements that do not need to be printed, it is better to temporarily transfer the table to a separate document. To do this, first copy the object - move the cursor to the upper left corner, click on the small square icon with a plus and press the key combination Ctrl + C. Then create a new document (Ctrl + N) and paste the table (Ctrl + V).
Step 2
If you are using the Word 2010 version of the word processor, click the File button and select the Print section. To the right of the list of commands in the menu is a column with print settings, and even to the right is a preview picture of a printed sheet with a table. Use the settings to select the most suitable printing options - select the size of the margins from the edge of the sheet, set the portrait or landscape orientation, adjust the dimensions to the width of the paper being used, etc. All changes made will be displayed in the preview picture. When you're done, click the big Print button at the very top of the settings column.
Step 3
In Word 2007, you can see all of these settings in one place in the Page Setup dialog box. To call it, go to the "Page Layout" tab, open the "Fields" drop-down list and select the "Custom Fields" line. The 2010 version also has this option to access the print settings. After setting all the parameters, click the OK button and call the send to print dialog using the Ctrl + P keys.
Step 4
The procedure for printing tables from Microsoft Excel differs little from the one already described. There is a useful addition to the preview picture of the Excel 2010 printed worksheet - the button "Show Fields" is placed in the lower right corner. Click on it, and you will be able not only to drag horizontal and vertical margins on the printed page with the mouse, but also to adjust the width of the columns of the print layout in the same way.
Step 5
As with a word processor, the Page Layout tab of the menu in Excel 2007 and 2010 has a Fields drop-down list with a Custom Fields item that brings up a separate settings window. The same settings as in Word are split into four tabs instead of three. From additions - on the "Sheet" tab, you can set the sequence of output of three or more tables on one printed sheet (top to bottom or left to right).
