Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Cell formatting shortcuts"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(3 intermediate revisions by 3 users not shown)
Line 5: Line 5:
 
|NextPage=Documentation/OOo3_User_Guides/Calc Guide/DataPilot shortcut keys
 
|NextPage=Documentation/OOo3_User_Guides/Calc Guide/DataPilot shortcut keys
 
}}
 
}}
''Ctrl+1'' open the Format Cells dialog.
+
{{key|Ctrl|1}} opens the Format Cells dialog.
  
{{Documentation/Note| The shortcuts listed in Table 4 do not work under any Linux desktop tested. If you would like to have the functionality described in this table, you must create custom key sequnces as explained in the ''Assigning shortcut keys'' topic at the beginning of this appendix.}}
+
{{Note| The shortcuts listed in Table 4 do not work under any Linux desktop tested. If you would like to have the functionality described in this table, you must create custom key sequences as explained in [[Documentation/OOo3_User_Guides/Calc_Guide/Customizing_the_user_interface#Customizing_keyboard_shortcuts|Customizing keyboard shortcuts]].}}
  
{{Documentation/Note| The shortcut keys shown in Table 4 '''do not''' use the number keys on the number pad. They use the number keys above the letter keys on the main keyboard.}}
+
{{Note| The shortcut keys shown in Table 4 '''do not''' use the number keys on the number pad. They use the number keys above the letter keys on the main keyboard.}}
  
 
''Table 4: Formatting shortcut keys''
 
''Table 4: Formatting shortcut keys''
Line 16: Line 16:
 
! Shortcut Keys  
 
! Shortcut Keys  
 
! Effect  
 
! Effect  
 
 
|-
 
|-
| ''Ctrl+Shift+1 ''
+
| {{key|Ctrl|Shift|1}}
 
| Two decimal places, thousands separator
 
| Two decimal places, thousands separator
 
 
|-
 
|-
| ''Ctrl+Shift+2 ''
+
| {{key|Ctrl|Shift|2}}
 
| Standard exponential format
 
| Standard exponential format
 
 
|-
 
|-
| ''Ctrl+Shift+3 ''
+
| {{key|Ctrl|Shift|3}}
 
| Standard date format
 
| Standard date format
 
 
|-
 
|-
| ''Ctrl+Shift+4 ''
+
| {{key|Ctrl|Shift|4}}
 
| Standard currency format
 
| Standard currency format
 
 
|-
 
|-
| ''Ctrl+Shift+5 ''
+
| {{key|Ctrl|Shift|5}}
 
| Standard percentage format (two decimal places)
 
| Standard percentage format (two decimal places)
 
 
|-
 
|-
| ''Ctrl+Shift+6 ''
+
| {{key|Ctrl|Shift|6}}
 
| Standard format
 
| Standard format
 
 
|}
 
|}
 
  
 
{{CCBY}}
 
{{CCBY}}
 
[[Category: Calc Guide (Documentation)]]
 
[[Category: Calc Guide (Documentation)]]

Latest revision as of 12:07, 9 October 2023



 Ctrl  +  1  opens the Format Cells dialog.

Documentation note.png The shortcuts listed in Table 4 do not work under any Linux desktop tested. If you would like to have the functionality described in this table, you must create custom key sequences as explained in Customizing keyboard shortcuts.
Documentation note.png The shortcut keys shown in Table 4 do not use the number keys on the number pad. They use the number keys above the letter keys on the main keyboard.

Table 4: Formatting shortcut keys

Shortcut Keys Effect
 Ctrl  +  ⇧ Shift  +  1  Two decimal places, thousands separator
 Ctrl  +  ⇧ Shift  +  2  Standard exponential format
 Ctrl  +  ⇧ Shift  +  3  Standard date format
 Ctrl  +  ⇧ Shift  +  4  Standard currency format
 Ctrl  +  ⇧ Shift  +  5  Standard percentage format (two decimal places)
 Ctrl  +  ⇧ Shift  +  6  Standard format
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools