Users Pricing

blog

home / developersection / blogs / shortcut keys for formatting elements in pivottable view for ms access

Shortcut Keys for formatting elements in PivotTable view for MS Access

Vijay Shukla 4204 04 Apr 2013 Updated 18 Sep 2014

In this blog I am trying to explain Shortcut Keys for formatting elements in PivotTable view for MS Access.

CTRL+SHIFT+~ (tilde): Apply the general number format to values in the selected total or detail field.

CTRL+SHIFT+$: Apply the currency format, with two decimal places and negative numbers in parentheses, to values in the selected total or detail field.

CTRL+SHIFT+%: Apply the percentage format, with no decimal places, to values in the selected total or detail field.

CTRL+SHIFT+^: Apply the exponential number format, with two decimal places, to values in the selected total or detail field.

CTRL+SHIFT+#: Apply the date format, with the day, month, and year, to values in the selected total or detail field.

CTRL+SHIFT+@: Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field.

CTRL+SHIFT+!: Apply the numeric format, with two decimal places, thousands separator, and a minus sign for negative values, to values in the selected total or detail field.

CTRL+B: Make text bold in the selected field of the PivotTable view.

CTRL+U: Make text underlined in the selected field of the PivotTable view.

CTRL+I: Make text italic in the selected field of the PivotTable view.


Vijay Shukla

Other