If you want to change the text case from lowercase to uppercase in Microsoft Excel, then this guide shows you five ways to do it.

To lock these numeric values, you need to delete the formula without deleting the calculated results. This is accomplished using Excel's copy and paste feature.

Click on the "Paste" option in your Excel menu. Select the "Paste Values" option in the "Special Paste" section. Press the "Ctrl" and "X" keys on your keyboard to cut out the text in all caps.

Paste Special is an underrated tool in Microsoft Excel, with many people only using it to paste values. But it can do much more than that! Whether this is the first time you've heard of Paste ...

Use Excel's Paste Special feature to calculate multiple values against a data range, at the same time. You can make the process even more efficient with keyboard shortcut combinations.