How To Change Font In Excel (Excel)

How To Change Font In Excel (Excel)
How To Change Font In Excel (Excel)

Video: How To Change Font In Excel (Excel)

Video: How To Change Font In Excel (Excel)
Video: Excel 2016 - Font Style - How To Change Font Color u0026 Size, Theme, Merge u0026 Center, Italicize u0026 Format 2024, November
Anonim

When you create a new document in Excel, all cells on the worksheet are set to a standard font and formatting options. To improve the appearance of tables in the book and for a better perception of information, these settings can be changed using special tools.

How to change font in Excel (Excel)
How to change font in Excel (Excel)

To change the font of one or several cells in Excel, you must first select them. Then you can use several methods.

1 way

On the toolbar (tab "Home") there is a section called "Font".

Image
Image

Here are the tools to change:

1) The name of the font (typeface). The font is selected from the drop-down list.

Image
Image

By hovering over a particular font, you can see how the appearance of the text in the selected cell changes.

2) The font size can be increased or decreased. To do this, open the list with font sizes (minimum - 8, maximum - 72) and select the desired value.

Image
Image

If you need to specify a font whose size is less than 8 or greater than 72, then you can enter the desired value in a special field.

Image
Image

There are also "Increase Font" and "Decrease Font" buttons to increase and decrease the font size.

3) Font color. To access the list of colors, you need to click on the small arrow next to the underlined letter A.

Image
Image

If you want a complete palette, then select "More Colors".

Image
Image

4) Typeface - bold, italic, or underlined.

For bold type, press "Ж" or use the key combination "Ctrl" + "B".

Image
Image

To apply italics, click on "K" or use the key combination "Ctrl" + "I".

Image
Image

To underline the contents of a cell, press "H" or use the key combination "Ctrl" + "U".

Image
Image

You can also double underline. To do this, click on the arrow next to the "H" button and select "Double underline" in the drop-down list.

Image
Image

You can assign several types of faces at once. For example, bold and italic.

Image
Image

2 way

Right-click on the desired cell (if it is a range, then on any cell in the range) and select Format Cells from the context menu.

Image
Image

A dialog box will open in which you need to select the "Font" tab.

Image
Image

Here you can select all the necessary formatting options - font name, style, color, size, modification.

The Sample box will display the appearance of the cell after formatting has been applied.

To save the changes, click on the "OK" button.

Default font in Excel

You can set the font that will be installed by default when creating a book. For this:

1) In the main menu of the program, select "File" -> "Options".

Image
Image

2) On the "General" tab in the "When creating new books" subsection, select the font name and size (size).

Image
Image

3) Click on "OK" and restart Excel to save the changes.

Recommended: