cancel
Showing results for 
Search instead for 
Did you mean: 
Kenny2schu
Level 1

Centering the data in report columns

Hello QB community, I am a student and developing my understanding of report customization. My question concerns adjusting the position of data within a report column. In excel the data can be centered, left justified, right justified within the cell. It hurts my eyes, okay just my preferential look, to have a lengthy column header with short data and have it not look centered. Yuck.

Is there a way to manipulate the data position within a column for QB Accountant Desktop?

I suppose the alternative to data positioning would be manipulating the header titles to stack upon themselves? Again, like in excel.

Or is it possible to export a report to excel, manipulate the data positioning, then import it back to QB and have it hold the changes?

Thank you for any assistance or answers offered and for being here.

Ken Schu

 

2 Comments 2
JamesDuanT
Moderator

Centering the data in report columns

Hello Kenny2schu,

 

The Alignment or positioning of the report's header can only be changed to Standard, Left, Right, and Centered. You can do it within the report:

  1. Open the report you need and click the Customize Report button.
  2. Go to the Header/Footer tab and go the PAGE LAYOUT section.
  3. Change the Alignment and click OK.

You can also make it default through the Preferences page.

  1. Click Edit at the top menu and select Preferences.
  2. In the Preferences window, select Reports & Graphs.
  3. Go to the Company Preferences tab and click the Format button.
  4. Change the Alignment under PAGE LAYOUT.
  5. Click OK.

Other than that, you can do further customization of the report when exporting it to Excel. Note that these format customization cannot be bring in to QuickBooks. QuickBooks will always use the default set up and works as designed.

 

Please let us know if you need additional assistance with your reports.

Kenny2schu
Level 1

Centering the data in report columns

Thank you for the information. It is helpful to know that I get to adapt to the systems' set up and can let go of the question.

Much appreciated!

Need to get in touch?

Contact us