Blog Post

Excel Blog
1 MIN READ

Excel for good: Learning resources to help improve your Excel skills for the future

cuong's avatar
cuong
Icon for Microsoft rankMicrosoft
Apr 22, 2020
This week we share with you a set of learning resources from our Excel MVP Mynda Treacy from Australia.  Mynda offers, “We’ve pulled together some free content to help you come out the other side of ...
Updated Apr 11, 2023
Version 2.0
blog
excel
Excel for good
cuong's avatar
Icon for Microsoft rankMicrosoft
Joined April 14, 2019
View Profile
Excel Blog
Subscribe to the Excel Blog to get the latest product announcements and updates
MobileCowcamp's avatar
MobileCowcamp
Copper Contributor
Jul 27, 2020

I'm confused!! If I'm not in the right place for this question, please let me know!

In Excel: How do I set a column of cells to be all capitals?

I tried to use the Upper() function but I could not make it work. It works if you put it in a unused cell and reference the cell you are using. But that put the caps letter answer in a separate cell (where I don't want it) meaning I have to use two (2) cells!? Seems rather stupid and clumsy to me.

I am putting only 1 character in the cell. Is there a way to make a column all capitals?