How to combine first and last names
How can we merge different cells while keeping all contents inside? Follow these few steps.Suppose that we need to combine the contents in cell B3 and C3. 1. Enter =A3&B3 in cell D3.2. Then you’ll find the the first and last name combined in cell D3. However, we know that there should be a space between each first and last name. Can we realize it?1. Enter =A3&" "&B3 in cell D3. (Note that there should be a space within the pair of quotation marks, regarding the language habits of Engl....
How to copy and paste the filtered table data？
1. Open your document and filter the data as needed. Here we take this sales table as an example. We want to know sales in Beijing and Shanghai. 2. Select the cells to be copied after filtering. Click Ctrl+C and click Ctrl+V to paste in the targeted area. WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.
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....