I want all my data to be on the left side of the cell

Help Studio
, ,
1

Hi All,

I want all my data to be on the left side of the cell

An Excel spreadsheet titled "input template master" contains data on execution reports with columns for family, function, spec notice number, execution result, and remarks, with certain cells highlighted in yellow. (Captioned by AI)
An Excel spreadsheet titled "input template master" contains data on execution reports with columns for family, function, spec notice number, execution result, and remarks, with certain cells highlighted in yellow. (Captioned by AI)1918×1022 86.1 KB

from 11th cell onwards bot entering data from middle of the cell. But as per the business reequipment Bot should add at the left side of the cell just like row 1.

How can i achieve this.

Thank you!

2

@victoryv4569,

Use Format Cells activity for this.

The image depicts an Excel formatting operation where cells in column A of Sheet1 are being formatted with a dialog box showing alignment options for horizontal (left) and vertical (bottom). (Captioned by AI)

3

@ashokkarale

can you suggest me other way

4

@victoryv4569,

Another one left is VBA Macro.

Sub AlignLeft()
    ThisWorkbook.Sheets("Sheet1").Columns("A:C").Select
    With Selection
        .HorizontalAlignment = xlLeft
    End With
End Sub

Change the Sheet name according to you file.