If you know the result that you want a formula to produce, use Goal Seek on the Tools menu to try different values until the goal is reached.
If you double-click the Format Painter button it will stay selected so that you can paint multiple areas with the same formats. ...
If you have installed the Solver add-in, you can use the Solver command on the Tools menu to optimize a formula based on ...
If you have named a range of cells on a worksheet, you can go to that range if you click the arrow to the left of the formula ...
If you have never created any Visual Basic code before, you may find it easier to first record a macro and then edit the ...
If you know the result that you want a formula to produce, use Goal Seek on the Tools menu to try different values until ...
If you modify the MDX definition of the set, any additional modifications can only be done using MDX as well. Click OK to ...
If you need help choosing a function and entering its arguments, click the Paste Function button on the Standard toolbar. ...
If you need more complex text editing than a text box can provide, you can embed a Microsoft Word document in a worksheet. ...
If you often hide and unhide rows and columns to see different views of your data, use an outline to hide or show levels ...