Google Sheets Tastatürkürzel 

Google Sheets    

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

Select column

-1
↑  Shift + Space

Select row

0
Ctrl + A

Select all

0
oder Ctrl + ↑  Shift + Space
0
Ctrl + Z

Undo

0
Ctrl + Y

Redo

0
oder Ctrl + ↑  Shift + Z
0
oder F4
-1
Ctrl + F

Find

0
Ctrl + H

Find and replace

1
Ctrl + ⤶ Enter

Fill range

0
Ctrl + D

Fill down

0
Ctrl + R

Fill right

0
Ctrl + S

Save (every change is saved automatically in Drive)

0
Ctrl + O

Open

0
Ctrl + P

Print

0
Ctrl + C

Copy

0
Ctrl + X

Cut

0
Ctrl + V

Paste

0
Ctrl + ↑  Shift + V

Paste values only

0
Ctrl + /

Show common keyboard shortcuts

0
↑  Shift + F11

Insert new sheet

-1
Ctrl + ↑  Shift + F

Compact controls

0
Ctrl + ↑  Shift + K

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

0
Ctrl + Alt + ↑  Shift + K

Select input tools

Werbung

-1
Ctrl + B

Bold

1
Ctrl + U

Underline

0
Ctrl + İ

Italic

0
Alt + ↑  Shift + 5

Strikethrough

-1
Ctrl + ↑  Shift + E

Center align

0
Ctrl + ↑  Shift + L

Left align

0
Ctrl + ↑  Shift + R

Right align

0
Alt + ↑  Shift + 1

Apply top border

0
Alt + ↑  Shift + 2

Apply right border

0
Alt + ↑  Shift + 3

Apply bottom border

0
Alt + ↑  Shift + 4

Apply left border

0
Alt + ↑  Shift + 6

Remove borders

0
Alt + ↑  Shift + 7

Apply outer border

0
oder Ctrl + ↑  Shift + 7
0
Ctrl + K

Insert link

2
Ctrl + ↑  Shift + ;

Insert time

0
Ctrl + ;

Insert date

1
Ctrl + Alt + ↑  Shift + ;

Insert date and time

0
Ctrl + ↑  Shift + 1

Format as decimal

0
Ctrl + ↑  Shift + 2

Format as time

0
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
Ctrl + \

Clear formatting

0
Home

Move to beginning of row

0
Ctrl + Home

Move to beginning of sheet

0
End

Move to end of row

0
Ctrl + End

Move to end of sheet

1
Ctrl + Backspace

Scroll to active cell

0
Ctrl + Shift + Page Down

Move to next sheet

0
Ctrl + Shift + Page Up

Move to previous sheet

Werbung

0
Alt + ↑  Shift + K

Display list of sheets

0
Alt + ⤶ Enter

Open hyperlink

0
Alt + ↑  Shift + X

Open Explore

0
Ctrl + Alt + ↑  Shift + M

Move focus out of spreadsheet

0
Alt + ↑  Shift + Q

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

0
Ctrl + Alt Dann E Dann P

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

1
Ctrl + Alt + R

Open drop-down menu on filtered cell

1
Ctrl + Alt + ↑  Shift + H

Open revision history

0
↑  Shift + Esc

Open chat inside the spreadsheet

0
↑  Shift + Esc

Close drawing editor

0
↑  Shift + F2

Insert/edit note

-1
Ctrl + Alt + M

Insert/edit comment

0
Ctrl + Alt + ↑  Shift + A

Open comment discussion thread

0
Ctrl + Alt Dann E Dann C

Enter current comment

0
Ctrl + Alt Dann N Dann C

Move to next comment

0
Ctrl + Alt Dann P Dann C

Move to previous comment

0
Alt + F

(in Google Chrome) File menu

0
Alt + ↑  Shift + F

(in other browsers) File menu

0
Alt + E

(in Google Chrome) Edit menu

0
Alt + ↑  Shift + E

(in other browsers) Edit menu

0
Alt + V

(in Google Chrome) View menu

-1
Alt + ↑  Shift + V

View menu (in other browsers)

0
Alt + I

(in Google Chrome) Insert menu

0
Alt + ↑  Shift + İ

(in other browsers) Insert menu

0
Alt + O

Format menu (in Google Chrome)

0
Alt + ↑  Shift + O

(in other browsers) Format menu

0
Alt + D

Data menu (in Google Chrome)

0
Alt + ↑  Shift + D

(in other browsers)

0
Alt + T

Tools menu  (in Google Chrome)

0
Alt + ↑  Shift + T

(in other browsers)

0
Ctrl + Alt + ↑  Shift + =

(with cells selected) Open insert menu

0
oder Ctrl + Alt + =
1
Ctrl + Alt + -

(with cells selected)  Open delete menu

0
Alt + M

(in Google Chrome)  Form menu

0
Alt + ↑  Shift + M

(other browsers. Present when the spreadsheet is connected to a form) Form menu

0
Alt + N

(in Google Chrome) Add-ons menu

0
Alt + ↑  Shift + N

(in other browsers) Add-ons menu

0
Alt + H

(in Google Chrome) Help menu

0
Alt + ↑  Shift + H

(in other browsers) Help menu

0
Alt + A

(in Google Chrome) Accessibility menu

0
Alt + ↑  Shift + A

(in other browsers. Present when screen reader support is enabled)  Accessibility menu

0
Alt + ↑  Shift + S

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

0
Ctrl + ↑  Shift + \

Context menu

-1
Ctrl + Alt + ↑  Shift + =

(with rows selected) Insert rows above

1
oder Ctrl + Alt + =
0
Alt + I Dann R

(in Google Chrome) Insert rows above

1
Alt + ↑  Shift + I Dann R

(in other browsers) Insert rows above

0
Alt + I Dann W

(in Google Chrome) Insert rows below

0
Alt + ↑  Shift + I Dann W

(in other browsers) Insert rows below

0
Ctrl + Alt + ↑  Shift + =

(with columns selected) Insert columns to the left

0
oder Ctrl + Alt + =
0
Alt + I Dann C

(in Google Chrome, with columns selected) Insert columns to the left

0
Alt + ↑  Shift + I Dann C

(in other browsers, with columns selected) Insert columns to the left

0
Alt + I Dann O

(in Google Chrome) Insert columns to the right

0
Alt + ↑  Shift + I Dann O

(in other browsers) Insert columns to the right

0
Ctrl + Alt + -

(with rows selected) Delete rows

0
Alt + E Dann D

(in Google Chrome, with rows selected) Delete rows

0
Alt + ↑  Shift + E Dann D

(in other browsers, with rows selected) Delete rows

0
Ctrl + Alt + -

(with columns selected)  Delete columns

0
Alt + E Dann E

(in Google Chrome, with columns selected) Delete columns

0
oder Alt + ↑  Shift + E Dann E
0
Ctrl + Alt + 9

Hide row

0
Ctrl + Alt + 0

Hide column

0
Ctrl + ↑  Shift + 9

Unhide row

0
Ctrl + ↑  Shift + 0

Unhide column

0
Ctrl + ~

Show all formulas

0
Ctrl + ↑  Shift + ⤶ Enter

Insert array formula

0
Ctrl + E

Collapse an expanded array formula

0
↑  Shift + F1

(when entering a formula) Show/hide formula help

0
F4

(when entering a formula) Absolute/relative references

0
F9

(when entering a formula) Toggle formula result previews

0
Ctrl +   

Resize formula bar


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

Programminformationen

Programmname: Google Sheets Google Sheets (Produktivität)

Website: google.com/sheets

Letztes Update: 07.03.2020 08:19 UTC

So einfach drücken Sie Tastenkombinationen: 65%

Weitere Informationen >>

Anzahl der Verknüpfungen: 132

Plattform erkannt: Windows oder Linux

Ähnliche Programme



Benutzeroperationen

Google Sheets zu den Favoriten hinzufügen

Werbung


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


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

Neueste Artikel