Here is how you do it in Mac.
- You will need to edit the config file via Terminal. The file is under /Users/username/Library/Application Support/Civilization V Campaign Edition/config.ini
- Change "DebugPanel = 0" to "DebugPanel = 1"
- In game, all you need to do is press ~ key to open debug panel.
- As far as I know, the only useful cheat is Reveal All.