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
      • how to freeze more than one column in excel

      285 results for how to freeze more than one column in excel

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

      285 results for how to freeze more than one column in excel

      How can we freeze the pane in WPS Spreadsheet

      How can we freeze the pane in WPS Spreadsheet

      02:28

      How can we freeze the pane in WPS Spreadsheet

      When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently? Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three....

      Spreadsheet 1,769 views
      Layout skill-How can we split columns

      Layout skill-How can we split columns

      01:39

      Layout skill-How can we split columns

      When using WPS Writer to create a layout in Word, we sometimes may want to split the content into two columns. So how are we going to make it? First click the upper tab Page Layout and click Columns. At this time, you can directly select whether you want to spilt the content into one column (One), two columns (Two), or three columns (Three).If you need to customize the column settings, just click More Columns to view more detailed options. There are five column styles in Preset, namely....

      Writer 1,151 views
      How to use the OR Function

      How to use the OR Function

      01:40

      How to use the OR Function

      WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. This is a promotion application form submitted by employees. The company sets two conditions for it.1. Length of service should be more than 3 years; 2: Personal KPI should be rated as A.The Applicant has the qualification to register when any one of the requirements is met. If you are the HR of the company, how can you quickly select qualified employee....

      Spreadsheet 38 views
      COUNTIFS function: count data of multiple criteria

      COUNTIFS function: count data of multiple criteria

      01:57

      COUNTIFS function: count data of multiple criteria

      We often need to count the number of data in our work, so how can we count them quickly? Here, we need to use a new function, COUNTIFS. The grammatical structure of COUNTIFS is COUNTIFS (range1, criteria1, [range2, criteria2]...) Take this table as an example. Now we want to count how many types of foods are produced in Thailand and also have a sales volume of more than 5,000? There are two criteria that we want to consider. One, the sales volume needs to be greater than 5,000, and the....

      Spreadsheet 1,246 views
      How to draw a column chart in WPS Spreadsheet

      How to draw a column chart in WPS Spreadsheet

      01:46

      How to draw a column chart in WPS Spreadsheet

      A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....

      Spreadsheet 1,041 views
      How to make conference table cards in batches

      How to make conference table cards in batches

      02:58

      How to make conference table cards in batches

      Making conference table cards is a necessary skill for civilian staff. Today we will learn about how to make double-sides conference tables. Step 1. Create a single table.First of all, click the Page layout tab, and set the page layout to Landscape.To make the table more exquisite, we have inserted a two-column, one-row table and a background image into the document in advance.Now, we can choose the desired WordArt effect and add it to the appropriate position in the cells on both side....

      Writer 4 views
      Skillfully use Conditional Formatting to highlight  performance

      Skillfully use Conditional Formatting to highlight performance

      01:21

      Skillfully use Conditional Formatting to highlight performance

      To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting.1. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the....

      Spreadsheet 43 views
      Text to Columns: Sort data quickly

      Text to Columns: Sort data quickly

      02:03

      Text to Columns: Sort data quickly

      When creating tables, we sometimes need to import data from outside, and this data often requires secondary classification processing. We now want to classify the data in the table into Name, Age and Telephone. So how can we do that?1. We select column A, click the Data tab.2. Click the Text to Columns drop-down button. 3. Then select the Text to Columns option in the drop-down menu.In the popup dialog box, we can see two options.+One is Delimited. Here, we can use symbols as the basis....

      Spreadsheet 109 views
      Prev 123...3536 Next
      WPS Academy