--- title: "How to capitalize all letters in Word, Excel, and other apps" description: "Here's how to automatically capitalize all letters in Word, Google Docs, and other text editors—and in thousands of apps using Zapier's Formatter tool." image: "https://images.ctfassets.net/lzny33ho1g45/capitalize-text-titlecase-p-img/81007c87e2f74c1291ff3734ea370f88/Group_12401.jpg" --- # How to capitalize all letters in Word, Excel, and other apps Here's how to automatically capitalize all letters in Word, Google Docs, and other text editors—and in thousands of apps using Zapier's Formatter tool. Capitalization isn't something you have to think much about. The first letter of a sentence gets capitalized, along with any proper nouns—and you write in all caps when you're angry (or excited, depending on who you ask). But when you go to write a long title and have to hold `Shift` for every first letter or when you write a few sentences without realizing caps lock was on, capitalization can suddenly get more frustrating and time-consuming. Here's how to automatically capitalize all letters in Word, Google Docs, and other text editors—and in thousands of other apps using Zapier's Formatter tool. **Table of contents**:  - [How to capitalize all letters in Word](#word) - [How to capitalize all letters in Google Docs](#google-docs) - [How to capitalize all letters in Excel](#excel) - [How to capitalize all letters on macOS](#mac) - [How to capitalize all letters in Sublime Text](#sublime-text) - [How to capitalize all letters using a web app](#web) - [How to capitalize all letters with Zapier](#zapier) ## How to capitalize all letters in Word Here's the easiest way to capitalize all letters or change the case of text in your Word document.  1. Highlight the text you want to change. 2. In the _Home _tab of your ribbon, click the **Change Case**_ _icon, which looks like a capital and lowercase `Aa` next to your font options. 3. Select the case you want: _Sentence case._, _lowercase_, _UPPERCASE_, _Capitalize Each Word_, or _tOGGLE cASE_. Alternatively, you can highlight the text and use Word's [keyboard shortcut](https://zapier.com/blog/learn-keyboard-shortcuts/): press `shift + fn + F3` on Mac or `Shift + F3` on Windows, and keep pressing `F3` until your text changes into the desired case. ## How to capitalize all letters in Google Docs It's just as easy to capitalize all letters in [Google Docs](https://zapier.com/blog/how-to-use-google-docs/)—you just have to know where to find its version of the _Change Case_ tool.   1. Highlight the text you want to change. 2. Click **Format** > **Tex**t > **Capitalization**. 3. Select the case you want: _lowercase_, _UPPERCASE_, or _Title Case_. ## How to capitalize all letters in Excel It's a little more complicated in [Excel](https://zapier.com/blog/excel-online-guide/)—you'll need to use functions to get the job done. - **=UPPER** will capitalize all letters. - **=LOWER** will make the text lowercase. - **=PROPER** will turn your text into Title Case (where the first letter of every word is capitalized). In every case, you'll need to enter the formula in another cell, and the reformatted text will appear in that cell or column. In the example below, `=UPPER(A1:A3)` in column F tells Excel to capitalize all the text in cells A1 to A3. To make the same text from column A all lowercase, you'd enter `=LOWER(A1:A3)`.  ## How to capitalize all text on macOS Using a Mac? Lots of apps on your Mac already include macOS's built-in spelling and grammar checks along with text transformations. Here's how to access it in most Mac apps.  1. Highlight the text you want to change. 2. Right-click your selection. 3. Click **Transformations**, if available, and select the case you want: - **Make Upper Case**: This capitalizes all letters - **Make Lower Case**: This makes all your text lowercase - **Capitalize**: This turns your text into Title Case. If your right-click menu doesn't include a _Transformations_ option, there's another workaround. Click the **More Text Options** icon, which looks like a gear, in the app's font settings—that's where Pages and other Apple apps put those same transformations. The only catch is that there's no option to make your text all lowercase.  ## How to capitalize all letters in Sublime Text One of the most popular code and text editors [Sublime Text](https://www.sublimetext.com/) (available on Mac, Windows, and Linux) also includes a capitalization tool. 1. Highlight the text you want to change. 2. Click **Edit **> **Convert Case**. 3. Select the case you want. In addition to the standard options, Sublime Text also includes `snake_case` (lowercase, with an underscore between each word) and `kebab-case` (lowercase, with a hyphen between each word). ## How to capitalize all letters using a web app Another option is to use a web app to format your text. There are a number of simple web apps that can swap your case for you. - In [TitleCase](http://titlecase.com/), type or paste in your text, and then choose the case you want to automatically convert your text to. - In [Convert Case](https://convertcase.net/) (pictured below), type or paste in your text, then choose each of the case options you want. It'll give you your text in _all_ of those cases for a quick way to pick what looks best. ## Automatically capitalize all letters with Zapier These tips work great for changing your capitalization within an app, like if you want to convert caps to lowercase in an article you're writing. But if you want to change capitalization as you send information from one app to the other, here's [how to automatically convert text case with Zapier](https://zapier.com/blog/convert-text-case-in-zaps/). **Related reading:** - [How to find and replace any text in your documents](https://zapier.com/blog/find-replace-guide/) - [How to separate first and last names from a single form field](https://zapier.com/blog/how-to-separate-names-into-first-and-last/) - [How to change date and time formats in your text automatically](https://zapier.com/blog/format-datetimes/) - [Automatically find and match related data across apps](https://zapier.com/blog/find-match-data-across-apps/) - [The Zapier guide to line items](https://zapier.com/blog/formatter-line-item-automation/) _This article was originally published in September 2017 by Matthew Guay. The most recent update was in May 2024._