| | | |
 Uploading ....Calc ShortcutsSelect data range CTRL+*
toggle relative absolute references SHIFT+F4
increase height of row ALT+down
decrease height of row ALT+up
increase width of column ALT+right
decrease width of column ALT+left
optimize height/width ALT+arrow keys
Standard Formats:
numeric CTRL+SHIFT+1
exponential CTRL+SHIFT+2
date CTRL+SHIFT+3
currency CTRL+SHIFT+4
percentage CTRL+SHIFT+5
standard format CTRL+SHIFT+6 OR CTRL+SHIFT+SPACE
Verbinden von Text mit dem kaufmännischen &-Zeichen
|
| | | | A | B | C | D | E | | 1 | | | | | | | 2 | | Haus | boot | Hausboot | | | 3 | | Gummi | ente | Gummiente | | | 4 | | | | | | | Formeln der Tabelle | D2 : =B2&C2
D3 : =B3&C3 |
|
weitere Tips zum Verketten
|
|
|
| | | |
|
