How to make capital letters. How to make small letters big in Word

Greetings, dear readers. Today I will share with you some very useful function in Excel, namely, I will tell you how to make all letters CAPITAL in Excel. When working with Word, this is quite easy if you know. How to do this in Excel? Let's figure it out together.

How is this done in Word? You need to highlight the word and press SHIFT + F3. After a few clicks we will get all words in UPPER CASE. What happens in Excel? He suggests entering a formula.

The fact is that in an Excel table you need to use special formulas that convert words to UPPER or lower case. Let's consider two cases - when everything is written in CAPITAL letters, and when in small letters.

I prepared a table for one of the lessons (), and I will use it. I will work in Excel 2013. But the method for turning capital letters into small letters and vice versa will work in Excel 2010, 2007.

How to make small letters BIG

In my table, the data is located in column A, so I will enter the formula in column B. In your table, you can do it in any free column, or add a new one.

So let's start with cell A1. Place the cursor on cell B1, open the “Formulas” tab and in the “Function Library” section select “Text”.

In the drop-down menu we find “UPPER CAPITAL”. The “Function Arguments” window will open, which requests the address of the cell from which the data will be taken. In my case, this is cell A1. I choose her.

After that, I click on “OK”, or faster, press ENTER on the keyboard.

Now in cell B1 it says “=UPPERCASE(A1)”, which means “make all letters in cell A1 CAPITAL”. Great, all that remains is to apply the same formula to the remaining cells in the column.

Move the cursor to the right edge of the cell and the cursor becomes a thick cross. Hold down the left mouse button and drag to the end of the data column. Let go and the formula is applied to all selected rows.

That's all. Look how it looks on me.

How to make BIG letters small

Once we've succeeded in forming capital letters, I'll show you how to return them to lowercase letters. I have Column B filled with big words, so I'll use Column C.

I'll start with cell B1, so I put the cursor in C1. Open the “Formulas” tab, then “Text” in the “Function Library”. In this list you need to find “LOWER” from the word “lowercase”.

A window pops up again asking you to specify a cell with data. I select B1 and press Enter (or the “OK” button).

Next, I apply the same formula to the entire column. I move the cursor to the lower right corner of the cell, the cursor turns into a thick cross, hold down the left mouse button and drag to the end of the data. I let go, and the job is done. All CAPITAL letters have become small.

How to save data after changes?

I think this is a good question, because if you delete the original values ​​​​from column A, then all the results of the formula will be lost.

See what you need to do for this.

We select all the received data in the result column. We copy them CTRL + V (Russian M), or right-click – “Copy”.

Select an empty column. Then right-click in it, find the special Insert options and select “Values”.

Here's the trick. Now you won't be confused by the need to convert all letters to UPPER or lower case.

The need to make large letters small in a Microsoft Word document most often arises in cases where the user forgot about the CapsLock function being turned on and wrote some part of the text that way. It is also quite possible that you just need to remove capital letters in Word so that all text is written only in lowercase. In both cases, capital letters are a problem (task) that needs to be solved.

Obviously, if you already have a large piece of text in capital letters or just a lot of capital letters that you don't need, you are unlikely to want to delete all the text and type it again or change capital letters to lowercase letters one by one. There are two methods for solving this simple problem, each of which we will discuss in detail below.

1. Select a piece of text written in capital letters.

2. Click “Shift+F3”.

3. All capital (capital) letters will become lowercase (small).

Advice: If you want the first letter of the first word in a sentence to be capitalized, click “Shift+F3” again.

Note: If you typed text with the CapsLock key active, pressing Shift on those words that should have been capitalized, they, on the contrary, were written in small letters. Single press “Shift+F3” in this case, on the contrary, it will make them larger.

Using built-in MS Word tools

In Word, you can make capital letters lowercase using the tool "Register" located in the group "Font"(tab "Home").

1. Select a piece of text or all the text whose case settings you want to change.

2. Click the button "Register" located on the control panel (its icon is the letters "Ah").

3. In the menu that opens, select the required text writing format.

4. The case will change according to the writing format you have chosen.

That's all, in this article we told you how to make capital letters small in Word. Now you know a little more about the capabilities of this program. We wish you success in your further development.

To change capital letters to lowercase letters, press the Caps Lock key on your keyboard. If you need to type a small number of capital letters, hold down the Shift key and, without releasing it, press the letters you need. When the text is printed, change its case using the key combination Shift+F3. The Word text editor has a special menu item that controls case.

You will need

• keyboard

Instructions

Greetings, dear readers. Today I will share with you some very useful function in Excel, namely, I will tell you how to make all letters CAPITAL in Excel. When working with Word, this is quite easy if you know. How to do this in Excel? Let's figure it out together.

How is this done in Word? You need to highlight the word and press SHIFT + F3. After a few clicks we will get all words in UPPER CASE. What happens in Excel? He suggests entering a formula.

The fact is that in an Excel table you need to use special formulas that convert words to UPPER or lower case. Let's consider two cases - when everything is written in CAPITAL letters, and when in small letters.

I prepared a table for one of the lessons (), and I will use it. I will work in Excel 2013. But the method for turning capital letters into small letters and vice versa will work in Excel 2010, 2007.

How to make small letters BIG

In my table, the data is located in column A, so I will enter the formula in column B. In your table, you can do it in any free column, or add a new one.

So let's start with cell A1. Place the cursor on cell B1, open the “Formulas” tab and in the “Function Library” section select “Text”.

In the drop-down menu we find “UPPER CAPITAL”. The “Function Arguments” window will open, which requests the address of the cell from which the data will be taken. In my case, this is cell A1. I choose her.

After that, I click on “OK”, or faster, press ENTER on the keyboard.

Now in cell B1 it says “=UPPERCASE(A1)”, which means “make all letters in cell A1 CAPITAL”. Great, all that remains is to apply the same formula to the remaining cells in the column.

Move the cursor to the right edge of the cell and the cursor becomes a thick cross. Hold down the left mouse button and drag to the end of the data column. Let go and the formula is applied to all selected rows.

That's all. Look how it looks on me.

How to make BIG letters small

Once we've succeeded in forming capital letters, I'll show you how to return them to lowercase letters. I have Column B filled with big words, so I'll use Column C.

I'll start with cell B1, so I put the cursor in C1. Open the “Formulas” tab, then “Text” in the “Function Library”. In this list you need to find “LOWER” from the word “lowercase”.

A window pops up again asking you to specify a cell with data. I select B1 and press Enter (or the “OK” button).

Next, I apply the same formula to the entire column. I move the cursor to the lower right corner of the cell, the cursor turns into a thick cross, hold down the left mouse button and drag to the end of the data. I let go, and the job is done. All CAPITAL letters have become small.

How to save data after changes?

I think this is a good question, because if you delete the original values ​​​​from column A, then all the results of the formula will be lost.

See what you need to do for this.

We select all the received data in the result column. We copy them CTRL + V (Russian M), or right-click – “Copy”.

Select an empty column. Then right-click in it, find the special Insert options and select “Values”.

Here's the trick. Now you won't be confused by the need to convert all letters to UPPER or lower case.

Good day to everyone, my dear friends and readers of the blog site. It's probably happened to you that you were writing a word or sentence in Word, but suddenly you wanted to somehow highlight the text and make each letter in the text capitalize instead of lowercase. Or maybe vice versa? Have you written a text with Caps Lock held down and want to make all letters lowercase? So today I’ll show you how to make all letters capitalize in word and vice versa, in two ways at once.

Method No. 1

The easiest way, which will work in any version of Word, is to highlight the part of the text that you want to make completely capital, and then press the key combination SHIFT+F3. But what’s most interesting is that the case change occurs in two stages: first, only the first letters of each word become capitalized, and when pressed again, absolutely all letters become capitalized.

Method No. 2

The second method is even simpler than the first. You just need to select the fragment where you want to change the register, then go to the “Home” tab and click on the “Register” button. The screenshot below shows what it looks like. And here you are immediately given several options for the development of events. I won’t list them, everything should be clear.

Well, in general, if you decide to make all the characters in capitals, then do not forget to press the magic key before typing Caps Lock. Then you will no longer have to perform any manipulations with changing the register).

That's basically it. Now you know how to turn lowercase letters into capital letters, and I really hope that my article today helped you, so don’t forget to subscribe to updates on my blog articles. It will be interesting. Good luck to you. Bye bye!

Best regards, Dmitry Kostin.

Do you know when you're typing in a document and then look at the screen and realize you forgot to turn off CapsLock? All letters in the text are capitalized (large), they have to be deleted and then retyped.

We have already written about how to solve this problem. However, sometimes there is a need to perform a radically opposite action in Word - make all the letters capital. This is exactly what we will talk about below.

1. Select the text that should be printed in capital letters.

2. In a group "Font" located in the tab "Home", press the button "Register".

3. Select the required register type. In our case, this is “ALL CAPITAL”.

4. All letters in the selected text fragment will change to capital letters.

You can also make capital letters in Word using hotkeys.

1. Select the text or fragment of text that should be written in capital letters.

2. Press twice “SHIFT+F3”.

3. All small letters will become capital letters.

This is how easy it is to make capital letters from small letters in Word. We wish you success in further exploring the functions and capabilities of this program.

When formatting a text document, there is often a need to make all letters capitalize. In addition to the most basic method with caps, there are two more methods for solving the problem. Let's look at it in more detail below.

What are these “CAPITAL” letters?

In order not to be confused between the names: uppercase, uppercase and lowercase letters, it is worth considering examples.

“IF THE SENTENCE IS WRITTEN IN CAPITAL LETTERS” - in another way they say that the sentence uses only capital letters or capital letters.

“if the text is written in small letters” - this means that only lowercase letters are used in the text.

Now, after a clear example, it will become easier to call a spade a spade and you won’t have to replace “capital letters with capital letters.” So, to make lowercase letters capital letters, you should choose the most suitable one from the methods below.

Using the Register icon

To make the text in capital letters, you should first select it (Ctrl+A), or select only the desired fragment by double-clicking the mouse. Next, you need to open the “Home” tab in the main menu. Find the “Font” area and click on the case sign. Select the “ALL CAPITAL” option.

The selection will change from lowercase to uppercase.

Key combination

Select the part of the article that you want to convert to capital letters. Hold down the "Shift" key and click on "F3" the required number of times until the text takes on the desired form.

Which has very broad capabilities for processing various text documents is the Microsoft Word program, included in the Microsoft Office package. It is very important that Word has all the necessary tools for formatting any text. For different fragments of the same text, you can set almost any setting: color, font size and type, visual effect, and also apply a large set of styles in order to design what you have written. This article will discuss the capabilities of this program, as well as how to make all letters capitalize in Word and vice versa.

Key features in Microsoft Word

In Word you can set the alignment of lines and paragraph indents relative to the sides of the page. You can display any selected text as a bulleted or numbered list. In addition, in Word it is possible to divide what is written into columns, the parameters and number of which can be set additionally.

Using Word, you can insert various pictures, inscriptions, formulas, diagrams and other objects into text. You can also use the built-in tools in Word and create your own diagrams and drawings. For more convenient use, the program has the following service features: hyphenation, a mode for checking the correct spelling of document text, a process for automatically replacing various combinations of characters with the desired phrases or words. When preparing a document for printing, you can design the title page using standard templates, as well as create header and footer content, margins, orientation, and page format. In addition, before printing, you can preview several pages of the desired document at once.

How to make all letters capitalize in Word

Here's a little instruction. In order to make all letters capitalize in Word, you should follow a number of steps:

• First you need to select the printed text.
• Then you should go to the toolbar, and on the tab called “Home” click the “Register” button.
• In this list, select the entry “All capitals”.

This way you can change capital letters to lowercase, and also give a command to change the first letter in a word to capital and vice versa.

How to make capital letters small in Word

A similar problem often worries those people who do not know how to touch-type, looking at the computer or laptop screen rather than at the keyboard. If you press the Caps Lock key once, you may not notice that all the text will be written in capital letters. Therefore, in order to make capital letters lowercase, you will need to take the following steps:

1. First, you need to select that part of the text in which the letters need to be made small.
2. After this, you should open the tab called “Home” and find the “Font” section there.
3. Then you need to left-click on the “Aa” icon. This icon, depending on which version of Word is installed on the computer, can be located in different places, including in the “Home” tab.
4. Then you need to press the key combination Shift + F3 or select the “All lowercase” tab in the menu. Immediately after the action is completed, all highlighted words and letters will become small.

How to make text in capital letters in Word? You should remember that the “Aa” icon is responsible for the case, and if you click on it, you can format the text as needed: change large letters to small ones and vice versa. If you know this, then there should be no questions left about how to make all letters capitalize in Word.

Conclusion

So, the Microsoft Word program has truly extensive functionality. With its help you can very quickly convert small letters into large ones and vice versa. It is very important and useful for all users to study in more detail and thoroughly all the possible functions of this text editor.