Hi Prabodh,

If you access the View Departments window within the Financial Reporter, you can edit existing Department Masks. If there are any leading spaces in front of the department mask code, this appears to prohibit the .Range expansion of a selected department mask from the toolbar.

If you delete the leading space(s) and save the change, this will allow expanding the SmartSheet to work, and this has no effect at all on the correctness of the expanded results.