Google Sheets API: Range Parameter (A1 Notation)

Apr 7, 2019
RangeDescription
Sheet1!A1First cell on Row 1 Col 1
Sheet1!A1:C1Col 1-3 (A, B, C) on Row 1 = A1, B1, C1
A1Ffirst visible sheet (if sheet name is ommitted)
'My Sheet'!A1If sheet name which contain space or start with a bracket.
To be safe, always use this format.
Sheet1All cells in Sheet1.
Sheet1!A:AAll cells on Col 1.
Sheet1!A:BAll cells on Col 1 and 2.
Sheet1!1:1All cells on Row 1.
Sheet1!1:2All cells on Row 1 and 2.

References:

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.

Tags
Related articles
Google Sheets App Scripts: Make PubSub Publish CallSetup and Access Google Sheets API With PythonAnalyze Historical Stock Price With Google Sheets: GOOGLEFINANCE ExampleAndroid (Java/Kotlin) Google Sheets API: Metadata (Hide note/string in Sheet)Setup Google Sheets API for Android (Java/Kotlin)Google Sheets: Import Yahoo Finance Key Statistics Like PE ratioGoogle Sheets: Create DropdownGoogle Sheets: Show Elapsed TimePython Google Sheets API: Hide or Show SheetGoogle Sheets: Convert Unix Epoch Timestamp to DateGoogle Sheets App Scripts: Show and Close SidebarGoogle Sheets App Scripts: Show AlertGoogle Sheets Add Button With Apps Script EventPython Google Sheets API: Duplicate SheetPython Google Sheets API: Get Sheet Id by Sheet NameGoogle Sheets Apps Scripts: Custom Function Convert Unix Timestamp to DatePython Google Sheets API: Read All RowsPython Google Sheets API: Update Cell DataPython Google Sheets API: Append New RowGoogle Sheets Lock/Freeze Part of Cell Formula Reference When Copy Cells or Rows