FIX: Arrow Keys Navigation does NOT work in Excel

Issue: The arrow keys navigation does not work in Excel application on your system. The same arrow keys navigation just works fine in other applications. Solution: You probably have the Scroll Lock special key pressed/enabled on your keyboard which causes this behaviour.  To fix click on Scroll Lock special key to release/unlock/disable it. The Scroll Lock special key varies from keyboard to keyboard. On my system keyboard, the Scroll Lock function is associate with Home button.  To control it, I need to press Function key (Fn) + Home button.

Read more

Excel Formula to calculate Number Of Days in a Month

Requirements: You want to build a calculator sheet that requires you to input number of days in a given month. Solution: Excel doesn’t have any built-in function to return the number of days in a month.  I’ve learned below two formulas that does the job. Both of them requires a date input and will return the number of days in the month that date belongs to. Hopefully this may come handy for you. =DAY(EOMONTH(B5,0)) =DAY(DATE(YEAR(B5),MONTH(B5)+1,1)-1)   A Sample table to display number of days in all months of this year 2016.   References: Number-of-Days-Calculator: Days-Calculator.xlsx          

Read more