WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to change print area in excel

    2402 results for how to change print area in excel

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    2402 results for how to change print area in excel

    How to print the notes in PDF

    How to print the notes in PDF

    01:21

    How to print the notes in PDF

    We may add notes to important content when reading a PDF document. Do you know how to print them out?Take this document as an example. We have added several notes on the page. 1. Click Menu and click Print.2. On the right of the pop-up dialog, select Document and Note Contents in the "Print content" drop-down button.3. Then the marks of notes are displayed in the preview window. However, we still fail to print out the contents in the text boxes. What can we do? There are two methods fo....

    PDF 2.5K views
    How to print slides in black and white

    How to print slides in black and white

    00:53

    How to print slides in black and white

    Printing black and white slides helps to reduce printing costs and save resources. Next, I will share how to print black and white slides with you.Take this slide as an example. Click the Print Preview shortcut button at the top left of the screen.At this point, the slide shows the colored style.Click the drop-down button of Color above, and then click Pure Black and White so that the slide is set to be printed in black and white.In addition, we can also set the printing color in the P....

    Presentation 2.5K views
    How to insert a background image and print it out in WPS Spreadsheet

    How to insert a background image and print it out in WPS Spreadsheet

    01:31

    How to insert a background image and print it out in WPS Spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....

    Spreadsheet 24.4K views
    How to print hidden slides in WPS Presentation

    How to print hidden slides in WPS Presentation

    00:48

    How to print hidden slides in WPS Presentation

    When projecting slides with WPS Presentation, we sometimes hide some of the slides for better projection effect.The hidden slides cannot be projected or printed. So how can we print them without changing their hidden state?Take this slide as an example. In the thumbnail on the left of the screen, you can see a small delete icon at the slide page number, indicating the slide is hidden.You need to click the Menu button in the upper-left corner and click Print.Click the check box Use the ....

    Presentation 1.2K views

    How to set print area in a worksheet

    1. Open the worksheet (XLS. Or XLSX. files) in WPS Spreadsheets. 2. Select the cell area to be printed → click the Page Layout tab → Print Area dropdown button → choose Set Print Area from the drop down list.3. Then, click Print Preview to preview effect. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

    xls Spreadsheet 7.4K views
    Set the page printing area in WPS Office Spreadsheet

    Set the page printing area in WPS Office Spreadsheet

    00:47

    Set the page printing area in WPS Office Spreadsheet

    What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....

    Spreadsheet 7.3K views
    Instructions of page setup in worksheet

    Instructions of page setup in worksheet

    01:54

    Instructions of page setup in worksheet

    When printing WPS Spreadsheet, in order to print out the table more readable and more beautiful, we can set up the printed page of the table. Take this table as an example. First, click the Page Layout tab and then click the Print Titles button to enter the Page Setup dialog box. If we want to print a specific part of the area, select the area that needs to be printed in the Print area box. If we want to print too much data, we can print them on several pages. Except for the first pag....

    Spreadsheet 4.3K views
    Set the Table Header and Footer

    Set the Table Header and Footer

    02:10

    Set the Table Header and Footer

    In our actual work, we sometimes need to add information such as time, page number and logo in the header and footer of each page to make it more normative. So how do we set the table header and footer? In this table, we have set up the table print area. Click the Print Header and Footer button on the Print Preview tab, and in the pop-up dialog, we can set the header and footer. WPS Office has built in some basic styles, but if we need more, click the Custom Header button.There are thr....

    Spreadsheet 2.4K views
    Prev 1 2 3 ... 300 301 Next
    WPS Academy
    Products
    Partners