Skip to Content
avatar image
Former Member

In Analysis Office 2.5 SP2 is it possible to format multiple cells?

A new column is added next to an existing measure. This column contains Excel formulas, and should be in % format. However the format can only be changed cell by cell. Is there an option to highlight all cells for a mass update to the format? Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 27, 2017 at 09:06 AM

    Hi,

    Place the cursor on the new Column header then follow as below

    Format -->Format Cells -->New Format for Column <Column name >

    Thanks,

    Raju

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2017 at 02:07 PM

    Thank you Raju! That function worked, I changed the Results of the column (see below).

    Add comment
    10|10000 characters needed characters exceeded