I have a very large spreadsheet with array formulas (aka CSE formulas) in every cell. For me to activate the formulas I need to place my cursor in the formula bar and hit Ctrl+Shift+Enter for *every cell*, which in my case is about 9,000 cells.
Is there any way to activate the CSE formulas for all cells at once?
Any help is greatly appreciated.
Thanks,
Franco
Hi,
This code will convert all formaulas within selection to arrays.
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Perfect. That did it. You just saved my mucho hours of monkey work!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks