If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

Unfortunately, you won’t find the “edit this cell” command listed in Excel’s keyboard customization section, so there’s no apparent way to change the shortcut.

Through Microsoft Translate Services, Excel can translate from one language to another (the TRANSLATE function) and detect another language already in a workbook (the DETECTLANGUAGE function).

Perhaps Excel will create a built-in function to convert text to sentence case in the future, but until then, a formula will work. If you would like to follow along in building this formula, you can ...

Learn how to show formulas in cells instead of values or calculated results In Microsoft Excel. You can show or hide formulas in Excel cells.

Open your business spreadsheet in Excel 2007 and locate the cells you need to change. For example, you might have an inventory list in cells A1 through A100. Use the "Upper ()" function in a blank ...

A formula can also be applied to cells containing words to automatically change the words to all caps.

The new LAMBDA feature will allow you to create your own customized functions using Microsoft Excel 's formula language, removing the need to write them in a programming language like JavaScript.