Filters, freeze panes, dropdowns and goal seek

Use Kazi Sheets data tools: column filters, freeze header rows, merge cells, dropdown picklists, locked cells, remove duplicates, find, cell notes and goal seek.

#Freeze the header row or first column

View → Freeze Header Row 1 keeps your column titles visible while you scroll. Freeze First Column A does the same for row labels.

#Filter

Data → Column Auto-Filters (Row 1) adds a filter button to every header. Use it to show only rows that match, for example only Paid invoices.

#Merge cells

Select cells and click Merge (or Format → Merge Selected Cells). Use Unmerge Cells to split them again.

#Dropdown lists

Select cells, then Data → In-Cell Status Dropdown Picklist. Enter the choices (for example Pending, Paid, Overdue). People filling the sheet pick from the list, which keeps data consistent.

#Lock cells

Data → Lock / Unlock Selected Cells protects formulas and headers from accidental edits.

#Remove duplicates

Data → Remove Duplicate Rows deletes repeated rows, keeping the first one.

#Find

Ctrl+F (Edit → Find & Highlight in Sheet) highlights every matching cell.

#Cell notes

Insert → Attach Cell Audit Note… adds a note to a cell. Use it to explain where a number came from.

#Goal seek

Want to know the input that gives a result you need? Open Tools → Goal Seek Financial Solver…

1. Set cell: the formula cell (for example the monthly payment).
2. To value: the result you want.
3. By changing: the input cell (for example the loan amount).

Kazi finds the input that hits your target.

#Gridlines

Turn View → Show Gridlines off for a cleaner printout or screenshot.

#Version history

File → Version History & Snapshots… saves and restores snapshots of the whole spreadsheet.