Saturday, November 26, 2011

How to add jpeg picture in your comments?

How to add jpeg picture in your comments?


Interesting question??

The answer is, yes, it is possible. Not directly though but you can definitely add a picture to your comments. It can not only make it look different but can also be useful in terms of space utilization.

Want to learn how? Lets have a look at the steps:

1. Add the comment to the cell by right clicking on the cell & by selecting Insert Comment.



2. Select the comment from the red pointed area (the border of the comment) & right click on the selected area. Select Format Comment from the menu.




3. The below dialog box will appear. This is the major point in the steps. Make sure you get a similar dialog box. The best way to find out is, it will have more than one tab. If it shows only one tab, try the step 2 again.





4. Select Color and Lines & then from Fill Color drop down select Fill Effects.





5. From the Fill Effects dialog box select the picture you want to add to the comment by using "Select Picture" button. Once selected, click OK and then OK on the Format Comment dialog box as well.





6.  The end result is a different looking comment :)





You can always try with Katrina Kaif's or Sunny Leone's picture :-P



Sunday, November 20, 2011

5 of my most used commands

Thought of listing something which I frequently use. Here is a list of 5 of my most used commands in Excel:


    Sort your data using Data - Sort & Filter






      Apply Data Validation using Data - Data Tools




        Apply Conditional Formatting using Home - Styles




          Change the format of text using Home - Font




            Create a Pivot table using Insert - Tables



            Sunday, November 13, 2011

            How to get commonly used commands in the Quick Access Toolbar?

            Before I write something, please see this:


            These are the two commands that I use more than 10 times a day. One is to select Visible cells only and the other one is to Remove Duplicates. I have added these buttons to my Quick Access toolbar so that I do not have to do multiple clicks to perform the operation.

            The quick access toolbar can be customized to show any of your commonly used command. To customize it, go to Excel options - Customize. You can select the commands from the left hand side drop down & list box and add them to the toolbar (i.e. the right side listbox).




            Hope it will make your task a little quicker!

            Saturday, November 5, 2011

            How to add or remove a background?

            Want to show some picture as a watermark to your worksheet?

            You can easily add or remove the background with just one click.

            To add a background Go to - Page Layout tab of the ribbon



            On the Page Layout tab - look for Page Setup group and then click Background. Simply browse to the picture file you want as the background and click Insert after selecting the required file.


            
            The selected picture will be applied. To remove simply click the Delete Background button on the same Page Setup group.