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:
you should see technique 2 in http://excelansguru.blogspot.in/2009/09/excel-topic-cells.html
Post a Comment