Excel - How do I find out how a cell is formatted

Asked By Joh on 05-Aug-08 10:05 AM
Is there a way to determine how a cell is formatted.  i.e. is it formatted as
1) Text, general, custom 2) Auto row height on or off 3) column width is 3.86
or auto 4) Alignment is General/top 5) Font is arial 8 etc.




RagDyeR replied on 05-Aug-08 10:25 AM
Look up the Cell function in the help files.
May give you what you're looking for.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Is there a way to determine how a cell is formatted.  i.e. is it formatted
as
1) Text, general, custom 2) Auto row height on or off 3) column width is
3.86
or auto 4) Alignment is General/top 5) Font is arial 8 etc.
PepsiOnTheRock replied on 05-Aug-08 02:56 PM
To answer your question # 1:
Click on the word "Format" on the Menu Bar
then click on the word ""Cells..."
then click on the "Number" tab
the current category being used will be lightlighed in dark blue

To answer your question #2 and 3:
Click on the word "Format" on the Menu Bar
then click on either Row or Column
then click on either "Height" or "Width"

To answer your question #4:
Click on the word "Format" on the Menu Bar
then click on the word "Cells..."
then click on the "Alignment" tab
then click on the upsidedown little black triangle
that is to the right of the white space below the word "Vertical:"
then current alignment being used will be highlighted in dark blue

To answer your #5 question:
Click on the word "Format" on the Menu Bar
then click on the word "Cells..."
then click on the "Font" tab
the current font type and size will be highlighted in dark blue