# Google Sheets for event planners on Mac: shortcuts, limits, and what to ask Lazur

> Set up Google Sheets for event planning on your Mac. Covers templates, Mac shortcuts, size limits, the calculation setting to check, and what to ask Lazur.

URL: https://www.lazur.app/for/event-planners/google-sheets
Updated: 2026-11-06

Google Sheets works well for event planning on a Mac if you give each event its own file. Use it for budgets, vendor lists, and run of show schedules. Keep one master copy that you never edit, then duplicate it for each new event. This page covers setup, the Mac shortcuts worth learning, the limits you can hit, and what to ask Lazur while you work.

## Quick answer

- Start from a template, then use File > Make a copy so the master stays clean.
- Learn ⌘+D, ⌘+R, and ⌘+Option+= first. They cover most daily edits in a long vendor list.
- A spreadsheet tops out at 20 million cells or 100MB, so split big multi-event work into separate files.
- Check File > Settings > Calculation Settings before you trust a total, since manual calculation is off by default.
- Ask Lazur where things are, how to do a step, or to dictate notes while you work in the sheet.

Google Sheets works well for event planning on a Mac if you give each event its own file. Use it for budgets, vendor lists, and run of show schedules. Keep one master copy that you never edit, then duplicate it for every new event. The rest of this page shows how to set that up, which Mac shortcuts earn their keep, and where the limits sit.

Think of the file as a working document, not a database. A single event fits in one file with a few tabs. Trouble starts when one file holds several events, a long vendor list, and months of notes. Plan for that early, so you do not rebuild in the middle of a busy season.

## Start from a template, then make your own copy

Open the Template Gallery from the top right of Google Sheets. Pick a template, and a copy opens in your account. Google's template help page describes this flow, so use it as your reference when a menu looks different.

Your first edit should never touch the master. Use File > Make a copy to save your work to a new file. Name the copy with the event name and the date, so you can find it later in Drive.

Google's template page says some template features only work for work or school accounts. It does not mention event planning templates at all. Search the gallery for event, budget, or schedule and see what comes up. Treat third-party event templates as drafts until you check every formula yourself.

> **Keep a master file:** Never type into the master. Duplicate it for each event, so old numbers never carry into a new budget.

## Build the tabs every event needs

Most event work fits into a few tabs. Budget tracks money. Vendors tracks contacts, contracts, and deposits. Run of show tracks times, tasks, and owners. Add more tabs only when a real job needs them.

Give the budget tab the same columns every time. Item, Vendor, Estimate, Deposit, Paid, and Balance cover most cases. Make Balance a formula that subtracts Paid from Estimate. Do not type it by hand, because a typed number goes stale the moment a payment changes.

Put totals in their own area, outside the columns they add up. A whole-column formula such as =SUM(D:D) placed inside column D counts itself, and Sheets flags that as a circular reference. For a total by vendor, write =SUMIF(B:B,"Caterer",D:D) in a cell outside columns B and D.

Keep the vendor tab to one row per vendor. Store each phone number once. When a vendor changes, edit that row, instead of fixing the budget and the run of show separately. Duplicate entries are where most planners lose time.

Run of show works best with one row per task. Put the time in one column, the task in the next, and the owner after that. Use View > Freeze so the header row stays visible while you scroll on a laptop screen.

![Event planner using Google Sheets for event planners on Mac at a laptop](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/event-planners-google-sheets/google-sheets-for-event-planners-on-mac-1-0130f0.jpg)

## Mac shortcuts for Google Sheets

These shortcuts come from Google's keyboard shortcut page for Computer. They use the Command key, so they fit how a Mac works. Learn the first few well before you chase the rest.

- ⌘+D fills the selected cells down from the top cell.
- ⌘+R fills the selected cells right from the left cell.
- ⌘+Option+= inserts rows when rows are selected.
- ⌘+Option+M inserts a comment.
- ⌘+F opens find, so you can jump to a vendor name.
- ⌘+Z undoes your last change.
- ⌘+/ opens the full shortcut list.

Fill down is the one to practice. Type a formula in the first row, select the range below it, then press ⌘+D. The formula copies down without any dragging. That saves real time on a long vendor list.

If a shortcut does nothing, click a cell first. Focus often sits on the address bar or a menu, so the keys never reach the grid.

Forgot a shortcut mid-task? Hold ⌥ ⌘ and ask Lazur. It answers out loud, so your hands stay on the keyboard. Lazur looks at your screen only while you hold the shortcut.

![Person typing on a Mac keyboard while reviewing a spreadsheet of event vendors](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/event-planners-google-sheets/google-sheets-for-event-planners-on-mac-2-53ffc7.jpg)

## Google Sheets limits for big events

Google Drive Help says a spreadsheet in Google Sheets holds up to 20 million cells, or 100MB. Most event budgets never come close. A long run of notes, pasted contract text, and several events in one file can get there faster than you expect.

| Limit | Number | What it means for you |
| --- | --- | --- |
| Cells per spreadsheet | 20 million or 100MB | Split a multi-event file into separate files before you hit it |
| Pivot tables in Connected Sheets | 200,000 rows | Mostly relevant to BigQuery and Looker data, not budgets |
| Connected Sheets extracts | 500,000 rows or 5 million cells | Filter the data before you extract it |
| Text in one cell from an Excel import | 50,000 characters | Cells over this limit are removed on conversion |

_Limits from Google Drive Help, Google Sheets limits page._

Google's product page describes Connected Sheets as a tool for BigQuery and Looker data. Most planners never use it, so the pivot row limit rarely matters for a budget.

Excel imports carry the biggest risk. Converting an Excel file to Sheets removes any cell with more than 50,000 characters. Check long cells before you convert, and move long contract text into a document that you link from the vendor row.

> **Check before you convert:** Open the Excel file and look for long notes in cells. Those cells are removed on conversion, so find them first.

## Is Google Sheets enough for vendor work?

Vendor blogs make strong claims about spreadsheets. Abastio says planners using spreadsheets spend 8 to 12 hours a week on data entry, version management, and cross-referencing. It cites no original study for that figure.

The same post says manual data entry carries a 1% to 3% error rate. It also says spreadsheets tend to break down past about 3 simultaneous events or 10 regularly coordinated vendors. Treat those as the seller's claims, not measured facts.

- **20 million** cells per spreadsheet, or 100MB, the Google Sheets file cap ([source](https://support.google.com/drive/answer/37603))
- **8 to 12 hours** a week on spreadsheet admin, per Abastio. A vendor claim with no original study ([source](https://abastio.com/blog/outgrown-spreadsheets-event-planning))
- **50,000 characters** per cell. Excel files lose any cell above this limit on conversion ([source](https://support.google.com/drive/answer/37603))
- **1% to 3%** manual data entry error rate, per Abastio's vendor blog ([source](https://abastio.com/blog/outgrown-spreadsheets-event-planning))

Here is a practical test. Count how often you retype the same contact, deposit, or date in a month. If that count is high, fix your process before you buy anything. A clean set of tabs handles a single event with a modest vendor list well.

If you look at dedicated event software, read each product's pricing and feature pages directly. Do not rely on a comparison post, including this one, for current prices or features.

## Google Sheets calculation settings to check first

Google announced a manual calculation setting for Sheets in September 2026. It is off by default. You turn it on at File > Settings > Calculation Settings.

Google says the setting reaches Workspace customers and Workspace Individual subscribers in a gradual rollout. Visibility can take up to 15 days, starting September 21, 2026. Admins cannot control it, so check your own account.

Why it matters: with manual calculation on, formulas may not update the way you expect. Open the setting before you send a budget to a client or a caterer. Then confirm one total by checking it against your own receipts.

> **Do not trust a total blindly:** A total that looks right can be stale. Confirm the calculation mode, then check one line by hand before you share the file.

## Sharing and offline access in Google Sheets

Google's product page lists co-editing with sharing permissions and revision history. Use both when a co-planner, a venue contact, and a client touch the same file. Permissions decide who can change what.

Give vendors view access when they only need the schedule. Give edit rights to your co-planner and no one else. Revision history lets you roll back a bad paste, so check it before you assume a row is gone.

Offline access is on the same product page. Test it before you need it. Open the file, turn off Wi-Fi, and see what you can still edit. Do that a week before a site visit, not on the day.

Gemini in Sheets appears on the product page too. Some Gemini features need a Workspace plan, so check your plan before you count on them.

## What to ask Lazur while you work in Sheets

Lazur is a voice assistant for the Mac. Hold ⌥ ⌘ to ask about anything on screen. Lazur sees your screen while you hold the shortcut, points at things, and answers out loud.

It does three useful things in a sheet. It points, so you find the menu or the button. It guides you one click at a time and waits for each click. It drafts and dictates text. Lazur does not click buttons or edit your sheet for you.

Hold fn to dictate clean, formatted text at the cursor. Speak a run of show note, then check the cell before you move on. Notes read better later when they come out formatted the first time.

Privacy matters with client budgets. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and are not stored. Content is never used to train AI models. Still, redact client names and bank details before you ask about them.

Lazur runs on macOS, on Apple silicon and Intel Macs. Windows is planned, not available. Get it from the [download page](https://www.lazur.app/download), and check plans on the [pricing page](https://www.lazur.app/pricing).

## Mistakes planners make in Google Sheets

- Editing the master template instead of a copy. Use File > Make a copy first.
- Sharing with edit rights when view access is enough.
- Trusting a total without checking the calculation setting.
- Retyping a phone number or deposit in two tabs. Store it once and reference it.
- Pasting a whole Excel file without checking for long cells.
- Keeping every event in one giant file. Split by event so you can archive old ones.
- Skipping the offline test until the day you need it.

Most of these come from speed. A quick fix in the wrong file can cost a whole morning. Slow down for a couple of minutes at the start, and the rest of the event runs smoother.

![Desk with paper notes and a laptop used for planning an event schedule](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/event-planners-google-sheets/google-sheets-for-event-planners-on-mac-3-45a9dd.jpg)

## A short weekly routine that keeps the file clean

Spend a short block each week on the file. Check the vendor tab for open items, update the Paid column, and clear finished tasks from the run of show. Do it at the same time each week so the habit sticks.

Then open revision history and scan for changes you did not make. This takes a few minutes. It catches the quiet errors that show up on event day, when there is no time to find them.

## When to move beyond Google Sheets

Move on when the file slows you down, or when the same data lives in too many places. The vendor figures above give a rough signal, but your own count is better. Track retyping and missed follow ups for a month before you decide.

Sheets can still be the right tool after that. Many planners keep Sheets for budgets and use a separate tool for vendor messages. Decide based on where your time goes, not on a blog's headline number.

## Next steps for your event planning spreadsheet

1. Make a master template and duplicate it for your next event.
2. Learn ⌘+D and ⌘+Option+= first, then practice on a test tab.
3. Open File > Settings > Calculation Settings and confirm the mode.
4. Set vendors to view access only.
5. Try Lazur on your Mac from 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

- “Where is the setting that stops my totals from updating on their own?”: Lazur circles the File menu and points at Settings, then names File > Settings > Calculation Settings. It does not change the setting for you. (Points at it)
- “Where is Make a copy in this menu?”: Lazur circles the File menu and points at Make a copy, so you duplicate the template before you edit it.
- “Walk me through freezing the header row.”: Lazur guides you one click at a time through View > Freeze and waits for each click before it continues.
- “What does this SUMIF formula do?”: Lazur reads the formula on screen and explains which column it totals and which vendor it matches.
- “Dictate a note: deposit due before the venue walk-through.”: Hold fn and speak. The text lands at the cursor, clean and formatted, in the cell you picked.
- “Draft a note to the caterer asking to confirm headcount.”: Lazur drafts the text. You read it, change what you need, and send it yourself.
- “Find the venue's loading dock rules and summarize them.”: Lazur runs the research in its own Chrome tabs and returns a summary and a report you can check against the venue.
- “Remind me to confirm the florist on Friday.”: Lazur adds the reminder in Apple Reminders for the time you name.
- “What shortcut fills a formula down?”: Lazur answers out loud: ⌘+D fills the selected cells down from the top cell.

## FAQ

### Does Google Sheets work on a Mac for event planning?

Yes. Google Sheets works on a Mac, and the shortcuts on this page use the Command key. Check Google's product page for the features your account includes, since some Gemini features need a Workspace plan.

### What is the best Google Sheets template for event planners?

Google's help pages do not name an event planning template. Open the Template Gallery at the top right, search for event, budget, or schedule, then use File > Make a copy. Treat third-party templates as drafts and read every formula before you rely on one.

### How many cells can a Google Sheets file hold?

Google Drive Help says spreadsheets in Google Sheets are limited to 20 million cells or 100MB. Split a large multi-event file into separate files before you reach either limit.

### Why did my Excel import lose text?

Google says converting an Excel file to Sheets removes any cell with more than 50,000 characters. Check long cells before you convert, and move long contract text into a document you can link from the sheet.

### What does ⌘+D do in Google Sheets?

⌘+D fills the selected cells down from the top cell. Type a formula once, select the range below it, then press ⌘+D to copy it down the column.

### Where is the manual calculation setting in Google Sheets?

Go to File > Settings > Calculation Settings. Google says the setting is off by default. It started rolling out September 21, 2026, and can take up to 15 days to appear on an account.

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

No. Lazur does not click buttons, edit files, or operate other apps for you. It points at things, guides you one click at a time, answers out loud, and drafts or dictates text.

### Is it safe to ask Lazur about a client budget?

Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and are not stored. Redact client names and bank details before you ask.

### Is Lazur available on Windows?

Not yet. Lazur runs on macOS, on Apple silicon and Intel Macs. Windows is planned, but it is not available today.

### Are the vendor numbers about planner time reliable?

They are vendor claims. Abastio cites no original study for its 8 to 12 hours a week figure. Use those numbers as a prompt to audit your own process, not as proof.

## Sources

1. [Google Workspace: Google Sheets product page](https://workspace.google.com/products/sheets/), Google, checked 2026-11-06
2. [Keyboard shortcuts for Google Sheets: Computer](https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-06
3. [Use templates: Computer, Google Docs Editors Help](https://support.google.com/docs/answer/148833?hl=en&co=GENIE.Platform%3DDesktop), Google, checked 2026-11-06
4. [New manual calculation setting in Google Sheets](https://workspaceupdates.googleblog.com/2026/09/new-manual-calculation-setting-in-Google-Sheets.html), Google Workspace Updates, checked 2026-11-06
5. [Google Drive Help: Google Sheets limits](https://support.google.com/drive/answer/37603), Google, checked 2026-11-06
6. [5 Signs You've Outgrown Spreadsheets for Event Planning](https://abastio.com/blog/outgrown-spreadsheets-event-planning), Abastio (vendor blog), checked 2026-11-06