Skip to main content

Posts

Showing posts from May, 2022

Useful Shortcuts in Google Sheets

  Useful Shortcuts in Google Sheets Use shortcut keys to navigate, format and work with data faster PC Shortcuts Mac Shortcuts Action Navigation [Ctrl] ▼ ⌘ ▼ Move to the bottom of the data region Other arrow keys - move to the edge of the data region [Ctrl] [Shift] ▼ [Shift] ⌘ ▼ Move to the bottom of the data region and highlight the range in between Other arrow key to move & highlight in different direction [Ctrl] A ⌘ A Select data in current region (or all if no data region) [Home] [Fn] ◀ Move to the first cell in the row [Ctrl] [Home] ⌘ [Fn] ◀ Move to cell A1 [End] [Fn] ▶ Move the last cell in the row [Ctrl] [End] ⌘ [Fn] ▶ Move to the last cell in the sheet [Ctrl] [Backspace] ⌘ [Backspace] Show active cell [Tab] Move one cell to the right [Shift] [Tab] Move one cell to the left [Enter] [Enter] Edit mode / move cell down [F2] [F2] Edit cell content [Ctrl] [Shift] [Page ▼] [Option] ▼ Move to the next worksheet [Ctrl] [Shift] [Page ▲] [Option] ▲ Move to the previous worksheet [...