Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Align Right in Excel (5 Simple Methods)

Excel users frequently try to adjust the alignment to improve data representation. As a result, in this article, altering alignment to right will be utilized to demonstrate changing alignment. This post shows you five different ways to align right in Excel.


Download Practice Workbook

You can download the practice workbook from the following download button.


Types of Alignment in Excel

The main types of alignment in Excel are:

  • Vertical Alignment: top, middle & bottom alignment
  • Horizontal Alignment: right, center & left alignment

Types of Alignment in Excel


5 Methods to Align Right in Excel

1. Change Alignment in Excel to Right from Home Ribbon

Now let us begin with the most common way, which is to use Excel’s Ribbon tool to right-align the contents of a cell. So simply follow along.

To do so the steps are: Select data >> Home >> Alignment >> Align Right.

Change Alignment in Excel to Right from Home Ribbon

Read More: How to Change Alignment to the Right in Excel (5 Quick Methods)


2. Aligning Data to Right with Format Cells Wizard

To right-align text, we’ll utilize the Format Cells dialog box in our first technique. Simply follow these few instructions.

📌 Steps:

  • Firstly, select the data range B5:D14, and right-click on your mouse. Choose Format Cells from the list of options.
  • Or, you can press Ctrl+1. After that, the Format Cells dialog box will appear in Excel.
  • Now, go through the following steps: the Alignment tab >> in the Horizontal field, click the drop-down >> choose the Right (Indent) option >> press OK.

Aligning Data to Right with Format Cells Wizard

Read More: [Fixed!] Excel Cell Alignment Not Working (5 Possible Solutions)


3. Aligning Text to Right with Custom Number Format

To right-align text, we’ll utilize the Custom in Format Cells dialog box in this technique. Simply follow these few instructions.

📌 Steps:

  • Firstly, select the data range B5:B14, and press Ctrl+1.
  • Now, the Format Cells dialog box will appear in Excel.
  • Go through the following steps: the Number tab >> Custom >> Type: * @ >> press OK.

Aligning Text to Right with Custom Number Format

  • In the end, the right-aligned country column will appear.

Read More: How to Align Numbers in Excel (6 Simple Methods)


Similar Readings


4. Use Keyboard Shortcut

Whether you’re looking for keyboard shortcuts to right-align text, Excel has got an excellent way. Allow me to walk you through the process below.

📌 Steps:

  • First, press ALT+H then like the following image select data.

  • Pressing AR will align data on the right side of the table.

Read More: All Types of Alignment in Excel (Explained in Detail)


5. Apply a VBA Code to Align Text to Right

Sometimes Excel users could consider automating the same monotonous and repetitive tasks in Excel. No need to worry, since VBA has you covered. In fact, you may completely automate the preceding approaches using VBA code. It’s simple and straightforward; just follow along.

📌 Steps:

  • In the first step, select the D5:D14 cells >> navigate to the Developer tab >> click the Visual Basic button or alternatively just press Alt+F11.

  • Then, navigate to the Insert tab >> Module.

Apply a VBA Code to Align Text to Right

  • You may copy the code from here and paste it into the window. The VBA code is shown below for convenience:
'This is sub routine for right-aligning a range of cells
Sub ExcelRightAlign()
'Using the Selection and Horizontal Alignment properties
 Selection.HorizontalAlignment = xlRight
End Sub

Apply a VBA Code to Align Text to Right

  • As a result of the preceding processes, the final data of D5:D14 will look like this.

  • However, we have other columns where data is not right aligned. To accomplish this, we have selected the remaining left-aligned cells of B5:C14.
  • Now, on the Developer tab, select the Macros button.

  • The Macro wizard appears when you complete this step. To run the Macro, click the Run button.

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


Conclusion

Follow these steps and stages to right align in excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section in the comments box of our blog ExcelDemy.


Related Articles

Al Ikram Amit

Al Ikram Amit

Hi there. I am Amit, completed my study from BUET. Currently, I am working as an Excel & VBA Content Developer at ExcelDemy. Now you can see my articles in ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo