Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Formatting of Columns
Hello,
Is there a way to view formatting of columns in a quicker way then just going to individual cells and clicking on Format and then cell? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Formatting of Columns
Since each cell can be formatted differently, it would depend.
But if you know the entire column has been formatted the same, click on the column header and go to Format/Cells. If anything but General is highlighted, that is the format of the column. Then, you can change the formatting if you'd like from there... "Daren" wrote: Hello, Is there a way to view formatting of columns in a quicker way then just going to individual cells and clicking on Format and then cell? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Formatting of Columns
That does work. Is there a function that can show me the formats of the
columns without clicking on each one? Thanks! "Sean Timmons" wrote: Since each cell can be formatted differently, it would depend. But if you know the entire column has been formatted the same, click on the column header and go to Format/Cells. If anything but General is highlighted, that is the format of the column. Then, you can change the formatting if you'd like from there... "Daren" wrote: Hello, Is there a way to view formatting of columns in a quicker way then just going to individual cells and clicking on Format and then cell? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Formatting of Columns
You can get some information from =CELL("format",A1)
-- David Biddulph "Daren" wrote in message ... That does work. Is there a function that can show me the formats of the columns without clicking on each one? Thanks! "Sean Timmons" wrote: Since each cell can be formatted differently, it would depend. But if you know the entire column has been formatted the same, click on the column header and go to Format/Cells. If anything but General is highlighted, that is the format of the column. Then, you can change the formatting if you'd like from there... "Daren" wrote: Hello, Is there a way to view formatting of columns in a quicker way then just going to individual cells and clicking on Format and then cell? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show % between two columns in a pivottable | Excel Worksheet Functions | |||
Only show certain columns | Excel Worksheet Functions | |||
Show formatting marks | Excel Discussion (Misc queries) | |||
Cell Formatting will not show up | Excel Discussion (Misc queries) | |||
Formatting to show/not show "DUE" and "RECEIVED" in cell | New Users to Excel |