Md. Asaduzzaman
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.
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.
- 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
- How to Align Colon in Excel (4 Easy Methods)
- Align Shapes in Excel (5 Simple Methods)
- Change Alignment to the Right in Excel (5 Quick Methods)
- Align Two Sets of Data in Excel (6 Suitable Examples)
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.
- Then, a new pop-up window named Format Cells will appear on the screen like the image below.
- Subsequently, go to the Alignment >> click on the Horizontal drop-down option >> Select Center as shown below.
- 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.
- 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.
- 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.
