How to change case in microsoft excel
- George Apostolov
How to change case in microsoft excel: step-by-step guide
Open the file you wish to edit on MS Excel.
Select a cell and type in "=UPPER"
Add an open parenthesis, click on the desired cell, and then close the parenthesis.
Press Enter, then drag the fill handle (the small square at the bottom-right corner of the cell) to the cells where you want the same function applied.
You can follow the same steps to convert to lowercase or proper case if needed.
Quick answer: To change case in Microsoft Excel, open your file, select a cell, type "=UPPER", add an open parenthesis, click your target cell, and close the parenthesis. Press Enter, drag the fill handle to apply the formula, and repeat these steps for lowercase or proper case conversions.
About this Microsoft tutorial
Convert text to uppercase, lowercase, or proper case in Microsoft Excel by using formula functions and dragging the fill handle across cells. This guide shows how to change case in microsoft excel in 5 steps, starting with "Open the file you wish to edit on MS Excel" and finishing with "You can follow the same steps to convert to lowercase or proper case if needed". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to change case in microsoft excel?
5 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to Change Cell Color Based on Value Microsoft Excel, How to Change Currency in Microsoft Excel and How to Change Data Type in Microsoft Access. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
