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.
Leave Comment