Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • insert another cell in excel

      270 results for insert another cell in excel

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

      270 results for insert another cell in excel

      Different methods of using format painter

      Different methods of using format painter

      02:12

      Different methods of using format painter

      When we use WPS Spreadsheet at work, if we want to quickly copy the formatting of a cell to another cell, we can use the Format Painter function in WPS Spreadsheet. Take this table as an example. We now want to copy and paste the formatting of cell A1 to cell D1. 1. Select cell A1.2. Click the Home tab first and then click the Format Painter button.3. Now select cell D1. There you can copy and paste the formatting of cell A1 to cell D1. But how can we use Format Painter to copy and pa....

      Spreadsheet 2,794 views
      How to insert an attachment in WPS Spreadsheet

      How to insert an attachment in WPS Spreadsheet

      01:28

      How to insert an attachment in WPS Spreadsheet

      When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....

      Spreadsheet 83 views

      How to insert pictures in a cell of the table

      1. Use WPS Office to open the table. Select the cell where the picture needs to be embedded.2. Click the Insert tab → and then click the inverted triangle button below the Picture button → now select Embed to Cell. 3. Then we can choose the picture we want to insert in the popup window, and click OK.This skill could be also used in Microsoft Office Excel and Openoffice.

      Spreadsheet 1,435 views
      TEXT formula in WPS Spreadsheet

      TEXT formula in WPS Spreadsheet

      03:09

      TEXT formula in WPS Spreadsheet

      The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

      Spreadsheet 1,560 views
      How to enter a number starting with 0 in the Spreadsheet

      How to enter a number starting with 0 in the Spreadsheet

      01:38

      How to enter a number starting with 0 in the Spreadsheet

      The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

      Spreadsheet 576 views

      How to insert checkbox in Excel

      1. Click the cell where we want to insert the check box.2. Click the Insert tab → the Forms drop-down button → the Check Box option.3. When the cursor appears as a cross, click the left mouse button and drag the cursor to insert a checkbox. Or we can click the cell directly,then we can insert a checkbox.4. After inserting the checkbox, we can edit the text of it.5. Click another cell, then we can check the box. To be office excel advanced, you could learn how to use WPS Office Spreadsh....

      Spreadsheet 2,291 views
      Add blank rows in an individual table

      Add blank rows in an individual table

      01:02

      Add blank rows in an individual table

      Sometimes there are several tables in one worksheet, and we want to add blank rows in one of the tables. How can we solve it? Take this worksheet as an example. Suppose we need to add a blank row in the left table. At this time, if we use the frequently used method, which is to select the desired range and right-click to insert a blank row, we can find that a blank row is also inserted in another table. Thus, we need to use another method to insert the blank row.Firstly, select the loc....

      Spreadsheet 9 views
      Get to know the cell widget

      Get to know the cell widget

      02:38

      Get to know the cell widget

      Today we are going to show you how to use the cell widget in WPS Spreadsheet. The functions of it are very practical useful. Let's learn this feature together! · Convert Text to Number In WPS Spreadsheet, the text formatting is quite special. 1. It cannot be directly converted to other formats. 2. The text formatting is aligned to the left, and other formattings are aligned to the right. Take this table as an example. We now need to change the date in the table to another type. By ....

      Spreadsheet 535 views
      Prev 123...3334 Next
      WPS Academy