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


Shortcut Keys Shortcut Keys 
Ratings:
0 Comment(s)
 1665  View(s)
Rate this:

Shortcut Keys for formatting elements in PivotTable view for MS Access

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.


Don't want to miss updates? Please click the below button!

Follow MindStick