Right click in Excel 2016 not working on Mac - Microsoft Community

i installed microsoft office 365 home. right click option is, apparently, no longer available?  

i found following solution, appears pc.... need mac solution! 

from worksheet, press alt + f11   ( careful, that's alt + f11)

next press ctrl+g

type in (or copy here , paste): application.commandbars("cell").reset

then press enter key.

press alt+q return worksheet.

click right mouse button on worksheet cell. right click menu appear now?

any help greatly appreciated....

thanks

juliana,

i don't know why people don't know talking try answer questions beyond skill levels. none of people replied, far, have attempted follow steps.

let me preface answer explaining visual basic editor mac exists in office mac going replaced soon, answer based on exists in excel version 15.37, not apply when new editor released @ point yet determined in future.

i'll bold wrote, , comment it.

from worksheet, press alt + f11   ( careful, that's alt + f11)

yep, works! opens vb editor

next press ctrl+g

the existing editor doesn't know keyboard shortcuts. have right click on project , choose insert > module, navigate resulting folders open module 1.

type in (or copy here , paste): application.commandbars("cell").reset

the commandbars collection disaster in office 2016. reset command fail. kind of pop-up menu attempting achieve called context menu. excel mvp ron debruin explains how them work in every version of excel on page:

https://www.rondebruin.nl/win/s6/win001.htm

press alt+q return worksheet.

on mac, press command+q

if set context menus using ron's advice, should work fine.

Office / Excel / Mac / Office 365 Home