In the workbook you want to print, click the [+] below, and then create a new blank worksheet
•Select the form to be printed, then click [Insert] in the workbook, then click the [Camera] icon,
• After the worksheet is photographed, click on the newly created blank form, and then click on any blank space. At this time, the photographed worksheet will appear in the blank form.
• According to the above method, put all the forms to be printed in the blank form, hold down the left mouse button and drag the form to adjust the position.
How to insert an Excel file in Excel?
Insert Excel file attachments
Open Excel, click the [Insert] tab on the Ribbon;
On the Insert tab, click the [Text] option;
In the text options menu, click the [Object] function
In the Insert Object dialog box, click the [Create from File] tab;
In the tab, click [Browse]
File selection pops up, select the file, and click [Insert];
Then click the [Display as Icon] option and select this option;
Click [OK] in the lower right corner, insert the Excel file attachment, and complete.
How to adjust the Excel table is paged and the printing is incomplete?
The Excel table is paged and the printing is incomplete. There are three ways to adjust: 1. Adjust the paged table to a full page by adjusting the row height and column width of the table. 2. By adjusting the printing zoom ratio, you can adjust the paged table to a full page when printing. 3. By adjusting the margins, you can try to adjust the slightly paged table to a full page.
Method 1: By adjusting the row height and column width
There are also two ways to adjust the row height and column width, which are described separately.
Select the row or column that needs to be adjusted, place the cursor on the row or column header, when it becomes a cross-shaped up and down arrow, press and drag to adjust the height or column width of all selected rows. You can try adjusting the row height or column width. Fits a paginated table to a full page.
Of course, you can also enter a row height in the pop-up dialog box by right-clicking “Row Height” on the selected row or column header or clicking “Start” – “Format” – “Row Height” or “Column Width” or the value of the column width, click “OK” to adjust the row height and column width.
Method 2: Introduction to the method of adjusting the print scaling ratio
There are also two ways to adjust the print scaling.
Click “View”, select “Pagination Preview”, place the cursor on the dotted page, when it becomes the small up and down arrows, press and drag to adjust the paged table to a full page during printing.
Click Page Layout, click to open the Page Setup dialog box.
On the “Page” tab, adjust the zoom ratio to an appropriate value, and click “OK” to adjust the page-by-page form to one page when printing.
Method 3: Introduction to the method of adjusting the page margins
The advantage of this method is that it will be consistent with the original effect when printing, and the disadvantage is also obvious. Only when the form is slightly paginated during printing, can you try to use this method to adjust the paginated table to one page.
Open the “Page Setup” dialog box, click to select the “Margins” tab, adjust the values of “Top”, “Bottom”, “Left”, “Right”, “Header” and “Footer”, click “OK” to try to fit the paginated table to a full page.
In actual use, it is necessary to select and use the most appropriate method according to different situations, so as to best realize the adjustment and printing of the paging table.