How to print a spreadsheet in excel
Before printing the tables, you must set the page parameters using the Page Settings command of the File menu . The page insert (fig.39) is used to set the orientation and size of the paper, image scale and print quality. In the Orientation frame, the sheet orientation is set:
portrait - vertical arrangement of a sheet of paper;
Customize text: by default, if we enter text into a cell and it doesn’t fit, use adjacent cells to display the entered content, because if we activate this option, the contents of the cell should appear exclusively in it, for that it will increase the row height and the contents will be displayed in several lines inside the cell.
Reduce to match: if we activate this option, the font size of the cell will be reduced until its contents are displayed in the cell. Merge cells. When this option is activated, the selected cells will be merged into one. From text: Allows you to change the order of the contents of the cell. It is used for languages that have a reading order other than ours, for example, Arabic, Hebrew, etc.
Landscape - horizontal layout.
If the set switch is turned on , the table will be printed at the scale indicated in the field to the right (without changing the size of the sheet on the screen).
If the switch is placed no more than on , the table or selected area will be reduced so as to fit on the number of pages indicated in the page width and page height .
On the Styles tab, we find three parameters that give style to a table, a cell, or a custom format setting. These formats define the data of the selected range and automatically apply the format on the cells. Select a range of cells to apply the format.
Select the Format as Table option that appears in the Style Options group on the Start tab. Select the specified format in the gallery that you want to apply. You want to print a table on a certain number of pages. You can do this in various ways without cutting the spreadsheet, which can make it difficult to read.
In the Paper Size field, the paper size is selected, and in the Print Quality field, the resolution of the printer is selected.
To set the page margins, select the Fields tab and in the upper , lower , left, and right fields, enter the field values. In the fields of the header and footer, select the distance from the top edge of the sheet to header and the bottom edge of the sheet to the footer, respectively.
Want to know more?
In the Layout view, you see that one column in this table moves past the page. As a result, only six pages were created. However, you want to print the entire spreadsheet on three pages. There are several ways to do this without reducing the size of the spreadsheet, which may affect its readability.
The method used depends on the size of the spreadsheet and the desired final rendering. For example, you can customize the worksheet fields. Click the Layout tab, click Fields, and then click Narrow. The page on the right is grayed out, which means that it does not contain any data and will not be printed.
To enter headers and footers, use the Footer Insert . The content of the header or footer is selected in the list fields of the header and footer , or entered after pressing the buttons Create Header and Create Footer .
After setting all the parameters in the Page Parameters window, click the OK button.
Now the entire worksheet will be printed at a maximum of three pages. To print the entire spreadsheet on three pages, you can also change the orientation of the spreadsheet page. On the Page Settings tab, select Orientation and Landscape.
So the entire worksheet is now printed with a maximum size of 3 pages. You can also use a combination of page orientation and paper size to fit a three-page spreadsheet. On the Layout tab, select Orientation, and click Landscape. You still get six pages.
To view the table before printing, use the Preview command of the File menu or the button. In this mode, in order to enlarge the image, you should move the mouse pointer, which will look like a magnifying glass, on the fragment of interest and click the mouse button. The next click of the mouse button takes away the image. You can exit the preview mode using the Close button or the Esc key .
Click "Size" and then "Right." The entire spreadsheet will now be printed at a maximum of three pages. You can also reduce the size of the spreadsheet to fit 3 pages. But be careful, because it may affect the readability of the spreadsheet.
You can use the page break mode to customize the printing behavior of the spreadsheet. Click on the "View" tab, click "Page Break Mode". The dotted line indicates an automatic page break. Mouse over it, left click and hold it.
To print the table, select the Print command from the File menu . In the Print dialog box (fig.40) in the Name list field, select a printer if it is possible to print on multiple printers.
In the Print frame, the Print dialog box indicates the pages that will be printed:
Then drag the dotted line to the right so that the table is displayed on 3 pages. Because you have reduced the size of the table. It may be useful to display a print preview and zoom to the actual page size so that the page remains readable.
To preview and verify readability. To save some information on a single page, you can manually set page breaks. In page break mode, click the line above which you want to set a page break. On the Page Setup tab, click Page Breaks, and then Insert Page Break.
all - all pages;
pages - only pages indicated in the fields with and to .
In the frame to print , print object is selected:
selected range - print only selected area;
selected sheets - print selected sheets (to select 2 or more sheets, click on their shortcuts while pressing the Ctrl key);
A solid line indicates a manual page break. Select another row and retry the operation. The table will still be printed on 3 pages, but it has page breaks where you want it. You can zoom the spreadsheet to zoom in and out.
On the Page Settings tab, you will notice that the spreadsheet scale is set to 100% and that the table will be printed on 6 pages. To print it on 3 pages, you need to zoom out. Click the arrow next to the width, and then click 1 page.
the entire book is a printout of the entire workbook.
The Number of copies field indicates the number of copies. To print the entire first copy, then the second, etc. you should enable the checkbox for collated copies.
To print one copy of the active sheets, just click the button.
Work with Microsoft Excel
This action reduces the width of the table to 1 page, which reduces the length of the spreadsheet to 3 pages that you are looking for. Again, since you have reduced the size of the spreadsheet, it may be useful to display a print preview and check the readability of the sheet.
You can also set the scale to a specific number. Click the down arrow to get the desired spreadsheet size. You can also press the “Scale” button and enter the number. On the screen, they look like one. On the screen, the table looks good.
To print only a part of a table, it is not necessary to filter it or hide rows and columns. You can simply specify the range of those cells to be printed. Notice that on the second sheet between the column headings and the numbers in the table there is a large gap. Let's eliminate it by excluding blank lines 7-9 from the print range.
They will only kill you, because nothing can solve all the problems of everyone, not even God. We believe that this is quite clear without the need for translation. In addition, the ability to create more than one print layout of the same design identified new methods when setting up drawings. Printing can be determined correctly when there is a right balance between the thickness of the pens used, colors, text size, font quality, the distance between the dotted lines, and, of course, the quality of the graphic layout.
The ease of quick changes for each of these functions is a guarantee of a good end result. Suppose that we need to reinforce the thickness of the lines that constitute the masonry, or to facilitate the laying lines. In both cases, we will work with the feather linings associated with the respective layers until the correct contrast is obtained. Suppose we “filled” the walls with a gray background. The gray part of our printer does not match the gray plotter of our print service. In this case, we will change the gray value of this layer to obtain the desired result. The same applies to differences in color printing between different printers and plotters. The problems encountered during the printing phase are mainly the following.
1. Select lines 1 through 6.
2. Press the Ctrl key and drag the pointer over the buttons of lines 10-14 to add them to the existing selection, as shown in Figure. 12.13.
3. Select File> Printing Area> Set . Now only selected lines will be printed. Check it out in preview mode.
- The thickness and colors of the scale factor of the handles in dotted lines.
- Text sizes and sizes.
- Layout ratio of the drawing.
- Printing with print service.
Thickness and color of pens As already mentioned, there is a direct correspondence between the layers and types of pen.
Stroke width: print resolution: build style. . The most interesting customizable parameters are pen color and relative percentage. All this is supposed, let's say, a possible layer scheme. The scale factor of the dashed lines. Its definition depends on the scale ratio of the graph.
Fig. 12.13. Print range setting
Note If after performing step 3 you open the Sheet tab of the Page Setup dialog box, you will see in the Print field a link range of 1: 6; 10: 14, which corresponds to the lines selected in steps 1 and 2. That is, you can set the print range and using this field of the Page Settings dialog box. To reset the set print range, just select File> Print Area> Remove .
It also increases in proportion to the age of the contractor. The older the text, the larger the text size is not a joke, but a matter of respect, the same is true for the quota size. compare the appropriate lesson. Layout design. For questions related to the layout, compare the relevant section.
Drawing Scale Indicators A good way to memorize drawing print reports is as follows. Drawing services The greatest difficulties arise when printing in the print service, and in any case in cases where tests and final printing are performed using other equipment. In this regard, we would like to give a few useful tips .
Completed operations complete customization of printing parameters for the Formula sheet. But in addition to the table, you need to print a diagram representing the data in graphical form. In the next exercise, you will configure the parameters of the Chart sheet and print it along with the source data table.
It may be useful to read: