Notice that each number key in your num pad has two different functions.įor example, the number 7 doubles up as the Home key, while the number 8 doubles up as the Up arrow key. The num lock (or Number lock) is a toggle key on your keyboard that lets you control the use of the numeric keys in the num pad (the set of the numbers on the right side of your keyboard). If you’re trying to enter numbers from your num pad, and you find yourself unable to type into a cell, a possible cause might be that your num lock is turned off.
Your Num Lock may be Preventing You from Entering Numbers In such cases, you will also notice the text appearing in the formula bar, but not in the cells. If you type into a cell and see the cursor move but nothing appears in the cell, then it’s probably because your font color and cell background color are the same and so your text is basically camouflaged. Your cells may have Font Color set to White/Text may be Invisible Here are some possible reasons you can’t type in Excel, along with their respective solutions. Once you are able to trace the cause, it becomes easier to decide on the next steps to solve the problem.
Let us look at some common reasons for not being able to type in Excel. Possible Reasons You Can’t Type in Excel and their Solutions Certain Add-ins might be Preventing you from Typing.The Cell May have Validation Rules Applied to It.Your Num Lock may be Preventing You from Entering Numbers.Your cells may have Font Color set to White/Text may be Invisible.Possible Reasons You Can’t Type in Excel and their Solutions.
0 kommentar(er)
