If you have installed the Solver add-in, you can use the Solver command on the Tools menu to optimize a formula based on constraints of its precedent cells.
If you don't want to be prompted for summary information when you save a new workbook, choose Preferences from the Edit menu, ...
If you don't want to edit directly in cells, choose Preferences from the Edit menu and then clear the 'Edit Directly in Cell' ...
If you don't want to paste objects along with cells, choose Preferences from the Edit menu, and then clear the 'Cut, Copy, ...
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 ...