Category: Tricks

How to insert image into excel comment box

How to add comment to excel cell  & insert image into excel comment box ? Excel provides options to put comments to the cell for easy reference. By default this comment will be popped up when you move mouse cursor near to the comment cell. You can enter separate comment to each cell. You can easily

Excel vba pdf : Macro to create bulk pdf in Excel.

How to write Macro to create bulk pdf in Excel ? Excel vba pdf : Excel VBA programming is a powerful tool to automate the task. We can automate the repetitive task and save lot of time in work. In this post you can learn how to automate salary slip creation in pdf format. You can

How to customise quick access toolbar…?

If you use some of the excel commands very frequently and if you find it difficult to call from the ribbon, you can add this command to quick access toolbar with the help of customise quick access toolbar. Default quick access toolbar will contains 3 tools save, undo and redo. You can customise the quick access toolbar

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

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

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