How to Apply Center Horizontal Alignment in Excel (3 Quick Tricks)

Get FREE Advanced Excel Exercises with Solutions!

In our daily life, we have to deal with lots of data. Microsoft Excel is a good place to store those data. In order to store data or create a table, we can format data in many ways.  One of the most common practices for formatting data is to apply center horizontal alignment in Excel. Are you having trouble applying center horizontal alignment in Excel? In this article, we will learn how to apply center horizontal alignment in Excel with 3 quick tricks.


Download Practice Workbook

You can download the Excel workbook from here.


3 Quick Tricks to Apply Center Horizontal Alignment in Excel

There are 3 quick tricks in Excel to apply center horizontal alignment in Excel. We can apply center horizontal alignment to a single cell or in an entire table of datset. The steps are the same for both cases. In this article, we will see 3 examples to apply center horizontal alignment. We will need a dataset like the below one to do so. The dataset contains the Student ID numbers of 6 students and their Total Marks. The dataset shown below is aligned in the default alignment of Excel. Now we will see how to apply center horizontal alignment in the dataset.

3 Suitable Ways to Apply Center Horizontal Alignment in Excel


1. Use Center Content Option to Apply Center Horizontal Alignment in Excel

Using the Center Content option is the easiest and quickest way to apply center horizontal alignment in Excel. If you want to be really quick to apply center horizontal alignment to your data, then this will be the best method to do the job.

Steps:

  • First, select all the cells of your dataset in which you want to apply the center horizontal alignment. For the example shown below, select the (B4:C10) cells.
  • Then, click on the Home tab on your ribbon.
  • After that, click on the Center Content option like the below one.

Use  Center Content Option to Apply Center Horizontal Alignment in Excel

  • As a result, center horizontal alignment will be applied to your dataset like the image below.

Read More: How to Center Text in a Cell in Excel (3 Easy Methods)


Similar Readings


2. Apply Center Horizontal Alignment in Excel Using Format Cells Option

Using the Format Cells option is also an efficient way to apply center horizontal alignment. To do so, follow the steps below.

Steps:

  • First of all, select all the cells of your dataset again in which you want to apply the center horizontal alignment. For the example shown below, select the (B4:C10) cells.
  • Next, right-click on your mouse.
  • As a result, a pop-up window will appear on the screen.
  • Now, click on the Format Cells option from the pop-up window as shown below.

Apply Center Horizontal Alignment in Excel Using Format Cells Option

  • Then, a new pop-up window named Format Cells will appear on the screen like the image below.

Apply Center Horizontal Alignment in Excel Using Format Cells Option

  • Subsequently, go to the Alignment >> click on the Horizontal drop-down option >> Select Center as shown below.

Apply Center Horizontal Alignment in Excel Using Format Cells Option

  • Afterward, click OK.

  • Finally, center horizontal alignment will be applied to your dataset like the below one.

Read More: How to Align Text in Excel (3 Quick Methods)


3. Using Format Option to Apply Center Horizontal Alignment in Excel

Using the Format option is another way to apply center horizontal alignment. This method is quite similar to the Using Format Cells option method. In order to use this method, follow the steps below.

Steps:

  • First, select all the cells of your dataset in which you want to apply the center horizontal alignment.
  • After that, click on the Format drop-down option.
  • Next, click on the Format Cells option as shown below.

Using Format Option to Apply Center Horizontal Alignment in Excel

  • Hence, a new pop-up window named Format Cells will appear on the screen like the image below.
  • Now, go to the Alignment tab >> click on the Horizontal drop-down option >> Select Center as shown below.

Using Format Option to Apply Center Horizontal Alignment in Excel

  • Next, click OK.

  • As a result, it will apply center horizontal alignment to your dataset like below.

Read More: How to Left Align in Excel (3 Handy Ways)


Things to Remember

  • If you want to be really quick and efficient in using Excel, then the Using Center Content method will beth the best option for you.
  • You can use these 3 methods both for a single cell or a table of datasets as shown in this article.
  • You can apply center horizontal alignment to any kind of data such as number, characters, time, and date by following these 3 methods.

Conclusion

Hence, follow the above-described methods. Thus, you can easily learn how to apply center horizontal alignment in Excel. Hope this will be helpful. Follow the ExcelDemy website for more articles like this. Don’t forget to drop your comments, suggestions, or queries in the comment section below.


Related Articles

Md. Asaduzzaman

Md. Asaduzzaman

Hello! I am Md. Asaduzzaman. Currently, I am working as an Excel and VBA Content Developer and I will be posting my articles related to this here. I graduated from Bangladesh University of Science and Technology(BUET) in 2022. I completed my BSc in Naval Architecture and Marine Engineering. I like to solve real-life problems in Microsoft Excel and share the solutions through articles. I post here regularly. Hope you find the articles helpful.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo