When I try to use the function sequence in spreadsheets like in excel, it only shows 1 result, how can I make wps to allow overflow in cells?
Asked
Active
Viewed 213 times
0
-
WPS Office is a proprietary app. Also consider contacting WPS support – Archisman Panigrahi Oct 08 '23 at 17:53
-
1It is somewhat unclear what you are trying to do. Can you edit the question and add more details? Edit link: https://askubuntu.com/posts/1488391/edit – Archisman Panigrahi Oct 08 '23 at 17:54
1 Answers
1
Sequence is an array function and you need to use Ctrl+Shift+Enter key combination to make it work in WPS Office.
Reference: https://www.wps.com/blog/ctrl-shift-enter-and-array-formulas-in-excel-a-comprehensive-guide/

BeastOfCaerbannog
- 14,585

Yop
- 9