Excel shortcuts

How to Use Formatting Shortcuts in Excel

If you're like most people, you probably spend a lot of time formatting your Excel spreadsheets. And if you're like most people, you probably wish there were an easier way to do it. Well, there is. Excel has a number of built-in shortcuts that can save you a lot of time and effort when it comes to formatting your spreadsheets. Here's a look at some of the most useful formatting shortcuts in Excel.

1. Apply or remove cell borders

To quickly apply or remove cell borders in Excel, use the following shortcut:

  • To apply cell borders, select the cells you want to format, then press Ctrl+Shift+7 on your keyboard.
  • To remove cell borders, select the cells you want to format, then press Ctrl+Shift+8 on your keyboard.

2. Apply or remove cell shading

To quickly apply or remove cell shading in Excel, use the following shortcut:

  • To apply cell shading, select the cells you want to format, then press Ctrl+Shift+9 on your keyboard.
  • To remove cell shading, select the cells you want to format, then press Ctrl+Shift+0 on your keyboard.

3. Change the font size

To quickly change the font size in Excel, use the following shortcut:

  • To increase the font size, press Ctrl+Shift+> on your keyboard.
  • To decrease the font size, press Ctrl+Shift+< on your keyboard.

4. Change the font color

To quickly change the font color in Excel, use the following shortcut:

  • To change the font color, select the cells you want to format, then press Ctrl+Shift+F on your keyboard.

5. Change the fill color

To quickly change the fill color in Excel, use the following shortcut:

  • To change the fill color, select the cells you want to format, then press Ctrl+Shift+B on your keyboard.

6. Merge or unmerge cells

To quickly merge or unmerge cells in Excel, use the following shortcut:

  • To merge cells, select the cells you want to format, then press Ctrl+Shift+M on your keyboard.
  • To unmerge cells, select the cells you want to format, then press Ctrl+Shift+U on your keyboard.

7. Apply or remove cell styles

To quickly apply or remove cell styles in Excel, use the following shortcut:

  • To apply a cell style, select the cells you want to format, then press Ctrl+Shift+S on your keyboard.
  • To remove a cell style, select the cells you want to format, then press Ctrl+Shift+R on your keyboard.

8. Wrap text

To quickly wrap text in Excel, use the following shortcut:

  • To wrap text, select the cells you want to format, then press Ctrl+Shift+W on your keyboard.

9. Center text

To quickly center text in Excel, use the following shortcut:

  • To center text, select the cells you want to format, then press Ctrl+Shift+E on your keyboard.

10. Increase or decrease decimal places

To quickly increase or decrease decimal places in Excel, use the following shortcut:

  • To increase decimal places, press Ctrl+Shift+> on your keyboard.
  • To decrease decimal places, press Ctrl+Shift+< on your keyboard.

11. Apply or remove number formatting

To quickly apply or remove number formatting in Excel, use the following shortcut:

  • To apply number formatting, select the cells you want to format, then press Ctrl+Shift+1 on your keyboard.
  • To remove number formatting, select the cells you want to format, then press Ctrl+Shift+2 on your keyboard.

12. Apply or remove cell styles

To quickly apply or remove cell styles in Excel, use the following shortcut:

  • To apply a cell style, select the cells you want to format, then press Ctrl+Shift+3 on your keyboard.
  • To remove a cell style, select the cells you want to format, then press Ctrl+Shift+4 on your keyboard.

13. Apply or remove conditional formatting

To quickly apply or remove conditional formatting in Excel, use the following shortcut:

  • To apply conditional formatting, select the cells you want to format, then press Ctrl+Shift+5 on your keyboard.
  • To remove conditional formatting, select the cells you want to format, then press Ctrl+Shift+6 on your keyboard.

14. Apply or remove cell styles

To quickly apply or remove cell styles in Excel, use the following shortcut:

  • To apply a cell style, select the cells you want to format, then press Ctrl+Shift+7 on your keyboard.
  • To remove a cell style, select the cells you want to format, then press Ctrl+Shift+8 on your keyboard.

15. Apply or remove data validation

To quickly apply or remove data validation in Excel, use the following shortcut:

  • To apply data validation, select the cells you want to format, then press Ctrl+Shift+9 on your keyboard.
  • To remove data validation, select the cells you want to format, then press Ctrl+Shift+0 on your keyboard.

16. Apply or remove cell styles

To quickly apply or remove cell styles in Excel, use the following shortcut:

  • To apply a cell style, select the cells you want to format, then press Ctrl+Shift+! on your keyboard.
  • To remove a cell style, select the cells you want to format, then press Ctrl+Shift+" on your keyboard.

17. Apply or remove cell styles

To quickly apply or remove cell styles in Excel, use the following shortcut:

  • To apply a cell style, select the cells you want to format, then press

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.