0
In Excel 2007:
- Click on the Formulas ribbon tab.
- In the Formula Auditing section, click Show Formulas. This will display formulas instead of calculated results.
- Print the spreadsheet as you normally would.
- When done evaluating for formulas, do not forget to turn the Show Forumulas off.
In Excel 2003 or earlier:
- From the Tools menu, select Formula Auditing and click on Formula Auditing Mode.This will display formulas instead of calculated results.
- Print the spreadsheet as you normally would.
- When done evaluating for formulas, do not forget to turn the Show Forumulas off.
control-~
will display formulas
then you can print them
control-~ toggles back to values
If you press and hold the Ctrl key and then press the `key, all formulas will be shown in cells instead of the values. You can also achieve this by going to the Tools menu and picking Options. From there go to the View tab and put a tick beside formulas. When printing, there is a option to print formulas instead of the values.
In Excel 2007: From the Formula tab on the menu ribbon, in the Formula Auditing section, click on Show Formulas. That will display the formulas instead of the results in each row that has a formula. Then, you just print as you normally would. Remember to turn Show Formulas off when you want to go back to showing the results of the formulas instead the forumulas themselves.
On the Formulas bar, in the Formula Auditing section, click on Show Formulas to toggle formula view on and off. When the formula view is turned on, you will print formulas in the cells when you print the document. When the formula view is turned off, you will print values in the cells when you print the document.
What else can I help you with?
Which button should you click if you want to print formulas in a worksheet?
office button
How do you create a shape in your Excel worksheet using the Shapes button?
Click on the shape you want and then click and drag over the worksheet to draw it onto the worksheet.
What is the area of the worksheet window where you click a button which performs a task?
task pane
Which elements do you click to add a statistical to a worksheet?
More Functions Button on the Formulas Tab.
Which element do you click to add a statistical function to a worksheet?
More Functions Button on the Formulas Tab.
You can magnify or reduce the view of a worksheet with?
Go to view Tab and click the Zoom button
Which element do you click to insert a PMT function into a worksheet?
You can click on the Insert Function button and choose the Financial functions category to get the PMT function.
Which element do you click to insert a pmt function to a worksheet?
You can click on the Insert Function button and choose the Financial functions category to get the PMT function.
Why should you be careful when deleting a worksheet?
because in deleting worksheet it is contraceptive but logicallyis this answer can help u? click answersAnswers
How do you add a blank line in a spreadsheet?
Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.Go to the Insert menu and click on Worksheet or right click on a sheet tab and you can insert a worksheet. You can then drag it into a position before an existing worksheet.
What will be printed when you click the OK button Excel 2010?
Normally the whole set of data in the worksheet or the current chart sheet or the selected print area if one has been set.
To from one worksheet to another you click the sheet tab of the desire worksheet?
This question is not clear. If you have multiple worksheets in a workbook, you can click on the tab of the worksheet you want to display. To go to another worksheet, just click on its tab.
