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

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

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

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