How to compress picture size in Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. 1. Open your table in WPS Spreadsheet.2. Insert at least one picture into your table from either local folder or online picture platform.2. Select the picture you want to compress, click the Compress Picture button to change resolution and other options. Finally, click OK to to finish the process.
How to insert a line chart in a column chart?
1. Select the cells containing the data that you’d like to use. 2. Click Insert → Chart → Combo. 3. In the Create combination charts area, you can change the chart type of the series that you need to Line, and set up the rest series as Clustered Column. Then click the preview chart, and we can get a desired chart. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.
How to set the cell color to change as the data changes？
1. Open the table in WPS Office, select the cells that you want to set. 2. Click Home → Conditional Formatting → Highlight Cells Rules. 3. Select one of the rules as you need. Here we select Equal to for example. Fill a "5" in the text box, and select Light Red Fill with Dark Red Text. Then click OK. In the same way, we set "6" as Yellow Fill with Dark Yellow Text, and "7" as "Green Fill with Dark Green Text". 4. When the data in other cells is changed to 5, the changed cell will becom....
How to display multiple tables side by side under the same window?
1. Use WPS Office to open the tables that you need. 2. Click View → Arrange All → Horizontal Text Box/Vertical Text Box. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.
How to select multiple cells in contiguous range
In WPS Spreadsheet, we can select an entire cell range with a shortcut key until the empty cell. Here are the steps. 1. Select a cell in WPS Spreadsheet.2. Press the shortcut key Ctrl+Shift+↓on the keyboard.To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
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 switch data from rows to columns in Excel
1. Select the table for operation, and right-click to copy it (Shortcut key: Ctrl + C).2. Right-click on the cell for the new table → click Special Paste → click Transpose.WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.