Google Sheets (Mac) Tastatürkürzel 

Google Sheets (Mac)    

Zeynel -
6 years ago
- Tastaturkürzel
-1
Ctrl + Space

Select column

0
↑  Shift + Space

Select row

0
⌘ Cmd + A

Select all

0
oder ⌘ Cmd + ↑  Shift + Space
0
⌘ Cmd + Z

Undo

0
⌘ Cmd + Y

Redo

-2
oder ⌘ Cmd + ↑  Shift + Z
3
oder Fn + F4
0
⌘ Cmd + F

Find

0
⌘ Cmd + ↑  Shift + H

Find and replace

0
⌘ Cmd + ⤶ Enter

Fill range

0
⌘ Cmd + D

Fill down

0
⌘ Cmd + R

Fill right

0
⌘ Cmd + S

Save (every change is saved automatically in Drive)

0
⌘ Cmd + O

Open

0
⌘ Cmd + P

Print

0
⌘ Cmd + C

Copy

0
⌘ Cmd + X

Cut

0
⌘ Cmd + V

Paste

0
⌘ Cmd + ↑  Shift + V

Paste values only

-2
⌘ Cmd + /

Show common keyboard shortcuts

0
Ctrl + ↑  Shift + F

Compact controls

0
⌘ Cmd + ↑  Shift + K

Input tools on/off (available in spreadsheets in non-Latin languages)

0
⌘ Cmd + ⌥ Opt + ↑  Shift + K

Select input tools

Werbung

0
⌘ Cmd + B

Bold

0
⌘ Cmd + U

Underline

0
⌘ Cmd + İ

Italic

0
⌥ Opt + ↑  Shift + 5

Strikethrough

0
⌘ Cmd + ↑  Shift + E

Center align

0
⌘ Cmd + ↑  Shift + L

Left align

0
⌘ Cmd + ↑  Shift + R

Right align

0
⌥ Opt + ↑  Shift + 1

Apply top border

0
⌥ Opt + ↑  Shift + 2

Apply right border

0
⌥ Opt + ↑  Shift + 3

Apply bottom border

1
⌥ Opt + ↑  Shift + 4

Apply left border

0
⌥ Opt + ↑  Shift + 6

Remove borders

1
⌥ Opt + ↑  Shift + 7

Apply outer border

0
oder ⌘ Cmd + ↑  Shift + 7
0
⌘ Cmd + K

Insert link

0
⌘ Cmd + ↑  Shift + ;

Insert time

0
⌘ Cmd + ;

Insert date

-3
⌘ Cmd + ⌥ Opt + ↑  Shift + ;

Insert date and time

0
Ctrl + ↑  Shift + 1

Format as decimal

0
Ctrl + ↑  Shift + 2

Format as time

-1
Ctrl + ↑  Shift + 3

Format as date

0
Ctrl + ↑  Shift + 4

Format as currency

0
Ctrl + ↑  Shift + 5

Format as percentage

0
Ctrl + ↑  Shift + 6

Format as exponent

0
⌘ Cmd + \

Clear formatting

0
Fn +

Move to beginning of row

0
⌘ Cmd + Fn +

Move to beginning of sheet

0
Fn +

Move to end of row

0
⌘ Cmd + Fn +

Move to end of sheet

0
⌘ Cmd + Backspace

Scroll to active cell

0
⌘ Cmd + ↑  Shift + Fn +

Move to next sheet

0
Ctrl + ↑  Shift + Fn +

Move to previous sheet

0
⌥ Opt + ↑  Shift + K

Display list of sheets

Werbung

0
⌥ Opt + ⤶ Enter

Open hyperlink

0
⌥ Opt + ↑  Shift + X

Open Explore

0
Ctrl + ⌘ Cmd + ↑  Shift + M

Move focus out of spreadsheet

0
⌥ Opt + ↑  Shift + Q

Move to quicksum (when a range of cells is selected)

0
Ctrl + ⌘ Cmd Dann E Dann P

Move focus to popup (for links, bookmarks, and images)

0
Ctrl + ⌘ Cmd + R

Open drop-down menu on filtered cell

0
⌘ Cmd + ⌥ Opt + ↑  Shift + H

Open revision history

0
↑  Shift + Esc

Open chat inside the spreadsheet

0
⌘ Cmd + Esc

Close drawing editor

0
oder ↑  Shift + Esc
0
↑  Shift + F2

Insert/edit note

0
⌘ Cmd + ⌥ Opt + M

Insert/edit comment

0
⌘ Cmd + ⌥ Opt + ↑  Shift + A

Open comment discussion thread

0
Ctrl + ⌘ Cmd Dann E Dann C

Enter current comment

0
Ctrl + ⌘ Cmd Dann N Dann C

Move to next comment

0
Ctrl + ⌘ Cmd Dann P Dann C

Move to previous comment

0
Ctrl + ⌥ Opt + F

File menu

0
Ctrl + ⌥ Opt + E

Edit menu

0
Ctrl + ⌥ Opt + V

View menu

0
Ctrl + ⌥ Opt + I

Insert menu

0
Ctrl + ⌥ Opt + O

Format menu

0
Ctrl + ⌥ Opt + D

Data menu

0
Ctrl + ⌥ Opt + T

Tools menu

0
⌘ Cmd + ⌥ Opt + =

(with cells selected) Open insert menu

0
⌘ Cmd + ⌥ Opt + -

(with cells selected)  Open delete menu

0
Ctrl + ⌥ Opt + M

Form menu

0
Ctrl + ⌥ Opt + N

Add-ons menu

0
Alt + H

(in Google Chrome) Help menu

0
Alt + ↑  Shift + H

(in other browsers) Help menu

0
Ctrl + ⌥ Opt + A

Accessibility menu

0
Ctrl + ⌥ Opt + A

(present when screen reader support is enabled) Accessibility menu

0
⌥ Opt + ↑  Shift + S

Sheet menu (copy, delete, and other sheet actions)

0
⌘ Cmd + ↑  Shift + \

Context menu

0
⌘ Cmd + ⌥ Opt + =

(with rows selected) Insert rows above

1
oder Ctrl + ⌥ Opt + I Dann R
0
Ctrl + ⌥ Opt + I Dann B

Insert rows below

0
⌘ Cmd + ⌥ Opt + =

(with columns selected) Insert columns to the left

0
oder Ctrl + ⌥ Opt + I Dann C
0
Ctrl + ⌥ Opt + I Dann O

Insert columns to the right

0
⌘ Cmd + ⌥ Opt + -

(with rows selected) Delete rows

0
oder Ctrl + ⌥ Opt + E Dann D
1
oder ⌘ Cmd + ⌥ Opt + -
0
oder Ctrl + ⌥ Opt + E Dann D
0
Ctrl + ⌥ Opt + -

(with columns selected)  Delete columns

0
Ctrl + ⌥ Opt + E Dann E

(with columns selected) Delete columns

0
⌘ Cmd + ⌥ Opt + 9

Hide row

0
⌘ Cmd + ⌥ Opt + 0

Hide column

0
Ctrl + ~

Show all formulas

0
⌘ Cmd + ↑  Shift + ⤶ Enter

Insert array formula

0
⌘ Cmd + E

Collapse an expanded array formula

0
↑  Shift + Fn + F1

(when entering a formula) Show/hide formula help

2
Fn + F1

(when entering a formula) Full / compact formula help

5
Fn + F4

(when entering a formula) Absolute/relative references

0
Fn + F9

(when entering a formula) Toggle formula result previews

0
Ctrl + ⌥ Opt +   

Resize formula bar


Teilen Sie diese Seite auf:
Ist diese Seite hilfreich?
0 0

Programminformationen

Programmname: Google Sheets (Mac) Google Sheets (Mac) (Produktivität)

Website: google.com/sheets

Letztes Update: 17.01.2020 06:52 UTC

So einfach drücken Sie Tastenkombinationen: 67%

Weitere Informationen >>

Anzahl der Verknüpfungen: 115

Plattform erkannt: Windows und macOS gemischt

Ähnliche Programme



Benutzeroperationen

Google Sheets (Mac) zu den Favoriten hinzufügen

Werbung


Was ist Ihr Lieblings-Hotkey für Google Sheets (Mac) ? Habt ihr dazu nützliche Tipps? Informieren Sie unten andere Benutzer darüber.


 
Noch keine Kommentare. Fragen Sie oder geben Sie den ersten ein!