Tags:cells

  • How to Merge Existing Cells in Excel Spreadsheet

    Date:2019-10-28 Author:Cordelia

    When editing a spreadsheet in Excel, a wide header which takes up the width of several cells is often needed. In practice, we often merge some existing cells to fulfill this kind of demand. Let’s see the detailed steps. 1. Select the range of cells you want to merge. Please note that they must be […]

  • How to Autofill the Table with Numbered List in Word

    Date:2019-10-17 Author:Cordelia

    If you create a table in Word and want to fill the cells with numbered list, could you do it automatically? It’s quite simple actually. 1. Select the cells you want to autofill. 2. Click Home – Numbering. Choose a number format here and you can see the result. 3. If you are unsatisfied with […]

  • How to Autofit the Column Width with the Content in Excel

    Date:2019-10-9 Author:Cordelia

    Everyone who often use Excel should have encountered a situation that the entered text is so long that exceed the cell’s border. So how to autofit the column width to make it correspond with the length of characters? Here are 2 commonly used methods. Method 1: Wrap Text 1. Select the cells you want to […]

  • How to Lock Specific Cells in Excel to Protect the Data

    Date:2019-7-16 Author:Cordelia

    When we are editing a table with Excel, some of the data in it may be so important that can’t be modified by others freely or by ourselves incautiously. If we can lock one or several cells in the table only, we can then focus more on processing the data without extra worries. How to […]