Format Data

J

Jen

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?
 
P

Pranav Vaidya

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,
 
J

Jen

No - This does not work in a pivot table.

Pranav Vaidya said:
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!!
Click to expand...
 
Top