If you Can't type numbers or formulas or enter data into Excel cells then it might be a problematic Add-in causing the problem. Here are some working fixes that may help.

By default, Microsoft Excel's cells are named by their column-row references, like A1 or B2. ... The quickest way to do this is to type a cell reference in the name box and press Enter.

Microsoft Excel has hundreds of tools that you can use to make your spreadsheets tick. However, if you're looking to level up ...

Excel’s Name box is a powerful tool for an ordinary dropdown. To find it, look to the left of the Formula bar. Usually, it displays the reference for the current cell as shown in Figure A .

Yes, you can link the contents of an Excel text box to data in a cell as follows: 1. Insert a text box. Insert a text box in Excel from the Insert tab by selecting Text, Text Box, and then use your ...

In the Value section, input into the entry box the cell A2. Then click OK to see the result. Method two is to click the Formulas tab and click the More Functions button in the Function Library group.

On the Mac, the equivalent keyboard shortcut is Control-U, as F2 is assigned to cut the contents of the current cell. (If you’d like to see all of Excel’s keyboard shortcuts, open Help ...

After you turn on worksheet protection, Excel will allow changes only in the cells you previously formatted as unprotected. Make the sheet read-only . Users are good at overwriting electronic forms.

Microsoft Excel’s mobile app lets you to take a picture of a table and paste the data directly into your spreadsheet. Here's how to use it.

Excel displays a dialog box prompting for a cell reference such as B55 or G12. Word’s dialog box prompts for 13 different locations, including the page, section, line, table and graphic. 3.