Phím tắt trong Google Sheets (1 người xem)

[yeudoi]

1. Open the Insert menu:
Alt + I (Chrome on Windows/Linux)
Alt + Shift + I (Internet Explorer or Firefox on Windows/Linux)
Ctrl + Option + I (Mac)

2 Notice that the letter s is underlined in New sheet. Press s to select New sheet.
Common actions

Select column Ctrl + Space
Select row Shift + Space
Select all Ctrl + A
Ctrl + Shift + Space
Hide background over selected cells Ctrl + Shift + Backspace
Undo Ctrl + Z
Redo Ctrl + Y
Ctrl + Shift + Z
F4
Find Ctrl + F
Find and replace Ctrl + H
Fill range Ctrl + Enter
Fill down Ctrl + D
Fill right Ctrl + R
Save
Every change is saved automatically in Drive Ctrl + S
Open Ctrl + O
Print Ctrl + P
Copy Ctrl + C
Cut Ctrl + X
Paste Ctrl + V
Paste values only Ctrl + Shift + V
Show common keyboard shortcuts Ctrl + /
Insert new sheet Shift + F11
Compact controls Ctrl + Shift + F
Input tools on/off
(available in spreadsheets in non-Latin languages) Ctrl + Shift + K
Select input tools Ctrl + Alt + Shift + K
Cell formatting

Bold Ctrl + B
Underline Ctrl + U
Italic Ctrl + I
Strikethrough Alt + Shift + 5
Center align Ctrl + Shift + E
Left align Ctrl + Shift + L
Right align Ctrl + Shift + R
Apply top border Alt + Shift + 1
Apply right border Alt + Shift + 2
Apply bottom border Alt + Shift + 3
Apply left border Alt + Shift + 4
Remove borders Alt + Shift + 6
Apply outer border Alt + Shift + 7
Insert link Ctrl + K
Insert time Ctrl + Shift + ;
Insert date Ctrl + ;
Format as decimal Ctrl + Shift + 1
Format as time Ctrl + Shift + 2
Format as date Ctrl + Shift + 3
Format as currency Ctrl + Shift + 4
Format as percentage Ctrl + Shift + 5
Format as exponent Ctrl + Shift + 6
Clear formatting Ctrl + \
Spreadsheet navigation

Move to beginning of row Home
Move to beginning of sheet Ctrl + Home
Move to end of row End
Move to end of sheet Ctrl + End
Scroll to active cell Ctrl + Backspace
Move to next sheet Ctrl + Shift + Page Down
Move to previous sheet Ctrl + Shift + Page Up
Display list of sheets Alt + Shift + K
Open hyperlink Alt + Enter
Move focus out of spreadsheet Ctrl + Alt + Shift + M
Move to quicksum
(when a range of cells is selected) Alt + Shift + Q
Move focus to popup
(for links, bookmarks, and images) holding Ctrl + Alt, press E then P
Open drop-down menu on filtered cell Ctrl + Alt + R
Open revision history Ctrl + Alt + Shift + G
Open chat inside the spreadsheet Shift + Esc
Close drawing editor Shift + Esc
Notes and comments

Insert/edit note Shift + F2
Insert/edit comment Ctrl + Alt + M
Open comment discussion thread Ctrl + Alt + Shift + A
Enter current comment holding Ctrl + Alt, press E then C
Move to next comment holding Ctrl + Alt, press N then C
Move to previous comment holding Ctrl + Alt, press P then C
Menus

File menu in Google Chrome: Alt + F
other browsers: Alt + Shift + F
Edit menu in Google Chrome: Alt + E
other browsers: Alt + Shift + E
View menu in Google Chrome: Alt + V
other browsers: Alt + Shift + V
Insert menu in Google Chrome: Alt + I
other browsers: Alt + Shift + I
Format menu in Google Chrome: Alt + O
other browsers: Alt + Shift + O
Data menu in Google Chrome: Alt + D
other browsers: Alt + Shift + D
Tools menu in Google Chrome: Alt + T
other browsers: Alt + Shift + T
Form menu
(present when the spreadsheet is connected to a form) in Google Chrome: Alt + M
other browsers: Alt + Shift + M
Add-ons menu
(present in the new Google Sheets) in Google Chrome: Alt + N
other browsers: Alt + Shift + N
Help menu in Google Chrome: Alt + H
other browsers: Alt + Shift + H
Accessibility menu
(present when screen reader support is enabled) in Google Chrome: Alt + A
other browsers: Alt + Shift + A
Sheet menu
(copy, delete, and other sheet actions) Alt + Shift + S
Context menu Ctrl + Shift + \
Insert or delete rows or columns

Insert row above in Google Chrome: Alt + I, then R
other browsers: Alt + Shift + I, then R
Insert row below in Google Chrome: Alt + I, then W
other browsers: Alt + Shift + I, then W
Insert column to the left in Google Chrome: Alt + I, then C
other browsers: Alt + Shift + I, then C
Insert column to the right in Google Chrome: Alt + I, then G
other browsers: Alt + Shift + I, then G
Delete row in Google Chrome: Alt + E, then D
other browsers: Alt + Shift + E, then D
Delete column in Google Chrome: Alt + E, then E
other browsers: Alt + Shift + E, then E
Formulas

Show all formulas Ctrl + ~
Insert array formula Ctrl + Shift + Enter
Collapse an expanded array formula Ctrl + E
Show/hide formula help
(when entering a formula) Shift + F1
Screen reader support

Enable screen reader support
Learn more about using Google Sheets with a screen reader Ctrl + Alt + Z
Read column Ctrl + Alt + Shift + C
Read row Ctrl + Alt + Shift + R