Raja Farrukh's Blog

 Excel Unlimited

M.S. Excel: The Father of All Software? A Bold Claim Unveiled   When people think of Excel, they often envision spreadsheets, formulas, ...

M.S. Excel Quick Tips How to Change default font in Excel  >>> Excel Options >> Popular >>  Use this font >...

 Formula and Function Tips and Shortcuts

Insert alternatively rows in existing cell data > insert a new column at left at existing column data > write 1 in...

Conditional Formating in Excel 2007, 2010 Highlight column data in two separate colours > select the data > From Home tab >...

Sorting Go to data tab > Sort > Add Level > sort by column A > then by Column B > ok 

How to filter specific cell data and copy entire rows. Office 2007, 2010 This is my original sheet I like to copy entire...

Delete Empty Rows Quickly 1- select the first column from top to bottom, 2- Press F5 3-Click special 4- check the blank, ok 5-right ...

Select the data go to insert scatter,here are more options  1-lines with marker,  2-only line, select required,  3-only markers right ...

In Excel 2007, data tables display chart values in a grid beneath the chart. Layout, Show data table, show with legends or without legengs....

Navigate cells Complete actions quickly   Up, down, left, right • , ...