Excel Tips, Tricks, and Shortcuts

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...

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...

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...

Do you know the result of percentage not the same if there is the number “0” within the Range of "Average" Formula? Therefore , how do you solve this problem? To obviously visible what the difference between using Average Formula between the range of the number “Include 0” and “Exclude 0”. 1] Let us have a look at the first sample. We have the table for the whole year of the sales amount. However, there are the two months, which are with the “0” sales amount(Empty cells), July and August. We use Excel formula “=AVERAGE(AB5:AB16)” to calculate the percentage average from January-December. The outcome is 76.11%. That would be true? 2] The second sample, we use all the same data as the number one. On the other hand, we have changed the formula to use “=AVERAGE IF (AB5:AB16,"<>0")” instead. Here we gain 91.33% It does not matter what our calculation criteria is, here, my article is just only to show you how the two formulas work in a d...

Cell is with the decimal number inside it. The number usually keeps at the right of the border. Anyway, if you want to format those figures to be in the middle of cell's border. It is not too difficult at all to do that. Hereafter is the step-by-step format cell to center the figures being in the middle:   Select the cells to be centered. (Cell "B5" ex. image below). Click on the Format Cells > Number > Custom > To type  #,##0.00 into the code box. (Type the among of digit as same as the data entered) Before Process  After If it doesn't work. Align the format cell by clicking the center like below image. See more other tips: How To Escape Away From “Header And Footer” To "Normal View" | Exceltip2day Technical Tip To Select Or Copy Data Entered Between Range Of The Particular Cells And Uppermost Cell (A1) How To Display The Data Entry In All Empty Cells On The Left Of Pivot Table Quick And Easy Way To Paste Data...

With my real experience about using “Header and Footer”, function. I have been frustrated looking around for how to escape away from the view’s status of “Header and Footer”. Firstly, I thought it should have the way out by clicking on the bottom of itself, “Header and Footer”. After I had searched it for a while. I could make it out and want to share you all as bellow: Method of away out from “Header and Footer” view to Normal view. 1] Hover your mouse to the “View” tab and click on it. 2] Click on any cell that out of the “Header and Footer” blank space. 3] Click on the “Normal” tab. 4] Immediately, save your file. Header and Footer Status Select cell A2 which is out of Header blank space Become to Normal View Then, try to close and re-open your file again. It should show you with the normal view. If not, repeat the method above again. (Do not forget to save your file immediately after your page become to “Normal View” status.) See more other tips: Techn...

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to select the cells range  Tip Quiz What is the shortcut to minimize an Excel workbook? One technical tip of Excel using of today that I want to share you all, it is the only private trick that I have tried many times to discover the simple way to copy the data entered between the range of particular cells and an uppermost cell (A1) . Eventually, I found the ideal way to copy or select the desired group of cells as follow: As per the screenshot for an example to show, you right here. Suppose to select and/or copy the wanted cells, which begins from the cell “E13” and the cell “A1” . Including all cells in the range to the upward, cell “E1” , and to the leftward, cell “A13” 1] Hover your mouse to cell "E13" and "Click" on it. (In yellow) 2] Press "Ctrl" "Shift" "Home" buttons at the same time to...