WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • excel highlight cells

    469 results for excel highlight cells

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

    469 results for excel highlight cells

    Format cells

    Format cells

    04:42

    Format cells

    Cell formatting is very important in data processing. We often need to set a proper cell format when entering data in WPS Spreadsheet. Let's talk about the differences between each format. Take this table as an example. Most of the cells in column B of the table are in general format. General format cells have no specific number format, which are simply displayed as numbers. In this table, most of the Column B cells are in general format. The format of cell C2 is a numeric format.....

    Spreadsheet views
    Conditional Formatting to highlight top three items

    Conditional Formatting to highlight top three items

    01:37

    Conditional Formatting to highlight top three items

    The Conditional Formatting function can format the cells fulfiling specific conditions. With this function, we can quickly compare data in a worksheet. The worksheet in this example records the performance of staff. What if we want to highlight the Top Three performances? When there is a large amount of data, Conditional Formatting can quickly filter the first three maximums. 1. Select cell C2. 2. Then, press Ctrl + Shift + DOWN (↓) for quick selection from cell C2 to C26 (C2:C26).3. G....

    Spreadsheet views
    Multiple methods of merging cells

    Multiple methods of merging cells

    03:17

    Multiple methods of merging cells

    When we use the WPS Spreadsheet, we often need to merge and combine multiple cells. Merge and Center in WPS spreadsheet offers multiple merging methods. We will explain in detail how to use this function. · Merge and CenterSelect the cell area to be merged, click Home and find the drop-down menu of Merge and Center, and select Merge and Center or press keyboard shortcut Ctrl+M. In this way, the selected cells can be merged into one cell and displayed in the center. · Merge CellsSelect ....

    Spreadsheet 0.7807 views
    Format Cells Locked and Hidden

    Format Cells Locked and Hidden

    01:21

    Format Cells Locked and Hidden

    When working with spreadsheets, what should we do if we want to hide and protect the formulas in the cells? Take this spreadsheet as an example, click the Review tab, then we can box the cells containing the formulas, right-click for the pop-up dialog, select Format Cells. Its shortcut key is Ctrl+1.Next, click Protection, check Locked and Hidden at the same time, and click OK. We sometimes find the Locked option in the dialog settings displaying as a black square, which represents unc....

    Spreadsheet views
    Set the date format cells

    Set the date format cells

    01:40

    Set the date format cells

    In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

    Spreadsheet 0.393 views
    How to highlight the content of a PDF file

    How to highlight the content of a PDF file

    02:04

    How to highlight the content of a PDF file

    When reading the PDF file, we sometimes may encounter some critical text content. To facilitate our reading, we can highlight the needed text. Today, we will show you how to use the highlighting feature of the PDF. Take this PDF file as an example. Click the Comment tab, then click the Highlight drop-down menu. Here, select the color we like, then the selected text will be highlighted.If we want to highlight an area, we can use the area highlighting feature. Click the Highlight Area dr....

    PDF 0.1512 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 views
    Merge and split table cells in WPS Writer

    Merge and split table cells in WPS Writer

    01:09

    Merge and split table cells in WPS Writer

    Today we are going to learn how to merge and split table cells in a document.Take this table as an example.· Merge cellsHere, we can merge cells. Select the cell in the first column and click the Merge Cells button in the Table Tools tab to merge the cells. · Split Cells1. If we want to divide a cell into several cells, we can select the cell that needs to be split. 2. Click the Split Cells button in the Table Tools tab.3. In the pop-up dialog box, we can set the number of columns and ....

    Writer views
    Prev 123...5859 Next
    WPS Academy
    Products
    Partners