excel

Hello, I have 2 questions about excel for mac. 1) I want to assign a keyboard shortcut for the litte downward triangle button next to the font color button (shown on the left side of the attached photo). I want to hit a certain keystroke and bring out the color palette as shown in the...

Is it possible to add a column to a pivot table that shows an average of the sums. I'm trying to calculate an average spend per category per month. I'd like "Grand Total" to instead display an average of each month's sum for each category. Picture attached for context. Thanks

When using Excel 365 on the iPad, how to toggle to view the classic menu across the top that includes data validation? Attached is what’s visible and it’s limited across that menu. TIA.

Hello, I have BIG problem after updating to macOS Ventura. When I try to save changes to an excel file located in a network location (SMB) I get the message - " The document was saved successfully, but Excel cannot re-open it because of a sharing violation. Please Close the document and try to...

Hi, It works with up and down arrows but not with mouse or trackpad. I've Ventura ß7 and tried MS Office ß but no change. Did a clean install of MS Office. No change. Did a safe mode reboot. No change. Any thoughts ? Thanks. Victor

I've got a 2016 13" MBP TB with 8g RAM and 2.9GHz dual-core intel 5. I just looked at the new 14" MBP, and with RAM and processor upgrades I'm looking at $4 grand. YIKES! I paid $1,600 for this one 6 years ago. For anyone in the same boat that has upgraded, was it that impressive? For...

This may not be possible, but I'm checking to see if anyone knows of a way to utilize the mac function keys as they are setup by default (so they would adjust brightness, volume, etc.) but to treat them as standard function keys for specified apps (primarily excel). I know I can override the...

I have an issue which has now gotten so bad as to make Excel very difficult to use at all. I had High Sierra and a much earlier version of Office running and every now and then I would get the spinning wheel. It was a bit annoying, so finally bit the bullet and upgraded to Catalina (iMac can't...

I just purchased an 11” 2021 iPad Pro. So far so great! I really like the small form factor. A couple of things I wished it did differently: 1. Give me full access to Excel. Let me have CSV files and the ability to unlock locked worksheets. 2. Salesforce sucks on iPad. The app is trash and...

I just switched jobs, and when I learned that my new company supports Macs, I was very tempted to switch. I've used Windows professionally for 10+ years as an accountant (controller), and am very fast with shortcuts in excel. I was so disappointed with my work PCs (last one was only 1 year old...

A macro made in Excel on a Windows machine isn't working on my mac. Below is the section it's getting hung up on and giving me a syntax error. Trying to figure out what I could do to make this work. I'm guessing it's the filename designation. Frankly, I don't care where it gets saved on my mac...

I'm wondering if anyone else has experienced this. I've only noticed it with Excel 365 for Mac; I've not encountered it with Excel 365 for Windows. I find Excel responds frustratingly slowly when I try switching to a new tab by clicking on it. I've timed it, and the delay is ~1.5 s. That...

Hello everyone, I have just bought my first MBP (i5 10th gen/16gb/512gb). Today I was working with a relatively large dataset. And I used an INDEX/MATCH array function to re-organize my dataset. When dragging down the formula with "cmd + D" the MBP takes AGES to load, it has been calculating...

I have to call a file in VBA and I'm struggling.

I'm thinking of getting a new iPad and the main programs that I want to run is MS Office - Word, PowerPoint, and Excel. Is the iPadOS version of Word, Excel, and PowerPoint any different from the desktop version (Windows) and what do you get with the Office 365 subscription? Thanks in advance...

My first post, please be gentle...sorry if this is in the wrong forum! Today a student presented me with an issue I haven't come across before - he was sent an Excel file which has password protection enabled on the worksheets (the file is not password protected, just the worksheets within the...

Google has been useless inturning up how to repair the MS Office for Mac 2019 (and 2016 before this) issues. Excel has been getting more and more buggy and crashing way more recently. I had significant problems with MS Office 2016 for Mac that I was unable to fix so I upraded to 2019 for Mac...

I have the new Air 2019 10.5. I expected to lose the ability to edit and create documents using word and excel for free. I won’t go Office 365 out of principle. However to my delight I have found that documents that already exist in the cloud (I use Dropbox) and opened in the Word and Excel...

I have recently got a MacBook Pro 2018 now running Mojave. I will need to develop VBA in Microsoft Excel for use by someone else on a Windows 10 machine. I am wondering would there be any issues if I write the codes in a Windows 10 instance installed on my Mac in a Bootcamp partition? Or, it...

Project planning has never been so easy! QuickPlan makes project scheduling super easier than ever. NATURAL GESTUREs and keyboard shortcuts use on a clean, and smooth user interface makes project maintenance easier, faster and more efficient than ever before. Visualize, maintain and simplify...