Google Sheets Keyboard Shortcuts Guide
Keyboard shortcuts can dramatically improve your speed and efficiency in Google Sheets. This guide covers the most useful shortcuts for everyday tasks.
Navigation Shortcuts
Ctrl+Arrow keys jumps to the edge of data. Ctrl+Home goes to cell A1. Ctrl+End goes to the last cell with data. Alt+Down opens a drop-down list.
Selection Shortcuts
Ctrl+Space selects the entire column. Shift+Space selects the entire row. Ctrl+A selects all data. Ctrl+Shift+Arrow keys extends the selection.
Editing Shortcuts
Ctrl+D fills down (copies the cell above). Ctrl+R fills right. Ctrl+; inserts today's date. Ctrl+Shift+; inserts the current time.
💡 F2 enters edit mode for the selected cell.
Formatting Shortcuts
Ctrl+B toggles bold. Ctrl+I toggles italic. Ctrl+U toggles underline. Ctrl+Shift+2 formats as time. Ctrl+Shift+4 formats as currency.
Formula Shortcuts
Ctrl+Shift+Enter wraps a formula in ARRAYFORMULA. Ctrl+` shows all formulas instead of values. F4 cycles through absolute/relative references.
Try These Templates
Frequently Asked Questions
How do I view all shortcuts in Google Sheets?
Press Ctrl+/ (Windows) or Cmd+/ (Mac) to open the keyboard shortcuts dialog.
Can I customize shortcuts in Google Sheets?
No. Google Sheets does not support custom keyboard shortcuts at this time.