# Excel for accountants on Mac: fixing errors and closing the month in Microsoft 365

> Excel for accountants on Mac in Microsoft 365: the shortcuts that differ, the errors to catch, and how Lazur helps by voice.

URL: https://www.lazur.app/for/accountants/excel
Updated: 2026-11-06

Excel for accountants on Mac runs the same core formulas as the Windows version, but the keyboard is where time disappears. Command replaces Ctrl for most shortcuts, function keys need the fn key, and a few Windows shortcuts clash with macOS defaults. This guide covers those differences, the errors that show up most in finance work, and how Lazur helps while the sheet stays open.

## Quick answer

- Mac Excel uses Command for most shortcuts, and some Windows shortcuts clash with macOS.
- Most MacBooks need fn for F-keys, and arrow keys move between cells only when Scroll Lock is off.
- Check text numbers, stray spaces and duplicates before you trust a total.
- Lazur sees the sheet when you hold ⌥ ⌘, answers out loud and points at cells. It does not click buttons or edit cells for you.

Start with the Mac problems. They cost more time than most formula bugs. Microsoft's support pages say some Windows shortcuts clash with default macOS shortcuts. They also say function keys need the fn key, and that the shortcuts assume a US keyboard layout. If your layout differs, some keys will not match the guide, so check that first.

## Excel shortcuts on Mac for accountants

Most Mac shortcuts use Command. Control shows up in only a few entries. The table covers the keys you press most when you reconcile, filter and recalculate. Confirm each one on your own build, because guides date quickly.

| Task | Windows | Mac in Microsoft 365 |
| --- | --- | --- |
| Edit the active cell | F2 | Control+U |
| Toggle absolute references | F4 | F4 in newer Mac builds. Older guides list Command+T. |
| Turn filters on or off | Ctrl+Shift+L | Control+Shift+L, which Excel 365 for Mac adopted |
| Recalculate all sheets | F9 | fn+F9 |
| Move between cells | Arrow keys | Arrow keys, but only when Scroll Lock is off |

_Mac shortcuts for common Excel tasks. Sources: Exceljet and Microsoft Support._

The table is a start, not a full list. Exceljet notes that Windows KeyTips, the Alt letter codes you use on Windows ribbons, have no Mac equivalent. Do not spend time guessing Alt sequences. Use the menu bar, or ask Lazur where a command lives.

## Fix the Scroll Lock trap before you start

If the arrow keys scroll the sheet but the selection stays put, Scroll Lock is on. Microsoft says arrow keys move between cells only when Scroll Lock is off. Toggle it with Shift+F14. MacBook users may need a USB keyboard to reach F14, so keep one nearby for close week.

> **Scroll Lock check:** A stuck arrow key looks like a broken sheet. Check Scroll Lock before you rebuild any formula or table.

## Clean the data before you trust a total

Most wrong totals start with bad data. A number stored as text adds up as zero. A customer name with a trailing space fails every lookup. A date that looks right can sort in the wrong order. Finding these by eye is slow, and the errors hide in long columns.

![Accountant checking figures in a spreadsheet on a laptop, the kind of Excel for accountants on Mac work this guide covers](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/accountants-excel/excel-for-accountants-on-mac-1-0831a3.jpg)

The scale of the problem is measurable. A Datarails survey of 212 US and UK finance professionals found that 81% spend six or more hours a month correcting Excel errors. Datarails sells alternatives to spreadsheets, so treat that figure as self-reported. Panko's audit summary is less commercial. Across nine field audits, the page text puts the share of spreadsheets with errors at 84%, and cell error rates ran from 0.2% to 2.5%. Other summaries quote different numbers, so cite Panko's page directly.

Audit software does not solve it. Aurigemma and Panko's 2010 study found that Excel Error Check and Spreadsheet Professional were almost useless for flagging natural human errors. Use a checker as a first pass. Then read the logic yourself, with a second person if you can.

> **Audit tools are not a sign off:** A clean report from an audit tool does not mean the numbers are right. The study describes these tools as almost useless for flagging human errors.

## Microsoft 365 for Mac tools for messy data

Microsoft's October 2026 What's New in Excel post makes two points that matter here. Table naming at creation, previously an Insider feature, now reaches Excel for Windows and Mac users. The Copilot clean data skill finds and fixes data issues that break formulas, lookups and PivotTables. Microsoft says it is rolling out to general availability on all platforms.

Name the table when you create it, so your formulas read clearly. A table called Ledger_Mar is easier to audit than Table1. If your build only lets you rename after creation, rename it right away. The clean data skill works best on a tidy table, so name first, then clean.

## Lookups and bank reconciliations where formulas break

Here is a common case. A lookup returns #N/A for a customer you can see on the sheet. The lookup cell reads Acme. The list reads Acme with a trailing space. Excel treats those as different values. Wrap the lookup cell in TRIM, or clean the export before the match, and the lookup finds it.

Public sources on bank reconciliation in Excel are thin. The surveys cited on this page cover finance teams in general, not accountants. Treat the steps below as a method to test on your own data, with your firm's controls on top.

1. Export both sides as CSV, one row per transaction, with the same date format.
2. Clean both lists. Trim spaces, convert text numbers and remove exact duplicates.
3. Add a helper column with a match key, such as the date and amount together.
4. Run the match, then filter for #N/A to see what did not pair up.
5. Move each unmatched item to its own tab with a reason, such as timing or a bank fee.

Expect timing differences and rounding. A payment that cleared after month end is a timing item, not an error. Two amounts that differ by a cent often come from rounding. Record the difference and its cause. Do not force the amounts to match.

Size matters too. Excel holds up to 1,048,576 rows and 16,384 columns on each worksheet. That limit is high, but a combined export for many clients can still pass it. Split the file by client or month before you import.

| Worksheet limit | Maximum |
| --- | --- |
| Rows | 1,048,576 |
| Columns | 16,384 |

_Limits from Microsoft's specifications page for Microsoft 365 and recent Excel versions._

## Read a formula you did not write

Inherited workbooks cause most of the surprises at close. Start at the total, then work backward. Click the cell and look at the formula bar. To see the formula in edit mode, press F2 on Windows or Control+U on Mac. Press Escape to leave without changing anything.

Watch for ranges that stop one row short. A SUM that ends above a new line drops that line without any warning. Convert the source list to a table with Insert > Table. The formulas that point at the table grow with the data, so new rows get counted.

Ask Lazur to read the formula out loud when the logic is unclear. Lazur explains each argument in plain words and points at the cells it refers to. Then check one result by hand against the source document. An explanation is a reading aid, not a review.

## Pivot tables for ledgers and month-end review

A pivot table turns a ledger into account totals without a single formula. Start from a named table. Then choose Insert > PivotTable. Put account in Rows, debit and credit in Values, and period in Filters. For step-by-step detail, read [how to make a pivot table in Excel on Mac](https://www.lazur.app/how-to/make-a-pivot-table-in-excel).

Refresh after you change the source. Choose Data > Refresh All to update every pivot in the file. A pivot that looks wrong usually has a source problem. A range that stops above the last row drops lines. A total row sitting inside the data counts twice.

## Templates and the Money in Excel problem

Many accountants search for a budget template and find Money in Excel. Microsoft ended that feature on June 30, 2023. New accounts cannot connect, and new transactions stop arriving. Microsoft points to budget templates in Microsoft 365 instead. Its free templates page lists calendars, invoices and budgets for Excel for the web. That page does not cover Mac desktop use.

## Where Lazur fits while you work in Excel

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ to ask about anything on screen, and Lazur answers out loud. Ask where a command lives, and Lazur draws a circle and a label around it. Ask how to do something, and it guides you one click at a time, waiting for each click.

Lazur does not click buttons, edit files or work inside Excel for you. You make each change. Lazur explains what it sees and points at what you need. That split suits client files, where a person should make every edit.

![Office worker at a desk with a laptop, working through Excel for accountants on Mac during a busy week](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/role-app/accountants-excel/excel-for-accountants-on-mac-2-95a172.jpg)

Dictation works in any app. Hold fn to dictate clean, formatted text at the cursor. Use it for a variance note in a comment cell or a journal memo. Snippets and a personal dictionary help with account names and client codes that a spell checker does not know.

Here is a real sheet moment. You have a reconciliation tab open and the totals look off. Hold ⌥ ⌘ and ask which total does not match the bank. Lazur circles the closing balance cell, labels it and reads the figure out loud. You then check the formula yourself.

Privacy matters on client work. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models. Still check your firm's policy before you put client data in any AI tool.

## Mistakes accountants make on a Mac

- Pressing Windows shortcuts on a Mac. Command is the main key, and some Windows combinations clash with macOS.
- Forgetting fn for F-keys. Default Mac function keys control brightness and volume.
- Trusting a total because it looks neat. Check one row by hand against the source.
- Pasting values over a live formula. Work in a copy when you clean a column.
- Copying formulas with the wrong reference type. Lock the reference with F4, or Command+T in older guides.
- Saving over last month's file. Keep a dated copy before each close.

## Check your Excel version before you follow a guide

Guides date quickly. Exceljet's Mac shortcut guide was updated in October 2023 and calls the app Excel 365. Microsoft now writes Microsoft 365 for Mac. To see your build, open Excel > About Excel. Compare any shortcut against that version before you rely on it during close.

## A month-end routine for Excel on Mac

1. Save a dated copy of the workbook before you start.
2. Turn Scroll Lock off and confirm the arrow keys move the selection.
3. Name the tables, then run the clean data skill or check for text numbers and stray spaces.
4. Rebuild the reconciliation match on a helper key, and log every unmatched item.
5. Refresh pivots and check one total against the ledger by hand.
6. Ask Lazur to explain any formula you did not write before you sign off.

Next steps are simple. [Download Lazur](https://www.lazur.app/download) for the Mac, check the trial and plans on the [pricing page](https://www.lazur.app/pricing), and read the [AI assistant for Excel on Mac](https://www.lazur.app/apps/excel) page. For more help with Excel on Mac, see [Excel help for accountants on Mac](https://www.lazur.app/for/accountants).

## 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

- “Which total on this sheet doesn't match the bank?”: Lazur circles the closing balance cell, labels it, and reads the figure out loud. You decide what to change. (Points at it)
- “Where is Remove Duplicates on this sheet?”: Lazur circles the Data tab and labels Remove Duplicates, then waits while you click through.
- “Why is this lookup returning #N/A?”: Lazur reads the formula and the visible cells, then says what may differ, such as a trailing space.
- “Walk me through a pivot table by account.”: Lazur guides you one click at a time, waiting for each click, until the table shows account totals.
- “Which cells in column D are stored as text?”: Lazur points at cells that look like numbers but may be text, and explains how to convert them.
- “Read the closing balance and the bank balance out loud.”: Lazur reads both figures out loud and says whether they differ.
- “Draft a variance note for the reviewer.”: Lazur drafts a short note with the amount, the cause you describe, and the next step.
- “Dictate the journal memo for this accrual.”: Your words land at the cursor as clean text, with account names from your personal dictionary.
- “Explain what this SUMIFS in row 12 is doing.”: Lazur reads the formula on screen and explains each argument in plain language.
- “Remind me to send the bank rec before Friday.”: Lazur adds an Apple Reminders item with the time you say.

## FAQ

### Does Excel for Mac have the same shortcuts as Windows?

Not exactly. Most Mac shortcuts use Command, and some Windows shortcuts clash with macOS defaults. Microsoft's keyboard shortcut pages list the differences, and Exceljet's Mac guide covers the common ones. Check your own build before you rely on a shortcut.

### Can Lazur fix my formulas or click buttons in Excel?

No. Lazur guides, points, explains and answers out loud. It does not click buttons, edit files or operate Excel for you. You make each change, and Lazur waits for each click when it walks you through a task.

### Why does my VLOOKUP return #N/A when the value is on the sheet?

Usually the two values differ in a way you cannot see. A trailing space, a number stored as text, or a different date format are common causes. Wrap the lookup cell in TRIM or clean the source list, then run the lookup again.

### Where did Money in Excel go?

Microsoft ended Money in Excel on June 30, 2023. New accounts cannot connect, and new transactions are no longer received. Microsoft points to budget templates in Microsoft 365 as the alternative.

### How many rows can one Excel worksheet hold?

Microsoft's specifications page lists 1,048,576 rows and 16,384 columns per worksheet. For Microsoft 365 and recent versions, split large exports by client or month before you import them.

### Does Lazur work on Windows?

Not yet. Lazur runs on the Mac, on both Apple silicon and Intel. Windows is planned, not available.

### What does Lazur do with my client data?

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 check your firm's policy on client data.

### How does Lazur work alongside Excel?

Lazur runs as a voice assistant on the Mac, not inside Excel. It is not a plugin or add-in for any app, and it has no partnership with any app maker. You hold ⌥ ⌘, ask your question, and Lazur answers out loud and points at what it sees.

## Sources

1. [What's New in Excel (October 2026)](https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-october-2026/4549758), Microsoft Tech Community, checked 2026-11-06
2. [Keyboard shortcuts in Excel](https://support.microsoft.com/en-us/accessibility/excel/keyboard-shortcuts-in-excel), Microsoft Support, checked 2026-11-06
3. [Common Office for Mac keyboard shortcuts](https://support.microsoft.com/en-us/office/common-office-for-mac-keyboard-shortcuts-307f469a-1a05-4263-9b55-49df19a8b8ff), Microsoft Support, checked 2026-11-06
4. [Excel specifications and limits](https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3), Microsoft Support, checked 2026-11-06
5. [Free Excel for the web templates](https://support.microsoft.com/en-us/office/free-excel-for-the-web-templates-a9d5d175-a7c8-4f86-9211-b5311ee36a60), Microsoft Support, checked 2026-11-06
6. [What is Money in Excel?](https://support.microsoft.com/en-gb/office/what-is-money-in-excel-0fb4710d-169e-45a7-ad60-ca98103d4e6a), Microsoft Support, checked 2026-11-06
7. [Excel shortcuts on the Mac](https://exceljet.net/articles/excel-shortcuts-on-the-mac), Exceljet, checked 2026-11-06
8. [Audits of Operational Spreadsheets](https://panko.com/ssr/Audits.html), Raymond Panko, checked 2026-11-06
9. [An Empirical Study of Human Error Detection vs Audit Software (arXiv 1009.2785)](https://arxiv.org/abs/1009.2785), arXiv, checked 2026-11-06
10. [54% of Gen Z finance employees say they love Excel](https://www.cfo.com/news/54-of-gen-z-finance-employees-are-loving-microsoft-excel-cfo-/807516/), CFO.com, checked 2026-11-06