62 Google Sheet Shortcuts for Windows and MacOs, Must Know!
Do you often use Google Sheets aka Google Sheets? Meansshortcut Google Sheet untuk Windows dan MacOs ini cocok buat kamu. Layaknya Microsoft Excel, Google Sheet juga memiliki banyak shortcut yang mempermudah pekerjaanmu.
These tools , which can be accessed through various devices , provide speed dial services using a keyboard combination to unlock certain features. There anything?
What are shortcuts ?
shortcut alias shortcut is a shorter path to access the operating method. It can save time than ordinary operation. On Mac, this system has an ‘alias’ name, but many refer to it by the term shortcut, just like Windows.
Google Sheet provides a wide selection of shortcuts that you can use to make your work more efficient. Simply by clicking a combination of symbols and letters on the keyboard, a new menu or window will easily open. In addition, shortcuts also contain commands that are used to apply certain formatting.
On Windows devices, shortcuts usually use a combination of the Windows key, shift , alt, and certain letters or symbols. As for the macOS operating system , the shortcut feature is the command , option, shift , letters, and symbols that are pressed together.
Commonly used Google Sheets shortcuts for Windows and MacOs
Ctrl + Z (Windows) atau ⌘ + Z (MacOs) = undo
Ctrl + Y (Windows) atau ⌘ + Y (MacOs) = redo
Ctrl + Space (Windows) or + space (MacOs) = select column
Ctrl + A (Windows) or + A (MacOs) = select all content
Ctrl + F (Windows) or + F (MacOs) = opens search bar
Ctrl + H (Windows) or + Shift + H (MacOs) = find and replace in documents
Ctrl + Enter (Windows) or + Enter (MacOs) = fill range
Ctrl + D (Windows) or + D (MacOs) = block down
Ctrl + R (Windows) or + R (MacOs) = block sideways
Ctrl + O (Windows) or + O (MacOs) = open old document
Ctrl + P (Windows) or + P (MacOs) = print document
Ctrl + C (Windows) or + C (MacOs) = copy
Ctrl + X (Windows) or + X (MacOs) = cut ( cut )
Ctrl + V (Windows) or + V (MacOs) = paste ( paste )
Ctrl + Shift + V (Windows) or + Shift + V (MacOs) = paste values only
Ctrl + / (Windows) or + / (MacOs) = open shortcut options
Shift + F11 (Windows) or Shift + Fn + F11 (MacOs) = create a new sheet
Ctrl + Shift + F (Windows) atau ⌘ + Shift + F (MacOs) = compact control
Ctrl + Shift + K (Windows) or + Shift + K (MacOs) = add tools on/off
Ctrl + Alt + Shift + K (Windows) or + Option + Shift + K (MacOs) = select input tool
Alt + / (Windows) or Option + / (MacOs) = search menu
Shortcut format Google Sheet
Ctrl + B (Windows) or + B (MacOs) = bold
Ctrl + U (Windows) or + U (MacOs) = underline
Ctrl + I (Windows) or + I (MacOs) = italic or italic
Alt + Shift + 5 (Windows) or Option + Shift + 5 (MacOs) = center line (strike)
Ctrl + Shift + E (Windows) atau ⌘ + Shift + E (MacOs) = average middle
Ctrl + Shift + L (Windows) atau ⌘ + Shift + L (MacOs) = left-aligned
Ctrl + Shift + R (Windows) atau ⌘ + Shift + (MacOs) = align right
Alt + Shift + 1 (Windows) or Option + Shift + 1 (MacOs) = create upper border
Alt + Shift + 2 (Windows) or Option + Shift + 2 (MacOs) = create right border
Alt + Shift + 3 (Windows) or Option + Shift + 3 (MacOs) = create a lower border
Alt + Shift + 4 (Windows) or Option + Shift + 4 (MacOs) = create a left border
Alt + Shift + 6 (Windows) or Option+ Shift + 6 (MacOs) = remove borders
Alt + Shift + 7 (Windows) or Option + Shift + 7 (MacOs) = apply outer border
Ctrl + K (Windows) or + K (MacOs) = insert link
Ctrl + Shift + ; (Windows) or + Shift + ; (MacOs) = insert time
Ctrl + ; (Windows) or + ; (MacOs)=insert date
Ctrl + Alt + Shift + ; (Windows) or + Option + Shift + ; (MacOs) = enter date and time
Ctrl + Shift + 1(Windows) atau ⌘ + Shift + 1 (MacOs) = format desimal
Ctrl + Shift + 2 (Windows) or + Shift + 2 (MacOs) = time format
Ctrl + Shift + 3 (Windows) or + Shift + 3 (MacOs) = date format
Ctrl + Shift + 4 (Windows) or + Shift + 4 (MacOs) = currency format
Ctrl + Shift + 5 (Windows) atau ⌘ + Shift + 5 (MacOs) = format persentase
Ctrl + Shift + 6 (Windows) or + Shift + 6 (MacOs) = format exponent
Ctrl + \ (Windows) or + \ (MacOs) = remove formatting
Shortcut Navigation Google Sheet
Home key (Windows) or Fn + Left arrow (MacOs) = move to the beginning of the line
Ctrl + Home (Windows) or + Fn + Left arrow (MacOs) = move to beginning of sheet
End key (Windows) or + Fn + Right arrow (MacOs) = move to end of line
Ctrl + End (Windows) or + Fn + Right arrow (MacOs) = move to end of sheet
Ctrl + Backspace (Windows) or + Backspace (MacOs) = scroll to active cell
Alt + Down arrow (Windows) or Option + Down arrow (MacOs) = move to next sheet
Alt + Up arrow (Windows) or Option + Up arrow (MacOs) = move to previous sheet
Alt + Shift + K (Windows) or Option + Shift + K (MacOS) = show sheet list
Alt + Enter (Windows) or Option + Enter (MacOs) = open a link
Alt + Shift + X (Windows) or Option + Shift + X (MacOs) = open explore
Ctrl + Alt + . (Windows) or + Option + . (MacOs) = go to side panel
Ctrl + Alt + Shift + M (Windows) or Ctrl + + Shift + M (MacOs) = move focus away from spreadsheet
Alt + Shift + Q (Windows) atau Option + Shift + Q (MacOs)= pindah ke quicksum
Ctrl + Alt, then E then P (Windows) or Ctrl + , then E then P (MacOs) = move focus to popup
Ctrl + Alt + R (Windows) or Ctrl + + R (MacOs) = open dropdown menu on filtered cells
Ctrl + Alt + Shift + H (Windows) or + Option + Shift + H (MacOs) = open revision history
Shift + Esc (Windows) or + Esc (MacOs) = close the image editor
The Google Sheet shortcuts for Windows and MacOs above may be difficult to memorize when you first start using them. However, over time and often use it, you will get used to it and work can be more efficient.
https://www.football.texastech.com/profile/thor-2022-italiano-streaming-ncux63/profile
https://www.football.texastech.com/profile/thor-2022-xem-phim-vi3tsub-tpritsis/profile
https://www.football.texastech.com/profile/thor4-2022-korean-hd-anwartvi/profile
https://www.football.texastech.com/profile/thor-2022-cely-film-richard928/profile
https://www.football.texastech.com/profile/thor4-2022-gratis-su6-espan0l-suzz20/profile