Adds a new tab to an existing spreadsheet.

Overwrites a contiguous range of cells with given values.

Updates multiple cell ranges in a single call.

Inserts blank rows into a sheet.

Clones an existing sheet tab into a new tab.

Renames, recolors, freezes, or hides a sheet tab.

Locks a cell range so only chosen editors can modify it.

Creates a named range usable in formulas across the spreadsheet.

Applies fonts, colors, number formats, and alignment to cells.

Merges a range of cells into one.

Unmerges previously merged cells in a range.

Sets or clears borders on a cell range.

Applies alternating banded row colors to a range.

Auto-fits column widths or row heights to content.

Sorts a range of cells by one or more columns.

Adds a data validation rule such as a dropdown to a range.

Adds a conditional formatting rule to a cell range.

Sets the basic auto-filter on a sheet range.

Creates a named saved filter view for later use.

Adds an embedded chart (bar, line, pie, etc.) to a sheet.

Removes an embedded chart from the spreadsheet.

Adds an interactive slicer filter control to a sheet.

Modifies an existing slicer's column or data range.