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 Shukla3568 04-Apr-2013

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.


Updated 18-Sep-2014

Leave Comment

Comments

Liked By