Untitled A1
Associated References:
Clipboard
Font
Alignment
Number
Select
Cells
Rows & Columns
Protect
Sheet Tabs
Sort
Find
Validation
Insert Chart (select data first)
Freeze
Zoom
100%
ƒx

Lock Rows

Selected rows will be protected from editing until unlocked with this password.

Unlock Rows

Enter the password to unlock the selected rows.

OPS CommandGrid — Help & Instructions

Export PDF

Generate a polished PDF report from OPS CommandGrid.

Exporter information

Case #, IMS HUB ID, and OPS Group from the title bar are added to the PDF header when filled in.

Restore OPS CommandGrid session?

Your work was automatically saved in the browser by OPS CommandGrid.

Clear for New

Warning: This will completely erase the current OPS CommandGrid workbook — all sheets, data, charts, and formatting. This cannot be undone from within OPS CommandGrid.

A copy is also kept in browser storage archives (last 10 versions).

Conditional Formatting

Alternating Band Colors

Applying to: A1

Select cells, entire row(s), or column(s) first. Cells with a manual fill color keep their fill.

Dropdown List

Applying to: A1

Enter choices one per line or comma-separated:

Tip: Select entire row(s) or column(s) first, then apply one list to all cells in that selection.

Date Picker

Applying to: A1

Cells will show a calendar when edited. Dates are stored as YYYY-MM-DD.

Select entire row(s), column(s), or a cell range, then apply — same as dropdown lists.

Insert Link

Applying to: A1

Typed URLs (https://… or www.…) in cell text are also clickable automatically.

Find

Add Rows

New spreadsheets start with 100 rows. Add more as needed.