---
title: "Shortcut Keys for formatting elements in PivotTable view for MS Access"  
description: "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 n"  
author: "Vijay Shukla"  
published: 2013-04-04  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/477/shortcut-keys-for-formatting-elements-in-pivottable-view-for-ms-access  
category: "shortcut keys"  
tags: ["shortcut keys"]  
reading_time: 1 minute  

---

# Shortcut Keys for formatting elements in PivotTable view for MS Access

In this blog I [am trying](https://answers.mindstick.com/qa/36834/which-two-programming-languages-should-i-master-in-if-i-am-trying-to-get-into-google-or-facebook) to [explain](https://www.mindstick.com/forum/157854/what-is-system-debugging-explain-some-system-debugging-tools-used-in-modern-computer-systems) [Shortcut Keys](https://www.mindstick.com/blog/478/run-command-shortcut-keys) for formatting [elements](https://www.mindstick.com/forum/1440/wpf-button-with-multiple-text-elements) in PivotTable view for [MS Access](https://www.mindstick.com/blog/296751/top-ms-access-security-issues).\

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

CTRL+SHIFT+$: Apply the [currency format](https://www.mindstick.com/blog/328/currency-format-in-javascript), with two [decimal places](https://www.mindstick.com/forum/33881/round-double-type-variable-to-two-decimal-places-in-c-sharp) 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](https://www.mindstick.com/forum/1976/date-format-comparison-issue), 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.

---

Original Source: https://www.mindstick.com/blog/477/shortcut-keys-for-formatting-elements-in-pivottable-view-for-ms-access

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.