Tag Archives: Excel

excel add title to chart

Tutorial on how to add title to Excel Chart 1. Click on Excel Chart 2. Chart Tool appears in the ribbon bar. 3. In the “Design” TAB, “Chart Layout” group, select the first one which contains title. 4. Title will … Continue reading

Posted in Tutorials/Tips | Tagged , | Leave a comment

print 4 charts one page excel

This is really simple. Create four charts as you would normally do Create a new sheet Copy and past the 4 charts to the new page. Place them (and resize them) so that they appear one page. Do print preview … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

How to drag formula over thousand of empty rows with one click

If rows are empty, double click short cut on extend formula hand will not work. So what can you do? How can you resolve it? The trick Copy cells from left side column into the one that you want to … Continue reading

Posted in Tutorials/Tips | Tagged , | Leave a comment

Conditional Formatting in Excel – One column based on another

[table] Match1, Match2 A, B D, A E, E F, D K, K [/table] Rule: COUNTIF($B$2:$B$6,C2) Read: If cell c2 value exists in the range B2:B6, then highlight the cells that I have selected in step 1. The above will … Continue reading

Posted in Tutorials/Tips | Tagged , | 1 Comment