Formula results are shown in worksheet cells, while formulas are visible in the formula bar only so that they won’t appear when you print. Showing formulas in the cells makes it easy to find cells that contain formulas, check for errors, or print with formulas displayed.
With a quick key combination you can see formulas instead of formula results in a worksheet.
- Office 365 is a cloud-based subscription service that brings together the best tools for the way people work today. By combining best-in-class apps like Excel and Outlook with powerful cloud services like OneDrive and Microsoft Teams, Office 365 lets anyone create and share anywhere on any device.
- JB Hi-Fi’s Apple Mac range includes the latest MacBooks that suit everyone, from the office to the classroom, to the sofa. Big tech and big value collide at Australia’s largest home entertainment retailer.
WD My Passport 2TB Portable Hard Drive USB 3.0 2019 (Red) WD Backup™ software to help make sure everything you create doesn’t get lost; WD Discovery™ software lets you connect to popular social media and cloud storage services like Facebook, Dropbox and Google Drive™.
Showing all formulas in all cells
To show formulas in all cells press CTRL+` (that little mark is the grave accent mark key). When the formulas are visible, print your worksheet as you normally would.
To switch back to showing formula results in all cells, press CTRL+` again.
Tip: If you’re having trouble finding the grave accent mark key (`), it is often located in the upper left corner on keyboards, but not always. If it’s difficult to find on your keyboard, you can also show and hide formulas by going to the Formulas tab and then clicking Show Formulas. To switch back to the standard view, click the button again.
Showing the formula of just one cell
The process above for all cells isn't available for just one cell or select cells. It applies to the whole sheet. Some people work around this by typing a single apostrophe before the formula in the cell. For example, '=SUM(1+2+3)
Still can't see formulas?
Sometimes people have the Formula bar off. Or, sometimes the sheet is protected from showing formulas. The following steps will help you in these situations.
Jb Au
The Good Guys
To show the Formula Bar, click the View tab, and then click to select the Formula Bar check box.
Tip: If you want to expand the Formula Bar to show more of the formula, press CONTROL+SHIFT+U.
If the above step doesn't work, make sure the sheet is enabled to show formulas. To do that:
On the Excel menu, click Preferences.
Under Authoring, click View .
Under Show in Workbook, select the Formulas check box.
This setting applies only to the sheet that you are currently viewing.
If you still can't see the formula for cells, try unprotecting the sheet or the whole workbook.
On the Review tab, click Unprotect Sheet or Unprotect Workbook. Then type the password if necessary.
On the Excel menu, click Preferences.
Under Authoring, click View .
Under Window options, select the Show formulas check box, and then click OK.
This setting applies only to the sheet that you are currently viewing.
Note: When the option to display formulas is turned on, you can switch between viewing the values and the formulas that produce the values by pressing CONTROL + ` (grave accent).
If you still can't see the formula for cells, try unprotecting the sheet or the whole workbook.
On the Review tab, under Protection, click Workbook. Then type the password if necessary.
See also
Exploring charts in Excel and finding that the one you pick isn’t working well for your data is a thing of the past! Try the Recommended Charts command on the Insert tab to quickly create a chart that’s just right for your data.
Select the data you want to chart.
Click the Insert tab, and then do one of the following:
Click Recommended Charts and select the chart type you want.
OR
Click a specific chart type and select the style you want.
With the chart selected, click the Chart Design tab to do any of the following:
Click Add Chart Element to modify details like the title, labels, and the legend.
Click Quick Layout to choose from predefined sets of chart elements.
Click one of the previews in the style gallery to change the layout or style.
Click Switch Row/Column or Select Data to change the data view.
Click Change Chart type to switch to a different kind of chart.