Skip to main content

Posts

Showing posts from October, 2014

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

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to use the “Select Object” tool in Excel? Tip Quiz What is the shortcut key to select the entire column? The “Select Object” tool is a very good function to handling all about the object like pictures, shapes, SmartArt… In this article, 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 the SHIFT button. Drag mouse to select all over the objects you want. Press the “Delete” button. To be more understood, you can see all the methods step by step through all the images respective below. Figure no.1 Click the "Select Object." Figure no.2 Drag over the objects. Figure no.3 All objects are  selected. Figure no.4 Empty cell after de

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

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to re-format the multiple data entered in an Excel sheet. Tip Quiz Do you know what is the Excel shortcut key for call out "Insert Function" Dialog Box? Do you know the very shortest 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. Figure no.1 Shows the format of the entered data with none arrangement. Figure no.2 Shows the format of the entered data after

Trick To Copy With “Format Painter” With A Single Click But Unlimited Multiple Pastes | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to use “Format Painter” Tip Quiz Is there any trick to exscape away Header and Footer? How can I use “Format Painter” for unlimited multiple pastes? 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. 4] Click on the “Format Painter” again to inactivate the task regards no more use. Before "Format Printer" Processing "Format Printer" After "Format Printer" Tip Answ