Excel Tips, Tricks, and Shortcuts

In a populated cell that has, the data entered inside it. If whenever you want to move your blinking cursor from one word on the right to the other word on the left side, which it is in the same populated cell. Now, I show you the way to make it done as below. Method; Press the [Ctrl] button and hold. Then use your right index finger for pressing the [Arrow Left] key button on keyboard That is all done. The blinking cursor will move to the front of the word on the left within the populated cell. In case, you want to move again to the next and next word. Just keep presses the [Arrow Left] key button as many as you do do want to move the flashing cursor while still hold down the [Ctrl] key. Function Result Ctrl + Arrow Left Move One Word To The Left[Inside a populated cell] Review more tips; [Ctrl]+[Arrow Keys] Move To The Edge Of Next Region Cells Data Entering [Shift]+[F4] Excel Shortcut Key To Seek Easily The ‘Last Find’ Cell Turn Off / Turn On Scr...

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to tell you about: Excel shortcut keys begin with "Ctrl" for 89 Keys. If you are seeking for Excel shortcut key to complying with any of your particular sake. Here is the place for you to take a glance and pick the one you like. In addition, you can save our site as your remark about the future visit. This is the list of Excel version 2010 shortcut way by using keyboard key beginning with "ALT" key button for the main key and plus together with another key(s) like letters, numbers, comma, period, semicolon, arrow keys, Caps Lock key, control keys, function keys, page up, page down, command key button and more. Tip Quiz What is the shortcut to open the visual basic editor? Benefits: • The mouse will be never used for this shortcut key. Therefore, you can say goodbye to your mouse from now on. Why we bring thing unless we can leave it at its h...

When we use some excel formula such as formula to combine the data entered of each cell to together. The regular formula that we usually use are: “ CONCATENATE ” and “ & ”. However, somebody who use the mentioned formula above may frustrate that the data entered of each active cell are connecting together completely. There are no space between each group of the data entered. This is the example of the using 'CONCATENATE (A1, A2, A3)' formula: Suppose the data in each of the three active cells as below: A1 [Sales Accumulation] A2 [Sales Forecast] A3 [Actual Sales] Then we put the active cell names into the formula: = CONCATENATE (A1, A2, A3) # Result : Sales Accumulation Sales Forecast Actual Sales See that the three group of word are connected without any room space. Here we go to the trick for making space accordingly. Just add more formula symbols "Double Quotation Mark"[ " " ] between the cell name in a formula, press an [ E...

What It is  Blog writer Michael Leng E-mail address wlapanikorn@gmail.com

What does it Microsoft Excel Office Shortcut Trick and Tip? Microsoft Excel is developed by Microsoft. It has the basic features of all spreadsheets. It’s worked by ordering through tools on the ribbon. Likewise, we are able to use the “Shortcut” to save time and apply its functions to support our requirements. To share my acknowledges about Excel through my blog to everyone who might interesting in it. Excel not only works according to the function tools, but also the shortcut.  I usually use Excel for my daily jobs. Pivot table, formula (Particular “=If(..,..,..)”) , graph, screen shot are the most tools which I have been using. Sometimes I am so nervous when the new assignments have came up just out of the blue. Since, I don’t know lots of Excel formula to finish my works (Inventory report) as soon as possible. How so good if I were very prompt at getting assignment done without taking a long time! I have begun to study Excel function through Excel manual books ,...

Do you know the method of a congregation the data entered from cells? Well, I have two methods for gathering the data entered from each active cell to set into the only one place. To use these formulas to pick up data as you want and link them together in a chain or series into just a single active cell in a worksheet. Here we go to the two ways respectively. 1. Formula ‘CONCATENATE’ = CONCATENATE (text1, text2, text3,) Example: Supposing there are the data entered in each cell as: A1 [Sales Accumulation] A2 [Sales Forecast] A3 [Actual Sales] Replace the active cell names into the formula: = CONCATENATE (A1, A2, A3) Result: Sales AccumulationSales ForecastActual Sales [Click! Kindle Fire HD Tablet - Power by Amazon.com] 2. Formula ‘&’ = text1 & text2 & text3 &, Example: Let’s say the data entered in the active cells follow are as: B1 [Total students] B2 [Students present] B3 [Actual absence] To input the cell names to the series ...

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to count the only number (Excluding text) In Excel , not only calculate the sum amount of figure/number but also result in the number of active cells that having the data(number) in them.  Tip Quiz What is the shortcut to delete cell(s) in Excel Worksheet? The result will give us to know that how many cells which contained the numbers we are using them. This Excel formula will skip counting if those cells are blanked or having another data beside the number(s). Here below is a formula: = COUNT(A first reference cell : An end reference cell ). Pertaining the mentioned formula above will be used for count the amount of cell(s) in column (s)/row (s) within the range declare in a formula. Not capable of counting the alphabet, symbol, empty cell(s) entered into the cells. For example, all the cells in the column from A1 to A8 below being fill...