Transpose with formula/FunctionFollow this stepsPut your data in cell A1. Put this formula in cell C1Adjust with requirement.( like you want to new row after 3 columns then put 3 replace 4  (*4 ) )Drag C1 right you  want to fill (its equal to *# values)Drag down to run formula to whole sheet.Formula==OFFSET($A$1,(ROW()-1)*4+INT((COLUMN()-3)),MOD(COLUMN()-3,1))Click...

Search Operators(Creat your own custumize search qu...

Brief into to excel for beginers.Hi friends this is start of excel, you all know very well about this image.Who don't know please read carefully.When u open ms excel 2007 you fund this type page. TABS & MENU BAR. We calls it RIBBON.   lets starts. best of lu...

Hi Friends Please remember to read carefullyCTRL+SHIFT+(Unhides any hidden rows within the selection.CTRL+SHIFT+)Unhides any hidden columns within the selection.CTRL+SHIFT+&Applies the outline border to the selected cells.CTRL+SHIFT_Removes the outline border from the selected cells.CTRL+SHIFT+~Applies the General number format.CTRL+SHIFT+$Applies...