WPS Features
Resources
Free AI Tools
Docs Center

How to Use

Last updated:July 8, 2026

This section includes 3 how-to topics: inserting the function from the dialog, typing the formula directly, and checking syntax and parameter guidance; all 3 are available without membership, and 0 are membership-related.

How-to Index

No.TaskAccess
11. Insert COLUMNS from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Check syntax and parameter guidanceFree

How-to Guide

1. Insert COLUMNS from the Insert Function dialog

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for COLUMNS in the dialog box.
  4. Select the function and click OK.
  5. Enter the reference range in the function parameter dialog.
  6. Click OK to insert the formula.

Success Check

  • The target cell now contains a COLUMNS formula.
  • You can continue editing parameters, press Enter to confirm, or copy the formula.

Notes

  • Use the standard function name when searching.
  • Make sure the reference matches the range you want to count.

2. Type the formula directly in a cell

Entry point: cell area or formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =COLUMNS(reference) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. Check whether the returned result matches the number of columns in the target range.

Success Check

  • The cell shows a calculated result, and the formula remains visible in the formula bar.
  • You can fill, copy, or adjust the formula afterward.

Notes

  • Use standard English punctuation in the formula.
  • If you copy the formula to other cells, check whether the reference changes as expected.

3. Check syntax and parameter guidance

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Search for COLUMNS.
  3. Select the function to review its name, syntax format, and parameter description.
  4. Return to the worksheet and enter or revise the formula as needed.

Success Check

  • You can see the function name, syntax format, or parameter description area.
  • You can continue entering the formula with the guidance shown.

Notes

  • Reviewing the syntax first can help reduce reference mistakes.
  • If related help content does not open, check your network connection.