Skip to main content
P
psc
January 29, 2025
Solved

Headers in center of excel

  • January 29, 2025
  • 1 reply
  • 0 views

Hello,

I know you can center columns in a report, but is there a way to do this for cube views exporting to excel? I've only found a workaround where you go to export it to report and then change it to excel, but this won't work for us longterm.

Would like to be able to do this - ok with either embedded or just exporting.

 

Best answer by CAIGuySeanF

Hey there, not sure if this is what you're looking for but I've uploaded text and used formulas to populate annotation (view).  Once done, you can retrieve in your grid just like other financial data intersections.  

*Having trouble getting images to upload, but hopefully you can see visuals now*

1 reply

M
MarcusH
January 30, 2025

What software version are you using? I know there have been enhancements for exporting to Excel - I don't know what was added in which release. These are the options in V8.2.2 which should centre the text:

 

P
pscAuthor
January 30, 2025

Hi Marcus, I mean to have the entire column in the center - so let's say periodic on the left then the account names in middle and ytd on the right. The above just centers the name of the cell within the cell. I'm on version 8.5 (exciting)!

C
CAIGuySeanFAnswer
January 31, 2025

Hey there, not sure if this is what you're looking for but I've uploaded text and used formulas to populate annotation (view).  Once done, you can retrieve in your grid just like other financial data intersections.  

*Having trouble getting images to upload, but hopefully you can see visuals now*

Terms & ConditionsAccessibility statement