WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up

      3246 results for how to enlarge cells in excel

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

      3246 results for how to enlarge cells in excel

      How to lock and unlock cells in WPS Spreadsheet

      How to lock and unlock cells in WPS Spreadsheet

      01:35

      How to lock and unlock cells in WPS Spreadsheet

      If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....

      Spreadsheet 10.7K views
      Use the text function to extract characters in cells

      Use the text function to extract characters in cells

      02:45

      Use the text function to extract characters in cells

      In this video, we'll introduce three practical functions in excel, which are the RIGHT, LEFT, and MID functions.In this example, if we want to extract the first three numbers on the right, how can we realize it? The RIGHT function could help. It can extract characters within a cell, from the right to the left. Here is the complete formula of the RIGHT function. RIGHT(text,num_chars) The first parameter text refers to the specific text to be extracted. The second parameter num_chars....

      Spreadsheet 3.7K views
      How to fill cells with pure colors, gradient colors, and patterns

      How to fill cells with pure colors, gradient colors, and patterns

      01:57

      How to fill cells with pure colors, gradient colors, and patterns

      When using WPS Spreadsheet to write a statistical data report, we may want to emphasize the cell data. To do this, we can fill the cell with background color and pattern.Take this table as an example. 1. If we want to fill the B3:G3 cell with color, select this area first.2. Click the Home tab above.3. Then click Settings.4. And finally click Cells. Or we can use the shortcut key Ctrl+1 to open the Formats Cells dialog box. · Pure colorClick Patterns, then we can choose a pure color to....

      Spreadsheet 9.1K views
      How to clear content format and comments for cells

      How to clear content format and comments for cells

      01:43

      How to clear content format and comments for cells

      When we use the WPS Spreadsheet to work, we sometimes need to clear the content of the table quickly. How can we realize it? This video could help to solve this problem. Take this transcript as an example. 1. To clear all contents within the table, select the area that needs to be cleared.2. Click the Clear dropdown button in the Home tab, and choose the All option to clear the table as needed. (Notes: We can also use the Clear function in this step. To realize it, select the area, and....

      Spreadsheet 7.8K views
      How to insert shapes in a worksheet

      How to insert shapes in a worksheet

      01:20

      How to insert shapes in a worksheet

      We can insert shapes into a worksheet with WPS Spreadsheet. For example, we can insert shapes as background into the four cells. This operation will emphasize the content in the corresponding cells. How can we realize it? Get into the Insert tab, and click the Shapes dropdown button. Then choose a shape that you want in the dropdown menu. In this example. we choose the Rounded Rectangle button. As you can see, the cursor turns into a cross + symbol. We can use it to draw a shape where....

      Spreadsheet 3.4K views
      How to create a Form in spreadsheet

      How to create a Form in spreadsheet

      01:26

      How to create a Form in spreadsheet

      WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

      Spreadsheet 5.2K views
      How to convert Excel to PDF

      How to convert Excel to PDF

      02:50

      How to convert Excel to PDF

      PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

      Spreadsheet 11.3K views
      How to apply accounting number format in WPS Spreadsheet

      How to apply accounting number format in WPS Spreadsheet

      00:56

      How to apply accounting number format 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. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

      Spreadsheet 8.0K views
      Prev 1 2 3 ... 405 406 Next
      WPS Academy
      Products
      Partners

      Follow us

      WPS Office Official Twitter

      WPS Office Official Facebook

      WPS Office Official YouTube