Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Data
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Data
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!! "Jen" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Data
No - This does not work in a pivot table.
"Pranav Vaidya" wrote: 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!! "Jen" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
format cell data to display stacked data | Excel Discussion (Misc queries) |