Once installed a "PyCharm Debug" button will be added to the PyXLL ribbon tab in Excel, so long as you have PyXLL 5 or above already installed. To debug your Python code running in Excel with PyXLL ...
See http://www.pyxll.com for information about how PyXLL can be used to embed Python code in Excel.