62 Google Sheet Shortcuts for Windows and MacOs, Must Know!

Technology

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

https://www.football.texastech.com/profile/padre-no-hay-mas-que-uno-3-2022-gratis-espanol-mcsgonza/profile