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

        1689 results for excel highlight cells

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

        1689 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 20.5K 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 6.7K 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 19.5K 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 63.0K 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 6.0K 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 46.9K 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 29.1K 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 17.0K views
        Prev 1 2 3 ... 211 212 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube