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

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(2 intermediate revisions by 2 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 [[Documentation/OOo3_User_Guides/Calc_Guide/Customizing_the_user_interface#Customizing_keyboard_shortcuts|Customizing keyboard shortcuts]].}}
+
{{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

Appendix A Keyboard Shortcuts
< {{#switch:Previous Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >
< {{#switch:Previous Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >



 {{#switch:ctrl | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = Ctrl }} {{#if:1| +  {{#switch:1 | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = 1 }} }}{{#if:| +  {{#switch:{{{3}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{3}}} }} }}{{#if:| +  {{#switch:{{{4}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{4}}} }} }}{{#if:| +  {{#switch:{{{5}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{5}}} }} }}{{#if:| +  {{#switch:{{{6}}} | shift = ⇧ Shift | up = ↑ | down = ↓ | > = → | < = ← | enter = ↵ Enter | cmd = ⌘ Cmd | command = ⌘ Cmd | opt = ⌥ Opt | option = ⌥ Opt | tab = Tab ⇆ | backspace = ← Backspace | << = ← Backspace | bs = ← Backspace | * = * | # = # | ; = ; | : = : | #default = {{{6}}} }} }} 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
 {{#switch:ctrl shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Ctrl

}} {{#if:Shift| +  {{#switch:shift

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Shift

}} }}{{#if:1| +  {{#switch:1

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = 1

}} }}{{#if:| +  {{#switch:{{{4}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{4}}}

}} }}{{#if:| +  {{#switch:{{{5}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{5}}}

}} }}{{#if:| +  {{#switch:{{{6}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{6}}}

}} }}

Two decimal places, thousands separator
 {{#switch:ctrl shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Ctrl

}} {{#if:Shift| +  {{#switch:shift

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Shift

}} }}{{#if:2| +  {{#switch:2

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = 2

}} }}{{#if:| +  {{#switch:{{{4}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{4}}}

}} }}{{#if:| +  {{#switch:{{{5}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{5}}}

}} }}{{#if:| +  {{#switch:{{{6}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{6}}}

}} }}

Standard exponential format
 {{#switch:ctrl shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Ctrl

}} {{#if:Shift| +  {{#switch:shift

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Shift

}} }}{{#if:3| +  {{#switch:3

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = 3

}} }}{{#if:| +  {{#switch:{{{4}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{4}}}

}} }}{{#if:| +  {{#switch:{{{5}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{5}}}

}} }}{{#if:| +  {{#switch:{{{6}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{6}}}

}} }}

Standard date format
 {{#switch:ctrl shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Ctrl

}} {{#if:Shift| +  {{#switch:shift

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Shift

}} }}{{#if:4| +  {{#switch:4

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = 4

}} }}{{#if:| +  {{#switch:{{{4}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{4}}}

}} }}{{#if:| +  {{#switch:{{{5}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{5}}}

}} }}{{#if:| +  {{#switch:{{{6}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{6}}}

}} }}

Standard currency format
 {{#switch:ctrl shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Ctrl

}} {{#if:Shift| +  {{#switch:shift

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Shift

}} }}{{#if:5| +  {{#switch:5

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = 5

}} }}{{#if:| +  {{#switch:{{{4}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{4}}}

}} }}{{#if:| +  {{#switch:{{{5}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{5}}}

}} }}{{#if:| +  {{#switch:{{{6}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{6}}}

}} }}

Standard percentage format (two decimal places)
 {{#switch:ctrl shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Ctrl

}} {{#if:Shift| +  {{#switch:shift

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = Shift

}} }}{{#if:6| +  {{#switch:6

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = 6

}} }}{{#if:| +  {{#switch:{{{4}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{4}}}

}} }}{{#if:| +  {{#switch:{{{5}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{5}}}

}} }}{{#if:| +  {{#switch:{{{6}}}

shift = ⇧ Shift up = ↑ down = ↓ > = → < = ← enter = ↵ Enter cmd = ⌘ Cmd command = ⌘ Cmd opt = ⌥ Opt option = ⌥ Opt tab = Tab ⇆ backspace = ← Backspace << = ← Backspace bs = ← Backspace * = * # = # ; = ; : = : #default = {{{6}}}

}} }}

Standard format
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Retrieved from "https://wiki-test.openoffice.org/w/index.php?title=Documentation/OOo3_User_Guides/Calc_Guide/Cell_formatting_shortcuts&oldid=258422"
Personal tools