Showing Percents

You can display grid data as percentages using the Percent options on the View tab of the ribbon.

In Show Percent, select By X Axis (percentages by rows) or By Y Axis (percentages by columns).

In Percent Format, select a format for percentage display.

To remove percentages, select No in Show Percent.

To display the percentages together with the actual values, click Show Percent and Values on the View tab of the ribbon.

To remove the percent and values display, click to release Show Percent and Values.

The Percent options are also available as properties in the Data Properties pane.