Cracking IT Interview

-

Comments

Post a Comment

Popular posts from this blog

Find & Replace + Transpose in Notepad++

-
Image
one of the useful features which I learned in Notepad++ is to transpose a comma separated values to columns using Find and Replace option. This feature is going to save lot time when you have very long list. with the above example, go to replace option (CTRL+H) now enter the values as per below screenshot, Make sure to select the Extended option. when you click replace all you will get same data in a column format.
Read more

Excel - Autofill entire formula column easily

-
Image
Let us take the following example. Now you need to add NUMBER1 and NUMBER2 and display the total. you guys already know its very simple only. just place the cursor on C2 and type =A2+B2 (OR) you can use autosum option but for applying the formula to the entire column there is a simple method. first find total of C2 using above formula or Autosum then place the cursor on the black dot on the C2 cell and double click on the black dot thats it!!!..
Read more