# Google Sheets for Founders on Mac: Models, Cash Runway, and Shortcuts for 2026

> Google Sheets for founders on Mac, step by step: a cash runway formula, the ⌘ shortcuts, real limits, and how Lazur helps with questions on screen.

URL: https://www.lazur.app/for/founders/google-sheets
Updated: 2026-11-09

Google Sheets for founders on Mac runs in your browser, so there is nothing to install. Founders use it for early models: revenue, costs, cash runway, a basic three-statement model, and sharing the file with cofounders and advisors.

## Quick answer

- Founders mostly use Google Sheets for early models: revenue build, cost structure, cash runway, and a basic three-statement model.
- On a Mac, menu shortcuts use Ctrl+Option where Windows uses Alt. Command+Option+R hides or shows the menus.
- Build runway as cash divided by net burn, keep inputs in one labeled Assumptions tab, and guard the formula with IFERROR.
- Know the gaps. One vendor blog says Sheets lacks native XLOOKUP, and Google's own limit pages disagree on cell counts.
- Lazur points, guides, and answers out loud while you hold ⌥ ⌘. It does not click buttons or edit your sheet for you.

## What founders use Google Sheets for

Most founders use Google Sheets for early financial models. That usually means a revenue build, a cost structure, a cash runway calculation, and a basic three-statement model. The same file also becomes the thing everyone passes around. Cofounders edit it. Advisors comment on it. A fractional CFO may take ownership of the cost tabs.

Google Sheets on Mac runs in a browser tab, and Google keeps it updated for you. You do not install a version and patch it later. The trade-off is simple. Your file lives in Google Drive, so you need a connection, and sharing depends on the settings you choose.

Templates are the quickest start, but know what Google actually ships. Google's help page names CVs, budgets, and order forms as Google-created templates. To open one, open Sheets, click Template Gallery at the top right, and pick a template. A copy opens for editing, so your original stays clean. The same page does not mention invoice templates, so search the gallery before you assume one exists.

![Founder at a laptop reviewing a Google Sheets model for their startup, one of the tasks this page covers.](https://images.lazur.app/content-images/role-app/founders-google-sheets/google-sheets-for-founders-on-mac-1-c33cc8.jpg)

## Keyboard shortcuts for Google Sheets on Mac

On a Mac, most Google Sheets shortcuts use ⌘ (Command). Menu shortcuts that use Alt on Windows use Ctrl+Option on Mac instead. Some navigation needs the Fn key with the arrow keys. Google's shortcut page lists the full set. These are the ones founders reach for most often.

| Task | Mac shortcut | Why it helps a model |
| --- | --- | --- |
| Undo | ⌘Z | Reverses a bad paste before it spreads through your formulas |
| Find | ⌘F | Locates a line item like Payroll across a long sheet |
| Find and replace | ⌘⇧H | Renames a label everywhere in one pass |
| Fill down | ⌘D | Copies a formula down a column of months |
| Convert range to table | ⌘⌥T | Turns a block of rows into a table you can filter |
| Show or hide menus | ⌘⌥R | Gives you more room on a small screen |
| Show all shortcuts | ⌘/ | Opens the full list so you can search it |
| Tool finder | ⌥/ | Searches for a menu action by name |

_Shortcuts from Google's Sheets shortcut list. Confirm them with ⌘/ in your own browser._

Shortcut lists change, and some keys clash with browser shortcuts. If a key does nothing, press ⌘/ and search the list for the action you want. Learn a few at a time. Pick the ones that replace a menu trip you make every day.

Hold ⌥ ⌘ and ask Lazur what a shortcut does on screen. Lazur answers out loud. It does not press the keys for you, so you still do the work, with the answer in your ear.

## Building a cash runway formula in Google Sheets

Cash runway is how long your cash lasts at your current burn. The basic formula divides cash on hand by net monthly burn. Put cash in one cell, net burn in the next, and the runway in a third. Write the runway as a reference to those two cells, not as typed numbers. A typed number is invisible to the next reader.

Keep every input in an Assumptions tab. Each input gets its own labeled cell and, in the next column, a note on where the number came from. When a number changes, you change it once. Every other tab reads from it, so a forecast update does not break several tabs at once.

Edge cases matter more than the main formula. If net burn is zero, or the company is profitable, dividing by it returns an error or a meaningless figure. Wrap the formula in IFERROR and return a text label such as Not burning instead. Then check the sign. Some people enter burn as a positive number and others as a negative one. Pick one rule and write it in the label.

Name your key cells. Select the cash cell, then open Data > Named ranges and give it a name such as cash_today. The formula then reads as cash_today divided by net_burn. Your cofounder can read that without tracing cell addresses across tabs.

## A worked example: a runway check in one sitting

This setup takes one sitting. It uses cell addresses, not amounts, so you can drop in your own figures. Work through it in order, and check each step before you move on.

1. Open Google Sheets in your browser and start a blank file. Name it with the company name and the word Model.
2. Rename the first tab Assumptions. Put labels in column A and values in column B.
3. Enter cash on hand in B2 and net monthly burn in B3. Add the source of each number in column C.
4. In B4, type =IFERROR(B2/B3, "Not burning") and press Return. Check the result against a value you can calculate by hand.
5. Add a check cell in B5 that flags when B2 drops below zero. A red cell is easier to spot than a negative number in a long row.

Test the setup before you trust it. Set net burn to a value you know well and check the runway by hand. Then clear net burn and confirm the label appears. If burn is negative, the runway comes out negative, so add a check for that case too.

## Where Google Sheets falls short for a financial model

A vendor blog on Excel and Google Sheets for startup models lists several gaps. It says Sheets lacks native XLOOKUP. It says Sheets has no equivalent to Excel's Data Table for sensitivity analysis, or to Power Query. It also says large models slow down past about 10k formula cells. That last point is the blog's claim, not measured data, so test your own file.

Check the function list yourself before you plan around a gap. Type the function name into a spare cell and see whether Sheets recognizes it. Vendor blogs age quickly, so the claim may be out of date by the time you read it.

You can cover most sensitivity questions with scenarios instead of a Data Table. Put a scenario cell at the top of the Assumptions tab. Add a dropdown with options such as Base, Downside, and Upside. Then point each key input at the value for the chosen scenario with an IF or INDEX formula. For the dropdown steps, see [how to create a dropdown list in Google Sheets on Mac](https://www.lazur.app/how-to/create-a-dropdown-list-in-google-sheets).

If your numbers live in a database, Connected Sheets may save you a copy-paste routine. Google's product page says it connects to BigQuery or Looker data without SQL. The same page lists third-party connections to QuickBooks, HubSpot, Salesforce, and Asana. Check which connections your plan includes before you build around one.

## Cell limits in Google Sheets to check before the model grows

Cell limits cause the most confusion. In March 2022, Google raised the cell limit from up to 5 million cells to up to 10 million. It said the change applied to new, existing, and imported files. Google's file limits page now says up to 20 million cells or 100MB. The pages disagree, so check the limits page before you plan a large model.

Other limits matter sooner for founders who pull data in. Connected Sheets extracts cap at 500k rows or 5 million cells. Pivot tables cap at 200k rows. Importing an Excel file removes any cell with more than 50,000 characters, so a long note pasted into one cell can disappear.

When a file gets slow, look at the formula count first. Long chains of IMPORTRANGE, array formulas, and whole-column references add load. Replace whole-column references with fixed ranges that stop at the last row you use.

- **22%** of operations professionals deal with spreadsheet errors daily, per a 2026 DOSS survey ([source](https://en.wikipedia.org/wiki/List_of_spreadsheet_mistakes))
- **20 million** cells, the file limit on Google's help page, which conflicts with the 10 million figure from 2022 ([source](https://support.google.com/docs/answer/37603?hl=en))
- **59%** of survey respondents named manual data entry as the most common spreadsheet error ([source](https://en.wikipedia.org/wiki/List_of_spreadsheet_mistakes))

## Sharing with cofounders, advisors, and investors

Sharing is where Sheets is strongest. Several people can edit at once. Changes are recorded in revision history, so you can see who changed a cash figure and when. The vendor blog contrasts this with Excel, where people often keep manual saved copies. For the steps, see [how to see revision history in Google Sheets on Mac](https://www.lazur.app/how-to/see-revision-history-in-google-sheets).

Investors read the file too. The same blog calls Excel the standard for formal diligence. It says a Google Sheets link at a Series A is not a disqualifier, but it is unusual. Plan for that. Keep an Excel export ready for diligence, and label it as a copy. The steps are in [how to download Google Sheets as Excel on Mac](https://www.lazur.app/how-to/download-as-excel-in-google-sheets).

![A Mac laptop on a desk, the usual setup for Google Sheets work on a founder's own machine.](https://images.lazur.app/content-images/role-app/founders-google-sheets/google-sheets-for-founders-on-mac-3-d64e36.jpg)

Advisors who only need to look should get view-only access. Edit rights belong with the people who own a tab. Set that before you send the link, not after. The sharing steps are in [how to share a Google Sheet view only on Mac](https://www.lazur.app/how-to/share-with-view-only-access-in-google-sheets).

## Mistakes founders make in shared sheets

- Typing numbers inside formulas. A growth rate hidden in a formula stays hidden from the next reader.
- Mixing actuals and forecasts in one column. Give each type its own column, and shade forecast cells so nobody confuses them.
- Copying a whole tab to make a new version. The copies drift apart fast. Use a scenario cell instead.
- Deleting rows that other formulas point to. Hide them instead, using [hide rows and columns in Google Sheets on Mac](https://www.lazur.app/how-to/hide-rows-and-columns-in-google-sheets).
- Ignoring error cells. One #REF in a summary total can sit unnoticed for weeks.
- Giving everyone edit access by default. Start with view access and widen it on purpose.

## Gemini in Sheets: useful for formulas, not for judgment

Google's product page says Gemini in Sheets can build or edit a spreadsheet from a prompt. It can fill tables with summarized or categorized data, write formulas, explain errors, and surface insights. Some of these features need a Google Workspace plan, so check your account before you plan around them.

Use it for the mechanical work. Ask it to explain an error or write a lookup formula, then test the result on inputs you already know. Do not let it set your growth rate or your hiring plan. Those decisions belong to you, and your cofounders should see the reasoning behind them.

## Spreadsheet errors are common, so build checks into the file

Spreadsheet errors are common. A 2026 survey by business-operations startup DOSS found that 22% of operations professionals deal with spreadsheet errors daily. In that survey, 59% named manual data entry as the most common error. Spreadsheet formulas came second, at 46%. These figures come from a Wikipedia summary, so check the original before you quote them.

Wikipedia also cites a 2017 study that found up to 90% of spreadsheets had errors affecting their results. Wikipedia cites a ZDNet article rather than the study itself. Treat that number as secondhand.

Build checks you can see. Add a cell that compares a column total with the source total. Add a balance check across your three statements. Color a cell red when cash turns negative. A check that fails loudly is worth more than a summary that looks neat.

![Cofounders reviewing a Google Sheets financial model together at a table, planning cash runway.](https://images.lazur.app/content-images/role-app/founders-google-sheets/google-sheets-for-founders-on-mac-2-532ff1.jpg)

## Using Lazur during a Google Sheets model review

Lazur works beside Google Sheets, not inside it. Hold ⌥ ⌘ and ask about anything on screen. Lazur listens and looks at the screen only while you hold the shortcut, then answers out loud. Ask where a row is, and Lazur draws a circle and a label around it. Ask how to do something, and Lazur guides you one click at a time, waiting for each click.

Lazur does not click buttons, edit files, or operate other apps for you. Hold fn to dictate clean text at the cursor in any app. Dictation fits notes like a label for a new tab or a comment for a cofounder. Lazur can also draft a longer message and type it where your cursor sits.

For questions that need reading, Lazur runs research in its own Chrome tabs and returns a summary and a report. Use that for questions like how other early-stage teams set up runway tabs. Check each source before you put a figure in a board deck.

## Before you send the model: a short checklist

1. Confirm every input sits in the Assumptions tab, with a label and a source note.
2. Search the file for typed numbers inside formulas, and move them into inputs.
3. Search for #REF, #DIV/0, and #N/A errors before you share.
4. Check that the cash check cell flags negative cash.
5. Set advisors to view-only. Give edit access to the people who own a tab.
6. Export an Excel copy if an investor may ask for one, and label it as a copy.

## Where to go next

Start with one tab. Build the Assumptions tab first, then the runway formula, then the check cells. Each step fits in one sitting, and each one makes the next easier. When a Mac-specific step gets in the way, use the guides linked above, or ask Lazur to walk you through it. Lazur's plans and trial are on [the pricing page](https://www.lazur.app/pricing), and the app is on [the download page](https://www.lazur.app/download).

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Lazur, why does this cell say DIV/0?”: Lazur reads the formula on screen and says out loud that net burn is blank, so the runway division has nothing to divide by. It suggests a label instead of an error. (Explains what's on screen)
- “Lazur, what does this formula actually calculate?”: Lazur reads the formula on screen and explains each part out loud, including what the cell references point to.
- “Lazur, where is the net burn row?”: Lazur draws a circle and a label around the row, so you can find it without scanning every tab.
- “Lazur, walk me through making a filter on this range.”: Lazur guides you one click at a time and waits for each click before it moves on.
- “Lazur, why does this cell show a DIV/0 error?”: Lazur explains that the divisor is zero or blank, and points you to the input cell to check.
- “Lazur, draft a note to my cofounder about the burn change.”: Lazur drafts the message in plain language, then types it where your cursor sits when you ask.
- “Hold fn, say the assumption, then release.”: Dictation types clean, formatted text at your cursor, so the note lands in the cell or comment you chose.
- “Lazur, look up how early-stage teams set up runway tabs.”: Lazur runs the search in its own Chrome tabs and returns a summary and a report to check.
- “Lazur, remind me to update the runway tab on Friday.”: Lazur adds the reminder to Apple Reminders, so the update does not slip past the week.

## FAQ

### Is there a Google Sheets app for Mac?

Google Sheets on Mac works in a browser tab, and Google keeps it updated for you. Bookmark Sheets in your browser to get there quickly. The steps in this guide assume you use it in the browser.

### Which shortcut shows every Google Sheets shortcut on Mac?

Press ⌘/ in Google Sheets to open the shortcut list, then search it for the action you want. Option+/ opens the tool finder, which searches menu actions by name. If a key does nothing, check the list first.

### How do I calculate cash runway in Google Sheets?

Divide cash on hand by net monthly burn. Put each number in its own labeled cell, then write the runway formula as a reference to those cells. Wrap it in IFERROR so zero burn returns a label instead of an error. Check the sign of burn too.

### Does Google Sheets have XLOOKUP and a Data Table?

A vendor blog on startup models says Sheets lacks native XLOOKUP and has no equivalent to Excel's Data Table. Test the function in a spare cell, because the claim may be out of date. For sensitivity questions, use a scenario cell with a dropdown.

### What is the cell limit in Google Sheets?

Google announced a rise to 10 million cells in March 2022. Its file limits page now says up to 20 million cells or 100MB. The pages disagree, so check the limits page before you plan a large model. Excel imports also remove cells over 50,000 characters.

### Will investors accept a Google Sheets model?

A vendor blog says Excel is the standard for formal diligence, and a Sheets link at a Series A is not a disqualifier but is unusual. Keep an Excel export ready. Investor expectations vary, so ask your advisor what they prefer.

### Can Lazur edit my Google Sheet for me?

No. Lazur does not click buttons, edit files, or operate other apps. It points at things, guides you one click at a time, answers out loud, and drafts or types text when you ask. You still make the edits.

### Are the spreadsheet error statistics reliable?

The 22% and 59% figures come from a 2026 DOSS survey, read through a Wikipedia summary. Check the original survey before you quote it in a deck. The 90% figure comes from a 2017 study cited through a ZDNet article, so treat it as secondhand.

## Sources

1. [Google Workspace - Google Sheets](https://workspace.google.com/products/sheets/), Google, checked 2026-11-09
2. [Keyboard shortcuts for Google Sheets (Computer)](https://support.google.com/docs/answer/181110?hl=en), Google Docs Editors Help, checked 2026-11-09
3. [Create a file from a template](https://support.google.com/docs/answer/148833?hl=en-GB), Google Docs Editors Help, checked 2026-11-09
4. [Google Docs Editors Help: file size and cell limits](https://support.google.com/docs/answer/37603?hl=en), Google Docs Editors Help, checked 2026-11-09
5. [Google Workspace Updates: Google Sheets doubles cell limit](https://workspaceupdates.googleblog.com/2022/03/ten-million-cells-google-sheets.html), Google Workspace Updates Blog, checked 2026-11-09
6. [Excel vs. Google Sheets for Startup Financial Modeling](https://www.raisereadybook.com/blog/excel-vs-google-sheets-for-startup-financial-modeling-the-honest-answer.html), Raise Ready (vendor blog), checked 2026-11-09
7. [List of spreadsheet mistakes](https://en.wikipedia.org/wiki/List_of_spreadsheet_mistakes), Wikipedia, checked 2026-11-09