r/Excel4Mac • • Apr 09 '26

Finally the complete alt shortcut experience on MAC

12 Upvotes

So I began on this project last year because I was angry that the native KeyTips function on Mac lacked support for dropdown menus (like Borders, Formating, Freeze etc.). I was also quite frustrated at the paid alternative "Accelerator Keys" since it doesn't feel as fluid as the native function, nor does it allow for tiled excel windows (which the native KeyTips do support).

After numerous updates I finally created a version that works flawlessly. I realized today I actually forgot to make a reddit post about it, but it is now complete.

What this script does: It creates custom visual KeyTips shortcuts for like 20+ dropdown menus that the original Mac KeyTips doesn't yet support.

The code is very lightweight and safe to run in the background at all time. It is also completely free and open source for anyone to scrutinize or download and test.

Follow the download instructions on my Github, enjoy! 

https://github.com/jacber01/Excel-mac-keytips


r/Excel4Mac • • Jan 28 '23

Discussion Activating the developer tab on Excel for Mac 2021 (Not the 365 version)

10 Upvotes

Before you get started, make sure the Developer tab is shown on the ribbon. To do that:

  1. On the menu, click Excel > Preferences... > Ribbon & Toolbar.

  2. In the Customize the Ribbon category, in the Main Tabs list, select the Developer check box.

  3. Click Save.


r/Excel4Mac • • May 16 '23

Change default view on MacBook? Need larger than 100%

8 Upvotes

I’m using excel on my MacBook and access it from either excel or google drive for desktop. When I open excel it defaults to 100% but I much prefer 125%. Rather than individually doing this each time excel is opened and/or a new tab is opened, isn’t there a way to set it default? Advice appreciated!


r/Excel4Mac • • Apr 27 '25

Paying for Microsoft 365 Copilot for Mac

7 Upvotes

Your opinions are highly appreciated —

I’m using a MacBook Air M3, iPhone 16, and iPad 10th Generation.

How’s your experience using Microsoft 365 Copilot for Mac please? Such as how Copilot has made your work more productive and organized?

Thank you.


r/Excel4Mac • • Apr 21 '23

Discussion Mac Excel file randomly sets itself to "Read Only"

7 Upvotes

Cross-posting from r/VBA. My personal.xlsb file randomly sets itself to read-only. It won't save changes and gives a read-only alert when it tries. The fix is simple: save off as a copy and do some cleanup. Not knowing why it does this or what to fix, I set out to change the read-only attribute back to normal to simplify things. It's my understanding that you must to be in a second spreadsheet, and personal.xlsb must be closed to do this. That's how I set myself up.

New to me, I used the VBA's SetAttr and GetAttr for the first time. This is my code:

Sub SetNormal()
    Dim FilePath As String, FileName As String
    Dim FullName As String, Result As Long
    FilePath = ThisWorkbook.Path & Application.PathSeparator
    FileName = "2023Personal_r00.xlsb" 'A closed file to set to normal, 
    'which is not activeworkbook but in same folder.
    FullName = FilePath & FileName
    Debug.Print FullName
    SetAttr FullName, vbNormal
    Result = GetAttr(FullName)
    Debug.Print Result 'Should return 0 for normal, 1 for read only.
End Sub

This always returns zero (even when setting to 'read only' as an experiment) and the file is unchanged with respect to saving. I'm at my wit's end. Does anybody see the error of my ways? I have system permissions to read and write to this file. (This is on a Mac running current Office 365.)


r/Excel4Mac • • Sep 08 '26

Microsoft's entire Excel for Macs development team.

Post image
6 Upvotes

r/Excel4Mac • • Sep 12 '23

Unsolved Stop excel from changing chart colors

6 Upvotes

I have a bar chart built, it looks great. I change the data range and Excel changing the chart bar colors. In Excel for Windows, you can stop this by File > Options > Advanced > Chart > -- deselect 'Properties follow chart data point for current workbook' -- deselect 'Properties follow chart data point for all new workbooks'

These options do not appear to exist in Excel 4 Mac.

Someone suggested this VBA code on another site, but I can't make it work:

Application.ChartDataPointTrack = False ActiveWorkbook.ChartDataPointTrack = False

Can anyone PLEASE suggest a way to accomplish this?

Thank you!!


r/Excel4Mac • • Jun 14 '23

Help converting pdf to excel on mac

6 Upvotes

I'm doing my taxes and cannot convert my pdf bank statements into an excel spreadsheet where each column of the statement is a column of cells. Can anyone help?


r/Excel4Mac • • 26d ago

I made Alt shortcuts work in Mac Excel, plus a few more features

5 Upvotes

Hello! I built a tool that brings Windows shortcuts to Mac, allowing all your Alt key ribbon shortcuts to work. Press Option instead, and labels show up on the menus.

I also added some features to make it feel more like Windows:

  • You can do all the Ctrl shortcuts with the Mac Ctrl key, rather than the Command key

  • In Excel, function keys like F2 and F4 work as expected, while in other apps, they retain their normal Mac functions, like brightness and volume

  • Old Excel 2003 shortcuts work too, like Alt E S V to paste values, Alt O C A to autofit a column, and Alt E I S to fill a series

  • For Excel menus without labels, like the color grid, Option assigns short codes like A1 to B8, so you can choose a fill color without using the mouse

Download at altkeys.app

Let me know if you have any feedback!


r/Excel4Mac • • Jun 18 '26

relative (not absolute) references to other files

5 Upvotes

This seems like it should be possible, but I can't find out how to do it.

Mac OS 15, current version of Excel (16.110? it updates regularly)

Let's say I have three directories: project_1, project_2, and project_3.

Each of those directories has a bunch of files that need to stay together - CAD drawings, marketing PDFs, tech references, and (most important) a financial/part spreadsheet.

I have a fourth directory with an excel file that refers to particular cells in project_1/parts.xlsx, project_2/parts.xlsx, etc.

From the Mac where the files are stored those links work fine.

The reference looks something like this:

='/Users/never_peppers/products/project_1/[parts.xlsx]costs'!$A$1

But when I mount the filesystem from another computer, the links stop working, because the target file isn't in /Users, it's in /Volumes/servermac/

I want something like this:

='../../project_1/[parts.xlsx]costs'!$A$1

But that doesn't work. Do I have the syntax wrong? Is this impossible?


r/Excel4Mac • • Apr 10 '24

Excel is not stable!!!

5 Upvotes

Hi, I am running the latest version on Mac Air M3 16.83 and never in my past >3yrs on Mac found the excel is so cripple this round. I don't think is related to Mac Air vs Pro hw. The issues I encountered frequently:

  1. On multiple monitors, even one extended, the excel windows open and on separate screen, when right click to select things like hide/unhide worksheet, turn on pivot list view etc, the active pop up will go to another excel window on another monitor. I need to bring them together on the same screen for the function to work...damn frustrating and most annoying on this stupid bug!

  2. Crashes more often than my past experience on Mac.

  3. Find and replace: it won't work properly on the selected cells but either goes to other workbook opened or prompted a finder window. it is crazy behavior.

In short, not stable and reliable. I am not sure is my Mac PC issues or someone else has the same experience. Thanks for sharing.


r/Excel4Mac • • Dec 07 '23

Help needed Creating and saving custom color palettes for graphs etc

5 Upvotes

Hi everyone.

Excel v16.4

Mac OS 10.13.6

I've been searching for a way to add my own custom colors/palettes to excel so I can use them for graphs etc. Everything I have come across tells me to go to Page Layout > Colors > Customize. I don't have a customize option at all. I've also tried Pivot Chart > Design > Change Colors and again no "Customize" option.

Am I missing something here?

Many thanks for any advice/suggestions and thank you for reading.


r/Excel4Mac • • Oct 15 '23

Add-in to generate User forms - Excel desktop (Win or Mac OS)

5 Upvotes

r/Excel4Mac • • Jul 15 '23

How to save a file as CSV, but separated with semicolon instead of comma. version 16.74. MacOs Ventura

Post image
5 Upvotes

r/Excel4Mac • • Jun 26 '23

Pro-Tip Tips on getting your questions solved as fast as possible… We are not r/Excel and we are not trying to be… these posting guidelines are well written and apply to both communities.

Thumbnail
self.excel
5 Upvotes

r/Excel4Mac • • Jun 26 '23

Discussion Posting in r/Excel4Mac

5 Upvotes

Hello and welcome to r/Excel4Mac!

Please help us decide if the posts you see here are good fit for the subreddit by up or downvoting them.

If you think that a post is great advice to improve your life, or genuinely improves the lives of others, please upvote it.

If you think that a post doesn't help anyone in any way, please downvote.

If you don't care, leave it for the others to decide.

Happy posting & commenting!

Oh, and please refer our little sub to others so we can make this a great sub together.


r/Excel4Mac • • Jun 21 '23

Conditional formatting for large numbers (millions, billions)

5 Upvotes

Hey all,

I am trying to find a way to automatically format large numbers in columns on Excel. I've seen a zillion posts discussing about that, but none of them seem to work on Excel for Mac.

Things I've tried so far :

  • putting commas at the end of the number format : #,, "M"

  • same with spaces : # "M"

  • commas and spaces : # ##0 ,, " M€"

  • conditional formatting : [<1000000]General;0,, "M"

None of it works ; I only get the original number followed by two commas and/or two spaces and an "M" to display.

Is this feature not available on Excel4Mac ? Is it a a language parameter thing ? (I am using French locale, so maybe I should use something else than commas)

Thanks for your help


r/Excel4Mac • • Jun 08 '23

Can't seem to find missing brackets

5 Upvotes

I 'm want to use a pretty (big) formula in the conditional formatting so certain cells will be highlighted green. Im using the following formula: (it's in Dutch so be aware)

=ALS.VOORWAARDEN(VERT.ZOEKEN(WAARDE(RECHTS(RECHTS(D5; LENGTE(D5)-VIND.ALLES("-CREAM";D5)); LENGTE(RECHTS(D5; LENGTE(D5)-VIND.ALLES("-CREAM";D5)))-VIND.ALLES("M"; RECHTS(D5; LENGTE(D5)-VIND.ALLES("-CREAM";D5)))));Factuurgeschiedenis!$A$2:$F$10000;6;ONWAAR)="Ja"; "WAAR")

Whenever I use this formula in a cell, it works. But when I want to use it as a formula in conditional formatting, it gives me an error and tells me that its missing an open-or close bracket in the formula.

I really dont understand why. Can anyone help me?

Thank you a lot!


r/Excel4Mac • • Jun 06 '23

Excel automatically adds quotes when using textjoin

5 Upvotes

=IF(VLOOKUP(TEXT.JOIN("";TRUE;IF.ERROR((MID(RIGHT(D5;6);ROW(INDIRECT("1"&LEN(D5)));1)*1);""));Factuurgeschiedenis!$A$2:$F$1000;6;FALSE)="Yes";"TRUE";"")

Whenever I use this (Im using it for invoices) im getting "1" as result, but I want 1 as result, without the quotes. Any idea how to fix this?

Thank you


r/Excel4Mac • • May 09 '23

[Excel for Mac] Enable users to dbl-click a cell in a ListObject or regular range, and replace or clear all matching values in column, or fill blanks

Thumbnail
self.vba
5 Upvotes

r/Excel4Mac • • May 02 '23

Help needed Using Excel to open a Word application

5 Upvotes

With us lacking ActiveX, how do I open an instance of Word to run what is necessarily a Word-specific macro function? All the code I Google looks like this:

Sub TestHola()
    ' Charles Kenyon
    Dim wd As Object, strFile As String
    Set wd = GetObject(, "Word.Application")
    If wd Is Nothing Then
        Set wd = CreateObject("Word.Application")
    End If
    Let strFile = "Test.docm"
    wd.documents.Open (strFile)
    wd.Run "Hola"
    Set wd = Nothing
End Sub

Source: How to run word macro from excel VBA

This only works on a Mac if the Word document is already open. There’s a Stack Overflow hint that it’s the first Google search result (very helpful /s) but either that’s changed or I don’t know the right search terms. Probably both.

How’s it done?


r/Excel4Mac • • Apr 28 '23

[365] Excel broke

5 Upvotes

So formulas work fine, but none of the more efficient ways of interacting with the sheet are working: I can't move around cells, I can't copy down formulas, all I can do is change my selection window.

I've already tried uninstalling and reinstalling the software. Any suggestions?


r/Excel4Mac • • Apr 27 '23

Help needed What is the proper way to use =hyperlink() ?

5 Upvotes

I'm working on a sheet of about 1500-1800 rows that serves as a document locator. Columns are lined up with pathnames, lower-level pathnames, and filenames. The names are all verified.

=HYPERLINK(CONCAT(A268,"/",B268,"/",C268),"Link")

doesn't always work. It definitely opens Office files (.xlsx and .docx) but it won't open .pdf's or .jpg's. It says "Cannot open the specified file." ugh... Everything is under ~/Documents.

I can right-click and add a hyperlink that way, and it does work, but with over 1500 file links to code, it's a non-starter to go that way. Plus, I don't see a way to pass a cell reference to a hyperlink built this way.

Is there a fundamental difference between the =hyperlink() formula and creating a hyperlink in a cell?

Thanks team!

ETA - The default file handler for PDF's is Preview.


r/Excel4Mac • • Apr 25 '23

Excel Import/Export Worksheet/Range to CSV File using PC/MAC?

5 Upvotes

Hey all, I am trying to find some sample VBA code that will take a range or worksheet and export the contents to a CSV file; the big thing I am trying to find is that it needs to work on a MAC! Every search I have done on Google has a working code from people, but its only works on a PC platform. I need something that works on Mac AND PC.