View or Print all formulas in a Sheet

If you want to View or Print all formulas in excel cell, you can select that cell and view the formula in formula bar. You can also view the formula of selected cell by pressing the F2 Key. But if you want to see the formulas in a sheet, you can go to Formulas Tab and click on Show Formulas. READ MORE

Insert table from excel to Gmail or Blogger

If you have information in excel in the form of table and you want to copy and paste it to gmail, or in the blogger compose box, the formatting will not be pasted in gmail compose window. It will paste the data without border and colours.To paste the table with formatting in Gmail, follow these steps:1. Copy the table in READ MORE

Change the comma separator from lakhs to million

Change the comma separator from lakhs to million: Numbers entered in excel shows the comma separator when the format of the cells are accounting format. Comma separator may be for lakhs or for million based on the region selected in the windows operating system. Sometimes you may want to show the numbers in millions but excel will show in lakhs. READ MORE