Format Data

[Guest]

Is it possiblt to format multiple columns at once or do you have to format
each column separately? For example, if I have 6 columns, 3 currency and
three number do i have to click in each column or can i format the currecy
columns as once and the number colums as one?

 

[Guest]

By holding down 'contorl' key, you can select multiple columns and format
them, however you have to do all currency in one go and then all number in
one go and so on.

HTH,

 

[Guest]

No - This does not work in a pivot table.

By holding down 'contorl' key, you can select multiple columns and format
them, however you have to do all currency in one go and then all number in
one go and so on.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!