How to Use the MAKEARRAY Function in WPS on Windows

Last updated:July 20, 2026

Use WPS MAKEARRAY on Windows through 3 how-to topics in WPS AirSheet; 3 topics are available without membership and 0 are membership-related.

How-to Index

#TopicMembership
11. Enter the MAKEARRAY functionFree
22. Fill in parameters with the promptFree
33. Check results and recalculateFree

How-to Guide

1. Enter the MAKEARRAY function

Entry point: Formulas tab → formula bar

  1. Open WPS AirSheet and select the cell where you want to enter the formula.
  2. Type the equals sign = in the cell or formula bar.
  3. Continue by typing MAKEARRAY(.
  4. Check the editing area for the syntax prompt to confirm that formula entry has started.

Success Criteria

  • UI state: The cell enters formula editing mode.
  • Next actions: You can continue entering parameters and complete the formula.

Tips While Using

  • Common mistakes: If you do not type = first, the content may be treated as plain text.
  • Environment limits: You need to work in an editable spreadsheet file.

2. Fill in parameters with the prompt

Entry point: A cell that is already in MAKEARRAY formula editing mode

  1. Enter the row count parameter based on the result size you need.
  2. Enter the column count parameter.
  3. Continue entering the remaining calculation logic required by the syntax prompt.
  4. Check that parentheses, separators, and parameter count are complete.
  5. Press Enter to confirm the formula.

Success Criteria

  • UI state: The cell or result range displays the calculated result.
  • Next actions: You can select the formula cell again and adjust the parameters.

Tips While Using

  • Common mistakes: Unmatched parentheses or missing separators can cause formula errors.
  • Environment limits: Parameter values must meet the function requirements for the result to return correctly.

3. Check results and recalculate

Entry point: The worksheet area that contains the MAKEARRAY result

  1. Review whether the formula result appears in the target range.
  2. If the result does not match your expectation, select the formula cell again and check the parameters and references.
  3. Modify related data and see whether the result updates automatically.
  4. If needed, press F9 to recalculate.

Success Criteria

  • UI state: The result range shows the updated array result.
  • Next actions: You can continue adjusting the formula, references, or related data.

Tips While Using

  • Common mistakes: If the result range is blocked by other content, display and review may be affected.
  • Environment limits: Manual recalculation depends on the current worksheet calculation state.