What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
To hide every zero on one worksheet in Excel for Mac, open Excel > Preferences > View and clear Zero values under Show in workbook. To hide zeros in selected cells only, apply the custom number format 0;-0;;@. Both methods change what Excel displays; the numbers themselves stay in the cells. Which one you need depends on whether the zeros are typed values or results returned by formulas.
Choose the right method first
Excel for Mac offers three practical approaches and one setting that looks relevant but does less than you might expect. The table below compares them by scope and by what happens to the value.
As an Amazon Associate I earn from qualifying purchases.
| Goal | Method | Scope and limits |
|---|---|---|
| Hide every zero on a worksheet | Excel > Preferences > View, then clear Zero values under Show in workbook | Applies to the worksheet as a whole. Simplest option when every zero on that sheet should disappear. |
| Hide zeros in chosen cells only | Custom number format 0;-0;;@ |
Applies only to the cells you select. Hidden zeros remain visible in the formula bar and are not printed. Decimal values display rounded to whole numbers unless you change the format (see below). |
| Hide a zero returned by a formula, keeping the numeric result | Conditional formatting: cell value equal to 0 with a white font | Display only. The value is still there, and white text can be visible if the cell is filled with color or if someone selects it. |
| Show a blank or dash instead of a zero result | An IF formula that returns "" or "-" for the zero case |
Changes the result to text. SUM and similar functions ignore text, but arithmetic that refers to the cell directly returns #VALUE!. |
| Control zeros in a PivotTable | PivotTable Options > Display | Microsoft’s Mac article documents empty-cell and error display options in this section. It does not document a dedicated numeric-zero hiding setting here. |
Hide all zeros on a worksheet
Use this method when the whole sheet should show no zeros. It is a view setting, so it does not change any formula or value.
Free tools Windows power users keep installed
One-click scans. No signup required.
- In the Excel menu, choose Preferences.
- Under Authoring, choose View.
- Under Show in workbook, clear Zero values.
Zeros on that worksheet disappear from view. Turn the checkbox back on to restore them.
#1 Best Overall
- Magic Keyboard delivers a remarkably comfortable and precise typing experience.
- It’s also wireless and rechargeable, with an incredibly long-lasting internal battery that’ll power your keyboard for about a month or more between charges.
- It pairs automatically with your Mac, so you can get to work straightaway.
- It features a USB-C port and includes a woven USB-C Charge Cable that lets you pair and charge by connecting to a USB-C port on your Mac.
Hide zeros in selected cells with a custom format
If only part of a sheet should hide zeros, a custom number format is the better tool, because it applies only to the cells you format.
- Select the cells you want to format.
- On the Home tab, in the Number group, open the Number Format menu and choose Custom. You can also press Command+1 and select Custom on the Number tab of Format Cells.
- In the Type box, enter
0;-0;;@. - Click OK.
A custom format has up to four sections separated by semicolons. They apply, in order, to positive numbers, negative numbers, zero, and text. In 0;-0;;@, the third section is empty, so zeros display as nothing. The fourth section, @, keeps text entries visible. If a formatted cell later holds a nonzero number, it displays normally.
Rank #2
- 𝗧𝗵𝗲 𝗞𝗲𝘆𝗯𝗼𝗮𝗿𝗱 𝗧𝗵𝗮𝘁 𝗖𝗮𝗻 𝗗𝗼 𝗜𝘁 𝗔𝗹𝗹: With a rechargeable battery, sophisticated design, and multi-synch tech, our bluetooth mac keyboard offers everything you need conquer your workload. Works with Mac|PC|iOS|Android.
- 𝗦𝗶𝗺𝘂𝗹𝘁𝗮𝗻𝗲𝗼𝘂𝘀𝗹𝘆 𝗣𝗮𝗶𝗿 𝗨𝗽 𝘁𝗼 𝟯 𝗗𝗲𝘃𝗶𝗰𝗲𝘀: Easily switch between your smart tv, laptop, and tablet on the fly with our wireless mac keyboards. Multisync can pair up to 3 bluetooth devices such as (Mac/PC/iOS/Android/TVs).
- 𝗦𝗼𝗽𝗵𝗶𝘀𝘁𝗶𝗰𝗮𝘁𝗲𝗱 𝗔𝗽𝗽𝗹𝗲 𝗔𝗲𝘀𝘁𝗵𝗲𝘁𝗶𝗰𝘀: Finding a mac keyboard wireless that matches can be difficult, so we designed ours to fit the look. An aluminum body with thin black keys makes it the perfect wireless keyboard for macbook pro.
- 𝗤𝘂𝗶𝗲𝘁, 𝗥𝗲𝗳𝗶𝗻𝗲𝗱, 𝗮𝗻𝗱 𝗦𝗮𝘁𝗶𝘀𝗳𝘆𝗶𝗻𝗴: The mac wireless keyboard is equipped with 110 scissor flex keys that include 20 MacOSX shortcuts and a numeric keypad. Each keystroke will be quiet and smooth.
- 𝗘𝗻𝗷𝗼𝘆 𝟯 𝗠𝗼𝗻𝘁𝗵𝘀 𝗕𝗲𝘁𝘄𝗲𝗲𝗻 𝗖𝗵𝗮𝗿𝗴𝗲𝘀: Our rechargeable bluetooth keyboard is capable of 3 months between charge time with an average use of 3 hours per day and only requires 1 hour of charge time.
Watch for rounding in decimal values
The positive section 0 shows whole numbers only, so a value of 2.4 displays as 2. For two decimal places, use 0.00;-0.00;;@ instead. The format changes only the display, so calculations still use the full value.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minutePC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Hide zeros returned by formulas
Formula results need a different approach, because a number format on a formula cell still works, but you may want the formula itself to return something other than zero.
Rank #3
- WIRELESS, RECHARGEABLE CONVENIENCE — Magic Keyboard with Numeric Keypad connects wirelessly to your Mac, iPad, or iPhone via Bluetooth. And the rechargeable internal battery means no loose batteries to replace.
- WORKS WITH MAC, IPAD, OR IPHONE — It pairs quickly with your device so you can get to work right away.
- ENHANCED TYPING EXPERIENCE — Magic Keyboard delivers a remarkably comfortable and precise typing experience. Its extended layout features document navigation controls for quick scrolling and full-size arrow keys. The numeric keypad is ideal for spreadsheets and finance applications.
- GO WEEKS WITHOUT CHARGING — The incredibly long-lasting internal battery will power your keyboard for about a month or more between charges. (Battery life varies by use.) Comes with a Lightning to USB Cable that lets you pair and charge by connecting to a USB port on your Mac.
- SYSTEM REQUIREMENTS — Requires a Bluetooth-enabled Mac with macOS 10.12.4 or later, an iPad with iPadOS 13.4 or later, or an iPhone or iPod touch with iOS 10.3 or later.
Option 1: Keep the number and hide it with conditional formatting
- Select the formula cells.
- On the Home tab, choose Conditional Formatting > Highlight Cells Rules > Equal To.
- Enter
0in the value box. - Open the format list, choose Custom Format, and set the font color to white.
The cell still holds a zero, so totals and other formulas work unchanged. The trade-off is that the text is hidden only by color. If the worksheet has a colored fill, or the cell is selected, the figure can still be read, and a printed copy may show a faint or blank area depending on the printer.
Option 2: Return a dash or blank from the formula
Wrap the calculation in an IF test. For example, if column D multiplies B and C, the formula in D2 could be:
Rank #4
- Magic Keyboard is available with Touch ID, providing fast, easy and secure authentication for logins and to unlock your Mac.
- Magic Keyboard with Touch ID and Numeric Keypad delivers a remarkably comfortable and precise typing experience.
- It features an extended layout, with document navigation controls for quick scrolling and full-size arrow keys, which are great for gaming.
- The numeric keypad is also ideal for spreadsheets and finance applications.
- It’s wireless and features a rechargeable battery that will power your keyboard for about a month or more between charges.
=IF(B2*C2=0,"-",B2*C2)
To show a blank instead, use "" in place of "-". Use this approach when the displayed text matters more than keeping a numeric zero. Be aware that a later formula such as =D2*2 returns #VALUE! when D2 holds a dash, while SUM(D2:D20) simply skips it. Check downstream formulas before you switch a column to text.
What hiding does not change
Microsoft’s support page on custom number formats states: “Custom number formats affect only the way a number is displayed and do not affect the underlying value of the number.” In practice, a zero hidden by the worksheet setting or by the 0;-0;;@ format still counts in totals, averages, and references, and it is still visible when you click the cell and read the formula bar. Only the IF method changes the value itself.
Best Value
- Wide Compatibility Tips: This Apple-focused combo supports macOS 10.12+, iPadOS 13.0+, and iOS 13.0+. It connects through 3 Bluetooth channels only, with no USB connection or USB receiver included. Note: Bluetooth 4.0 or above is required; Not fully compatible with Windows systems
- Perfect for Apple Ecosystem Users: Designed specifically for Mac users with a standard Apple layout, this Bluetooth keyboard and mouse supports BT1/BT2/BT3 channels to seamlessly switch between three devices like Mac, MacBook Pro/Air, and iPad. Ideal for multi-device professionals, students, and creatives working across Apple products
- Type-C Rechargeable for Eco-Friendly Convenience: No more battery waste! This combo features Type-C rechargeability with up to 200 hours standby. Auto-sleep and on/off switch minimize power consumption - perfect for travelers, eco-conscious users, and anyone tired of frequent battery changes
- Whisper-Quiet for Focused Environments: Enjoy a satisfying tactile click without the noise. Enhanced key stability reduces sound while keeping responsiveness high. Ideal for shared offices, libraries, study sessions, or late-night work where quiet is essential
- Slim & Stylish Metal Design for Portability: At just 0.12” (keyboard) and 0.9” (mouse), this ultra-thin combo slips easily into any bag. Made from stainless steel and premium ABS, it’s both durable and elegant—a sleek addition to any modern desk, coffee shop, or coworking space
Versions and availability
The Microsoft support article for Excel for Mac that covers these steps lists Excel for Microsoft 365 for Mac, Excel 2024 for Mac, and Excel 2021 for Mac. The page does not show a publication date, so menu names may change in later builds. Earlier versions are not covered by that list, and their menus may differ. The instructions are from Microsoft’s US English support pages, and no region-specific limits are stated there.
If the menu path does not match your screen, search Excel’s Help for “zero values” or “custom number format”, which will lead you to the same settings in your build.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →
