Google Sheets Tastatürkürzel 

Google Sheets    

Zeynel -
7 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

1
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

1
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




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


Nur registrierte Benutzer können Links posten.
Checking site status...
 
Noch keine Kommentare. Fragen Sie oder geben Sie den ersten ein!

Neueste Artikel