Just to illustrate the weakness of the auditing features in Excel. If I need to really start picking apart the formulas of a model I use my Explode addin. In a few seconds it formats the workbook with a color map that I'm familiar with.
#Eraser tool in neooffice code
The first thing I always do is run my color code macro on the whole workbook. Rather than give up, I began to develop the auditing tools that I thought should already be a part of Excel. Until I finally realized that they were inadequate for the kind of formula auditing I needed to do. I can appreciate that the tracer arrows are helpful for some things. If you forget, remember the UNDO command. Remember to exit the cell with the enter key to avoid changing the formula. It's usually best to work from the inside (smallest/deepest nested function) outward. The trick is selecting complete function portions. If instead you highlight a function from within Will's formula: e.g.,Īnd then click the equal sign it will bring up the function wizard for ADDRESS (both explaining the function and showing its current result).
In an Excel sheet and select the cell into which it was pasted and then click the equal sign in the toolbar, it will bring up the function wizard for the REPT function and fill the parameters with the othe functions that are used as parameters. For example, using the formula from Will's post today: It also is possible to do this same thing with portions of a long formula. This brings up the "Paste Function" (which without instructiuon or looking for its official name I've always called the Function Wizard) so that you can see the function's purpose and walk through its parameters. I Dave Excel tips, he mentions that you can debug a formula by selecting the cell it's in and clicking the equal sign next to the formula display in the toolbar. I was thinking more of the second (like Will's demagnifying the screen) when I started this thread, but I like all of what is being posted.
#Eraser tool in neooffice how to
We seem to be covering two interrelated themes: good wookbook construction techniques (BUILDING) and how to figure out what's there in a complicated sheet (DECIPHERING). Select a link in the dialog box and its refences will display in the Reference box.
It will bring up a dialog box of the links. To see the references from the other sheets, double click the arrow from the "Sheet" icon. Select cell A1 and click the third icon and it will draw arrows from A1 to cells D2 and D5, because they reference A1 directly.Ĭlicking the first icon while having selected cell D13 (which references cells in other sheets) will draw incoming arrows from cell D11 and from a "Sheet" icon. (Saving will also make them disappear.) If you print with the arrows visible, they print, too. Click the eraser icon and the arrows will disappear. Do this in cell D2 and it will draw a box around the range A1:B2 and put a dot in the top left cell of the range. It will out a dot in and draw arrows from cells A1, A4, adn A7. In the example, select cell D5 and click the left auditing icon. The cell selected, or (third icon) which cells the selected cell feeds into. The result (which hopefully saved as the leftmost icons on the second row of the toolbar) is a set of icons that automatically draw arrows indicating either (first icon) which cells feed into To load it I have to VIEW > TOOLBARS > CUSTOMIZE > AUDITING I don't see this discussed very often, and wonder if it's because MicroSoft doesn't make it as easy to find as most of the other standard toolbars. I'll volunteer my favorite tool: the Auditing Toolbar. My thought is that perhaps we could create a thread with the various things we do to simplify this process for ourselves, and then we could reference folks to this thread (or a summary of it if someone creates it) as a general reference. I don't see much directly geared toward helping to decipher what someone else has done to create a complicated spreadsheet that you've inherited (or with helping you figure out how you did something in a sheet you haven't looked at for months or longer). As I look through the tips posted on OzGrid and elsewhere, most seem geared toward helping folks construct effective workbooks, develop charts, or write VBA code, etc.
0 kommentar(er)
