Place your cursor in cell B2. Type the following formula in the Formula Bar on top: =UPPER(A2). Press the Enter key. This will convert the data in cell A2 in uppercase.

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.

Data types have a big impact on how Excel calculates and interprets your data. For example, you won't be able to efficiently sort, filter, or apply formulas based on dates if a column of dates is ...

A year ago support for nested data types in Excel was announced on the Excel blog, but the announcement didn’t have much detail about what nested data types are and the docs are quite vague too. I was ...

For some data types, such as a date or a percentage, Excel will change a cell's number format automatically as soon as you type it into a cell. Otherwise, there are various ways to change a number ...

Organize your Microsoft Excel spreadsheet to view your data efficiently. Whether you need to rearrange cells or filter your data to match criteria, Excel provides built-in tools to create the ...