Sheets
Workbooks contain multiple sheets. Each sheet is an independent grid of cells.
Sheet Management
Command |
Description |
|---|---|
|
Add a new sheet |
|
Rename the current sheet |
|
Rename a sheet by name |
|
Delete a sheet |
|
Duplicate a sheet (appends “ (copy)” suffix) |
|
List all sheets |
Cross-Sheet References
Reference cells on other sheets using the SheetName!Cell syntax:
=Sheet2!A1
=SUM(Sheet2!A1:A10)
=Expenses!B5 - Income!C5
Moving and Copying Sheets
:sheet move Name 1
:sheet copy Name NameCopy