Google Sheets Keyboard Shortcuts and Gemini AI Tools (2025)

Google Sheets is no longer just a spreadsheet, it’s a smart workspace powered by Gemini AI.

Whether you’re crunching numbers, formatting data, or generating formulas with AI, this guide covers the essential shortcuts and tools to help you work faster and smarter in 2025.

Feel feel to contact us or leave a comment below for any feedback or help.

Useful Google Sheets Shortcuts (Desktop)

These shortcuts work in the browser-based Google Sheets editor. Use them to navigate, format, and analyze data more efficiently:

📊 Navigation & Selection

Shortcut	What It Does
Ctrl + ↑ / ↓ / ← / →	Jump to the edge of data in the selected direction.
Ctrl + Home	Go to the top-left cell (A1).
Ctrl + End	Jump to the bottom-right of your data range.
Shift + Space	Select the entire row.
Ctrl + Space	Select the entire column.
Ctrl + /	Open the full list of keyboard shortcuts.

🧮 Formulas & Functions

Shortcut	What It Does
=	Start a formula in the selected cell.
Alt + =	Insert the SUM function automatically.
Ctrl + Shift + Enter	Enter an array formula.
F4	Toggle absolute/relative references (e.g., A1 → $A$1).

🎨 Formatting

Shortcut	What It Does
Ctrl + b / i / u	Bold, italicize, or underline selected text.
Ctrl + Shift + 1–6	Apply number, percent, currency, date, time, or scientific format.
Ctrl + \	Clear formatting from selected cells.
Alt + Shift + 5	Apply or remove strikethrough.

📁 File & Sheet Management

Shortcut	What It Does
Ctrl + Shift + k	Insert a new sheet.
Alt + Shift + k	Delete the current sheet.
Ctrl + PageUp / PageDown	Switch between sheets (tabs).
Ctrl + s	Save manually (though Sheets auto-saves).

💻 ChromeOS Shortcuts for Google Sheets

If you’re using a Chromebook, Google Sheets has a few extra keyboard shortcuts you’ll want to know:

Common Actions

Action	Shortcut
Select column	Ctrl + Space
Select row	Shift + Space
Undo / Redo	Ctrl + z / Ctrl + y / Ctrl + Shift + z
Paste values only	Ctrl + Shift + v
Tool finder	Alt + /
Convert range to table	Shift + Alt + T

Formatting & Borders

Action	Shortcut
Bold / Italic / Underline	Ctrl + b / i / u
Strikethrough	Alt + Shift + 5
Align: Left / Center / Right	Ctrl + Shift + l / e / r
Apply borders (Top–Left)	Alt + Shift + 1–4
Outer border	Alt + Shift + 7 or Ctrl + Shift + 7
Clear formatting	Ctrl + \

Navigation & Sheet Control

Action	Shortcut
Move to row start/end	Search + Left / Right Arrow
Jump to A1 / bottom-right	Ctrl + Search + Left / Right
Next / Previous sheet	Ctrl + Shift + Search + Down / Up
Scroll to active cell	Ctrl + Backspace
Open Explore	Ctrl + Alt + Shift + i

Comments & Notes

Action	Shortcut
Insert/edit comment	Ctrl + Alt + m
Open comment thread	Ctrl + Alt + Shift + a
Reply / Resolve / Exit	R / E / U

Gemini AI in Google Sheets

Gemini is now built into Sheets, helping you automate and analyze data with natural language. Here’s what it can do:

• Generate Formulas: Ask Gemini to create formulas like “Calculate monthly growth rate” or “Sum column B if column A is ‘Paid’.”
• Create Tables: Use prompts like “Create a 5-row table for a weekly budget” and Gemini will insert it for you.
• Summarize Data: Select a range and ask Gemini to summarize trends, totals, or outliers.
• Build Charts: Ask Gemini to “Create a bar chart comparing sales by region.”

Google Sheets on iPhone & iPad

• Voice Input: Tap the mic icon to dictate formulas or values.
• Gemini in Gmail: If enabled, Gemini can suggest Sheets actions based on email content.
• Touch Gestures: Tap and drag to autofill, resize columns, or reorder sheets.

Google Sheets on Android

• Gemini Integration: Tap the ✨ icon to generate formulas, summaries, or tables.
• Voice Commands: Use Google Assistant to say “Open my budget spreadsheet” or “Add a row to grocery list.”
• Long-Press Actions: Hold on cells to format, insert, or comment quickly.

Pro Tip: Combine Shortcuts + Gemini

Use = to start a formula, then ask Gemini to complete it. Or press Ctrl + Shift + k to add a new sheet, then prompt Gemini to populate it with a project tracker or content calendar.

---

Google Sheets is now a full-blown data assistant, especially when you combine keyboard shortcuts with Gemini AI. Download the cheat sheet, explore the mobile tips, and take control of your spreadsheets like never before.

Want more cheat sheets and productivity guides?

Each guide includes mobile tips, Gemini AI usage, and a free downloadable cheat sheet.

• Google Docs Shortcuts + Gemini AI
• Gmail Shortcuts + Gemini AI
• Google Calendar Shortcuts + Gemini AI
• Google Slides Shortcuts + Gemini AI
• Google Drive Shortcuts + Gemini AI