Hi Jim,
Yes, it is definitely possible to show formulas on a worksheet in
Excel X for Mac. Here's how you can do it:
- Open the Excel worksheet that you want to show formulas for.
- Click on the "Formulas" tab in the ribbon at the top of the screen.
- In the "Formula Auditing" section of the ribbon, click on the "Show Formulas" button.
- All of the formulas in the worksheet will now be displayed instead of the calculated values.
To print the worksheet with both the values and formulas, you can follow these steps:
- Click on the "File" menu in the top left corner of the screen.
- Select "Print" from the dropdown menu.
- In the "Print" dialog box, make sure that the "Print Active Sheets" option is selected.
- Under the "Settings" section, choose "Entire Workbook" from the "Print What" dropdown menu.
- Under the "Print" section, select "Black & White" or "Grayscale" if you want to save ink.
- Click on the "Print" button to print the worksheet.