Mastering the commonly used formatted shortcut keys in Excel can greatly improve efficiency. 1. Use Ctrl Shift F to set the font and font size; 2. Use Ctrl B, Ctrl I, and Ctrl U for bold, italics, and underscores respectively; 3. Use Alt HAL/C/R for alignment; 4. Use Ctrl Shift ~ or Ctrl Shift & to call up the menu selection for the format. Proficient in using these shortcut keys can reduce mouse operations and improve data processing speed.

In Excel, formatting operations are frequent and critical. Mastering some commonly used shortcut keys can greatly improve efficiency. Especially when processing a large amount of data, replacing the mouse with a keyboard can save a lot of time.

Quickly set fonts and font sizes

If you want to quickly modify the font or font size of cell text, you don’t need to open the ribbon menu, just use the shortcut keys to complete it.

• Ctrl Shift F : The "Cell Format" dialog box pops up and is located to the Fonts tab, where you can change the font, glyph and font size.
• If you just want to change the font size, you can use the up and down arrows to select the font size in the pop-up window, or directly enter the number (such as "14") and press Enter.

This method is suitable for situations where precise control of font styles is required, such as unified font styles when making reports.

Bold, italic, and underlined in one click

These three items are the most common way to adjust text formats, and Excel provides very convenient shortcuts:

• Ctrl B : Bold
• Ctrl I : Italic
• Ctrl U : Underline

These key combinations are simple to operate, and it is recommended to remember and use them proficiently. For example, when you write a title, you usually use bold and centering at the same time. You can first press Ctrl B and then Alt HAC (the following is the shortcut path to centering).

Alignment without clicking the mouse

Alignment is also one of the formats that need to be adjusted frequently, such as centering the content, left and right, etc.

• Alt HAL : left aligned
• Alt HAC : Center
• Alt HAR : Right aligned

Although these operations have icon buttons, using shortcut keys is faster, especially when you have selected multiple cells to prepare for formatting.

Quickly clear format

Sometimes the data copied in comes with various strange formats, which affects the overall beauty. At this time, you can use the clear format shortcut key:

• Ctrl Space : Select the entire column
• Shift space : select the entire line
• After selecting the area, press Ctrl Shift ~ (tower) to quickly clear all formats and retain only the original data.

If you just want to clear some formats, such as just clearing the border or background color, you can also use Ctrl Shift & to call up the "Clear" menu and then select specific items.

Basically, shortcut keys related to these commonly used formats are not complicated but are easy to ignore. After you are proficient in Excel, you will find that operating in Excel can be done with almost no mouse touch.

The above is the detailed content of excel shortcut keys for formatting. For more information, please follow other related articles on the PHP Chinese website!