The appearance, or formatting, of cells can be altered in many ways. There are 6 categories of format settings for cells:

  • Number
  • Alignment
  • Font
  • Border
  • Fill
  • Protection

And the 3 primary ways to do cell formatting are:

  • Using the context (right mouse click) menu
  • Using the ribbon
  • Using Keyboard Shortcuts
#1)
Formatting cells using the context (right mouse click) menu:

First:

Select the cells you want to format. In this example, the range of D5:D11.

Then:

Right mouse click to bring up the menu. Then select Format Cells...

Then:

The Format Cells dialog is shown.

Here we have selected the Number tab and selected number formatting with zero decimal places and have checked the Use 1000 separator (,) checkbox.

The result:

The numbers in column D are now better formatted.
#2)
Formatting cells using the ribbon:

First:

Select the cells you want to format. In this example, the range of D5:D11.

Then:

Click the button on the Home tab.

Then:

Click the button.

Then:

The Format Cells dialog is shown.

Here we have selected the Number tab and selected number formatting with zero decimal places and have checked the Use 1000 separator (,) checkbox.

The result:

The numbers in column D are now better formatted.

Summary

The appearance, or formatting, of cells can be altered in many ways. There are 6 categories of format settings for cells. Cell formatting can be done through keyboard shortcuts, context (right mouse click) menu, or using the Excel ribbon. Which method you use is a matter of personal preference. If you tend to make the same format change over and over, keyboard shortcuts or using the button on the ribbon tend to be the easiest.