Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, ...

If keyboard shortcuts are not working in Excel first check Macro settings or disable Transition navigation keys and see. More suggestions here.