Format cells and ranges — AI Prompts for Google Sheets

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

This budget sheet looks raw. Format the listed ranges so the Income column shows currency with two…

This budget sheet looks raw. Format the listed ranges so the Income column shows currency with two decimals, Dates use DD-MMM-YYYY, and Percentage columns show one decimal. Apply bold to header rows and set zebra striping on rows 2–100 with very light gray. Make negative values display in red parentheses. Leave a note in B1 of the sheet describing the formatting rules.

Improve — make it easier to accept

Before I hand this budget to finance, make the layout easier to scan. Put the totals and key KPIs…

Before I hand this budget to finance, make the layout easier to scan. Put the totals and key KPIs at the top of the visible area, apply consistent currency and percentage formats, and make cells that feed into totals distinct with a pale blue border. Flag any rows where currency and percentage formats are mixed. Also add a small legend explaining the color usage.

Decide — diagnose the stuck moment

I reformatted the budget for readability and finance replied that two totals no longer match the…

Finance emailed that numbers look off after I reformatted

I reformatted the budget for readability and finance replied that two totals no longer match the source because some input cells lost their currency format. I didn't want to freeze users out by changing formats. Should I revert formatting on those inputs, add protection to formula cells, or call a short review with the finance lead Elena? Which option stops reformatting from breaking totals with the least friction?

Become — change the pattern

Every month I fix formatting that others have inadvertently changed — dates turn into text,…

I constantly reapply formats after others edit the sheet

Every month I fix formatting that others have inadvertently changed — dates turn into text, currency gets stripped, and my summaries break. It costs me credibility and time. Should I start protecting key ranges, deliver a one-page formatting standard, or train the team on a single input form to keep formats intact? Which habit change will most reliably prevent this recurring cleanup?

Next to this one

Other spreadsheet work people do in Google Sheets.

Create templates for reuse Duplicate sheets within workbook Enter raw data rows Export sheet as CSV or PDF Filter rows by criteria Freeze header rows or columns Group and hide rows or columns Import CSV or Excel files Import live data via IMPORTRANGE Insert hyperlinks and bookmarks

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.

The rest of the map

Same library, five ways in.

Work Atlasthe whole map, interactive Careers1,949 jobs and their real tasks Soft skillsthe human part of the work Activities500 things people do Prompt Librarybrowse every prompt