Is there any shortcut to Apply the "number format" with two decimal places (negative numbers appear in red with parentheses). I am aware of Ctrl + Shift + $ but this gives the number in currency format and not number format. I am also aware of CONTROL + SHIFT + % but this does not give the number in red with parentheses.
是否有任何快捷方式应用带有两个小数位的“数字格式”(负数显示为带括号的红色)。我知道Ctrl + Shift + $但是这给出了货币格式的数字而不是数字格式。我也知道CONTROL + SHIFT +%,但这并没有用括号表示红色的数字。
2 个解决方案
#1
2
There is no such shortcut listed on the Excel Shortcut and Function Keys
Excel快捷键和功能键上没有列出此类快捷方式
NOTE If an action that you use often does not have a shortcut key, you can record a macro to create one.
注意如果您经常使用的操作没有快捷键,则可以录制宏来创建一个。
You have a few options:
你有几个选择:
- Copy/Paste Cell format
- Use the Ctrl+1 hotkey with a range of cells to bring up the Cell Formatting dialog and apply manually to the selected range
- Record a macro and assign your own hotkey (suggested by Microsoft at the link above)
- Apply the formatting manually to a single cell, then select a range of cells and press F4
复制/粘贴单元格格式
使用带有一系列单元格的Ctrl + 1热键可打开“单元格格式”对话框并手动应用于所选范围
录制宏并分配您自己的热键(Microsoft在上面的链接中建议)
手动将格式应用于单个单元格,然后选择一系列单元格并按F4
#2
1
You are looking for CTRL+SHIFT+!
您正在寻找CTRL + SHIFT +!
#1
2
There is no such shortcut listed on the Excel Shortcut and Function Keys
Excel快捷键和功能键上没有列出此类快捷方式
NOTE If an action that you use often does not have a shortcut key, you can record a macro to create one.
注意如果您经常使用的操作没有快捷键,则可以录制宏来创建一个。
You have a few options:
你有几个选择:
- Copy/Paste Cell format
- Use the Ctrl+1 hotkey with a range of cells to bring up the Cell Formatting dialog and apply manually to the selected range
- Record a macro and assign your own hotkey (suggested by Microsoft at the link above)
- Apply the formatting manually to a single cell, then select a range of cells and press F4
复制/粘贴单元格格式
使用带有一系列单元格的Ctrl + 1热键可打开“单元格格式”对话框并手动应用于所选范围
录制宏并分配您自己的热键(Microsoft在上面的链接中建议)
手动将格式应用于单个单元格,然后选择一系列单元格并按F4
#2
1
You are looking for CTRL+SHIFT+!
您正在寻找CTRL + SHIFT +!