Focus Cell feature in Excel

Excel has a rather new feature called "Focus Cell." It may be in beta, but somehow it mysteriously appeared on my Mac and now it's disappeared. It makes searching very much easier, visually and is a neat new feature.

Has anyone else experienced this feature? You can check it out on YT. On a Windows machine, there is a button to toggle - that space on Excel for Mac is just blank - yet somehow I activated it and then it unactivated.

As I said, if anyone has discovered this and has an idea how to activate it again, I'm all ears!


Regards!

iMac 27″ 5K, macOS 13.7

Posted on Jan 10, 2025 11:46 AM

Reply
Question marked as ⚠️ Top-ranking reply

Posted on Jan 10, 2025 6:35 PM

On Windows it's in the tab for [View] in the group for [Headings] and if you select a cell it highlights the column and row. Great for looking at large lists. I thought I had seen it on Mac version of Office 365, but can't find it today. The attached image shows the Windows version in Parallels.

17 replies
Sort By: 
Question marked as ⚠️ Top-ranking reply

Jan 10, 2025 6:35 PM in response to Rick Hess

On Windows it's in the tab for [View] in the group for [Headings] and if you select a cell it highlights the column and row. Great for looking at large lists. I thought I had seen it on Mac version of Office 365, but can't find it today. The attached image shows the Windows version in Parallels.

Reply

Jan 21, 2025 5:17 PM in response to Rick Hess

Same here. I was using it for about a month on my Macbook Air M2, and it just mysteriously disappeared (no updates or something similar). The feature is still on my Mac Mini M1 mysteriously. Also, the feature is not available on my Windows computer even though it is supposed to be. At this point, I choose to believe that Microsoft might have tossed a coin and decided which random computer gets this useful feature ~

Reply

Feb 6, 2025 7:35 AM in response to Rick Hess

Here's what worked for me after spending one hour a day for days on this...

  1. Reinstall (update) Excel : Download Excel Updater (16.93.25011917)
  2. Open /Library/Application Support/Microsoft/MAU2.0/Microsoft/AutoUpdate.app and in advanced, choose Beta Channel and tick Auto-update at startup
  3. Reboot
  4. Cross fingers and hope for the best (I read that updates may not be available to everyone - I have 365 Business Premium at work)


[This is a Direct Download Link]

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Focus Cell feature in Excel

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.