If you are a Mac user, you may have encountered the following problem: suddenly, your Num pad of your extended keyboard stops working in Excel. If this is your case and your Num pad works fine the rest of the time, then keep reading - this article discusses one simple solution to your problem.
You may have tried pressing all the F keys without success. The solution is elsewhere and is very simple: just press the Shift key and the Clear key at the same time. If you are struggling to find the Clear key on your keyboard, it is the key just above the 7.
And that’s all - your Num pad is supposed to work perfectly fine in Excel.