Skip to Content
0

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

Oct 26, 2017 at 02:41 PM

60

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Varaprasad Raju Potturi Oct 27, 2017 at 09:06 AM
0

Hi,

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

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

Thanks,

Raju

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 27, 2017 at 02:07 PM
0

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


t5jdf.png (7.3 kB)
Share
10 |10000 characters needed characters left characters exceeded