MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
formulas
Recherche

How Do I Change Multiple Cells From Showing Results Of Formulas, To Formulas?

jeudi 20 janvier 2022, 04:15 , par MacMost
Is there any way to select a whole column of cells. Say “Column A” has 200 cells going down to the bottom of the page. Each cell has a different result and different formulas in each cell to get those individual results. I want to select all 200 cells of “Column A”. And then display the formula in each cell rather than the result. Is there any way to do that? I know I can go to each individual cell one at a time. Select a cell, click on it. Then click fx and choose “Convert Formula To Text In Cell”. I am trying not to do 200 cells one at a time. But, I may have too. Can you help me with this?
I want to do this in order to print that Number file. It is easy for me to print that Numbers page with all the formulas I’m using. Make corrections and come up with new formulas making notes on that printed sheet.
—–
Javier Flores
https://macmost.com/forum-how-do-i-change-multiple-cells-from-showing-results-of-formulas-to-formula...
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Date Actuelle
ven. 26 avril - 20:10 CEST