⚑Common Actions

How to convert a range to a table in Google Sheets

Convert the selected range of cells into a formatted table.

Ctrl + Alt + T

πŸ“‹ Step-by-Step Guide

  1. 1.Open Google Sheets in your browser.
  2. 2.Select the cell(s) you want to work with.
  3. 3.Press Ctrl + Alt + T to convert a range to a table.

🎯 Shortcut Keys by Platform

PlatformShortcut
πŸ’» PC / Windows
Ctrl + Alt + T
🍎 Mac
⌘ + Option + T
πŸ’» Chrome OS
Ctrl + Alt + T

πŸ’‘ Pro Tips

  • You can combine this shortcut with the other Common Actions shortcuts to speed up your workflow.
  • If you forget this shortcut, press Ctrl + / (or ⌘ + / on Mac) to see all available keyboard shortcuts in Google Sheets.

❓Frequently Asked Questions

πŸ“š Explore All Google Sheets Shortcuts

Discover 111 keyboard shortcuts to boost your productivity

View All Shortcuts ➜