Excel|2007|2003|Microsoft Excel|Formula|Function|Pivto Table|Excel Topics|Passwords|Hyperlink Excel Guru: Excel Topic: Cells

Sunday, September 20, 2009

Excel Topic: Cells

Formatting :

Merge Cells in Excel 2007 Excel 2003/Xp/2000/97

Warp Text in a cell in Excel 2007 Excel 2003/Xp/2000/97

Warp Text in merged Cells in Excel 2007 Excel 2003/Xp/2000/97

Protect a cell in Excel 2007 Excel 2003/Xp/2000/97

Rotate Tex in a cell in Excel 2007 Excel 2003/Xp/2000/97

Create a superscript value in a cell in Excel 2007 Excel 2003/Xp/2000/97

Create a subsctipt value in a cell in Excel 2007 Excel 2003/Xp/2000/97

Draw a line through a value in a cell (Strik through) in Excel 2007 Excel 2003/Xp/2000/97

Draw a border around a cell in Excel 2007 Excel 2003/Xp/2000/97

Change a font in a cell in Excel 2007 Excel 2003/Xp/2000/97

Change the Font size of cell in Excel 2007 Excel 2003/Xp/2000/97

Change the font Color of Cell in Excel 2007 Excel 2003/Xp/2000/97

Format display of text in a cell (i.e. number, dates, etc) in Excel 2007 Excel 2003/Xp/2000/97

Stop "Wrap Text" when pasting in Excel 2007 Excel 2003/Xp/2000/97

Conditional Formatting :

Change the Font color based on the value in the cell in Excel 2003/Xp/2000/97

Automatically alternate row colors (one shaded, one white) in Excel 2003/Xp/2000/97

Automatically alternate row colors ( two shaded, one white) in Excel 2003/Xp/2000/97

Automatically alternate row colors ( three shaded, one white) in Excel 2003/Xp/2000/97

Automatically highlight highest and lowest values in a range of cells in Excel 2003/Xp/2000/97

Automatically highlight expired dates and dates that are 30 days from expiration in Excel 2003/Xp/2000/97

Highlight 1st, 2nd, 3rd hightest scores in Excel 2003/Xp/2000/97

Alignment :
Center text across multiple cells in Excel 2007 Excel 2003/Xp/2000/97

Align text to the top of the cell in Excel 2007 Excel 2003/Xp/2000/97


Validation :

Set up cell to only allow a certain number of characters in Excel 2007 Excel 2003/Xp/2000/97

Setup a cell to only allow numbers in Excel 2007 Excel 2003/Xp/2000/97


comments :

Display comment indicator in Excel 2007 Excel 2003/Xp/2000/97


Miscellaneous:

Hide formulas form apperating in the edit bar in Excel 2007 Excel 2003/Xp/2000/97

Copy and paste only non blank cells (condensing paste range) in Excel 2007 Excel 2003/Xp/2000/97

1 comments:

subhajit said...

you should see technique 2 in http://excelansguru.blogspot.in/2009/09/excel-topic-cells.html

Post a Comment