You can use the name box to the left of the formula bar to select from a list of names already defined on the sheet. This ensures that the name you enter in your formula is valid.
You can use the arrow keys to move around within a formula. First press CONTROL+U until you see the word 'Edit' at the left ...
You can use the Consolidate command from the Data menu to combine corresponding values in different sheets onto a summary ...
You can use the Goal Seek command on the Tools menu to reach a target value for one cell by changing the value in another ...
You can use the Name box to define or go to a name. To delete a name, point to Name on the Insert menu, choose Define, select ...
You can use the name box to the left of the formula bar to select from a list of names already defined on the sheet. This ...
You can use the Page Setup command on the File menu to specify the size of the chart when printed. Select Full Page, Scale ...
You can use the Scenarios command (Tools menu) to change the values in a set of cells and see the effect on the rest of your ...
You can view two parts of the same document at once. From the Window menu, choose Split to see both parts in one window, ...
You can zoom a group of sheets at once by holding down COMMAND while you click the sheet tabs to select the sheets, and then ...