Center align

[Kristenl2784]

Hello,

Is there a way to center align ws3 cells as the values from ws1 get written into the ws3?

   ws3[f'A{i+2}']=ws1['A1'].value[28:]
   ws3[f'D{i+2}']=ws1['B4'].value
   ws3[f'E{i+2}']=ws1['D4'].value
   ws3[f'I{i+2}']=ws1['B'][-1].value
   ws3[f'J{i+2}']=ws1['D'][-1].value
   ws3[f'O{i+2}']=ws1['E'][-1].value
   ws3[f'N{i+2}']=ws2[f'I{i+6}'].value 

[bowlofred]

Center alignment requires an assumption of total width. How do you know what the maximum width should be?

It's uncommon to put alignment into your data cells. Instead, you would apply formatting when the data is read/displayed and do it dynamically based upon the data. There are a lot of modules that can take tabular data and apply an alignment to it as printed.