Saturday, October 11, 2014

How To Use "Select Object" Selecting All The Rectangular Region Of Pictures And Deleting

Do you know how to use the “Select Object” tool in Excel?

The “Select Object” tool is very good function to handling all about the object like pictures, shapes, SmartArt…

Today, I am going to tell you how to use the “Select Object” for SELECTING multi-objects and delete them all.

Do the following:
  • On the ribbon bar, click the “Find & Select”
  • Click over the “Select Object” tool.
  • Press and hold down SHIFT button.
  • Drag mouse to select all over the objects you want.
  • Press the “Delete” button.
Click the "Select Object"
Drag over the objects
All objects be selected
Empty cell after deleting 
See more other tips:
Would you like to surf my other blogs?

Sunday, October 5, 2014

How To Format The Entire Cells In A Workbook With Just Only A Single Click

Do you know the very shorter way to format the entire cells in a worksheet?

Fortunately, this following method is the best trick as far as I have ever known. It helps you to format the entire cells in a workbook to be the only one unique format. More, it does not complicate at all.

Here comes the step-by-step shortcut:
  • Select the original format cell as wanted. (Ex. Cell B3).
  • Click on the “Format Painter” icon on the top left corner.
  • Press the “Ctrl” “A” buttons on your keyboard.
Done! The outcome should be the same as the images beneath.

Before format
After format
See more other tips:
Would you like to surf my other blogs?

Wednesday, October 1, 2014

Trick To Copy With “Format Painter” With A Single Click But Unlimited Multiple Paste

How can I use “Format Painter” for unlimited multiple paste?

As you might know that using the “Format Painter” Excel function is very useful and save time. 

Nevertheless, not many people know the trick and enjoy using it in a very simple way.

Trick is:

1] Select the specific cell(S) that you want to copy the format. (Ex. as the image below is cell "A2")
2] To click twice quickly without moving the mouse (Double-clicking) onto the “Format Painter” function button.
3] Click to any cell(s) you want to paste the format to.
4] Click on the “Format Painter” again to inactivate the task regards no more use.

Before "Format Printer"

Processing "Format Printer"

After "Format Printer"
See more other tips:
Would you like to surf my other blogs?