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.
Add speaker notes in WPS Presentation
When using WPS Presentation to make PowerPoint and do a presentation, sometimes we need to add notes in the slides, which can assist us during the presentation. How can we add speaker notes with WPS Office? · Option 1: Enter the notes in the input box below each slide. · Option 2: 1. Get into the Slide Show tab → click the Speaker notes button2. Enter notes into the popup input box. Thousands of free WPS Presentation templates are waiting for you, just in WPS Office.
Common shortcut keys in WPS Spreadsheet
New File Ctrl + NClose the window Ctrl + WOpen…Ctrl + OSave Ctrl + SPrint Ctrl + PUndo Ctrl + ZRedo Ctrl + YCopy Ctrl + CCut Ctrl + XPasteCtrl + VFindCtrl + FReplaceCtrl + HGo To…Ctrl + GSelection PaneCtrl + F1Go to the beginning of the cellCtrl + HomeGo to the end of the cellCtrl + EndCreate a new line within a cellAlt + EnterExpand selection to the beginning of the cellShift HomePopup menu (right-click menu)Shift + F10 Help center F1Start to edit the cellF2Spell check F7Recalculate w....
Adjust line spacing for text contents in a cell
Can we change the line spacing for texts in a cell to beautify the spreadsheet? WPS spreadsheets have not supported paragraph settings including adjusting line spacing so far. Even so, we can still adopt some methods to adjust the space between two paragraphs. · Option 1: Left-click the cell → click Wrap Text in the Home tab · Option 2: Double-click between two sentences, and press Alt + Enter on the keyboard.
How to create a dropdown list in WPS Spreadsheets
When using WPS Spreadsheets to process a spreadsheet with a large number of data to fill in, creating a dropdown list in the target cells is able to boost our working efficiency, since we can choose one of the options from the dropdown list to fill the target cells rather than typing the contents word by word. An example of cells with a dropdown list is shown below. How can we realize it? An example of cells with a dropdown list inserted · Option 1: 1. Select the cell range to insert d....
How to draw in Word
When using WPS Writer to edit a Word file, how can we draw on it to create customized patterns? 1. Open the Word document in WPS Writer. 2. Get into the Insert tab → click Shapes3. Choose the icon Scribble4. Start to draw on the Word page ducument.
How to draw on a PDF
When using WPS to preview a PDF file, how can we draw on it to markdown key points when necessary? Here are the steps. 1. Open the PDF file in WPS. 2. Get into the Comment tab → click the Graffiti dropdown button.3. Then, we can access quick settings for ink marks in the dropdown list, to change the color, width, opacity of the line. 4. Start to draw on the PDF page as your favorite. * Tips: For advanced settings of ink marks, click the Graffiti button.
How to print powerpoint with speaker notes
Printing powerpoint slides with notes is sometimes helpful for a speaker when making presentations. Here are the steps to realize it. 1. Open the popup “Print” window with shortcut key Ctrl+P. (Tips: Another option in this step is to click the Memu dropdown list → File → Print) 2. Choose the Notes pages option in the category titled Print what3. Click OK to print the powerpoint with notes.* Tips: You can click Preview to view the printing effect.Thousands of free WPS Presentation templ....