⌨️ 𝔼𝕩𝕔𝕖𝕝 𝕋𝕚𝕡𝕤 𝕋𝕣𝕚𝕔𝕜𝕤 𝕒𝕟𝕕 𝕊𝕙𝕠𝕣𝕥𝕔𝕦𝕥𝕤

Hello there. Welcome everyone, I'm Michael. Today, I'm going to talk about how to use the key: F2 to operate Excel worksheet. In any active cell, which has the data entered inside it. If you want to edit the data entered in the cell mentioned. There is a shortcut way for getting your work done as shown below. Shortcut for: Shortcut to access inside the cell and edit any data entered   Windows shortcut F2 Hereafter is the method: 1. Click mouse pointer onto the active cell that you want to edit it. 2. Press the [F2] keyboard key. Then the insertion pointer will be inserted and blinked at the end of the line in the active cell. Addition: Shortcut [F2]   also can use for moving the insertion point into the Formula Bar when editing in a cell is turned off too. Thanks for reading. Bye, Posted by: Michael Leng I've known, then I've grown. See more articles: [Ctrl]+[Delete] Excel Shortcut Deleting Text Between The Cursor And The End

When you have felt out the data entered to the active cell. Then, if you want to delete just the only some character of the data entered in that cell. You are able use the keyboard shortcut key to achieve your job being done. Particularly, to delete all the text in the active cell between the cursor and the end of the current line. Shortcut method step by step: • Press and hold the [ Ctrl ] key button. • Press the [ Delete ] key button. • Release the both key buttons. Benefit: To help you to delete the unwanted text in the cell simply. Of course, free PC mouse to proceed your shortcut. Function Key Result Description [Ctrl] [Delete] To delete text between the cursor and the end. See more another Excel Shortcut: [Ctrl]+[Y] To Redo Last Action (Multiple Levels) Excel Shortcut Key [Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key [Ctrl] [.] (Period) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection Excel Trick

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: Ctrl+Y Tip Quiz Do you know what is the shortcut key(s) to display the Find and Replace Dialog Box? In an Excel spreadsheet, if we want to “ Redo ” for the last action. Quite apart from using the “ Redo ” square button on the Quick Access Toolbar, which is allowed us to click on it to repeat the last action. We can use a keyboard shortcut to make it out instead of using the “ Redo ” square button as well. Hereafter it's the way of how to cope with them as I have mentioned for all the above. Shortcut method step by step: • Press and hold the [Ctrl] key button. • Press the [Y] key button. • Release both key buttons. Benefit: To help us to accomplish the “REDO” task our Excel worksheet easily. To handle it without PC mouse. Shortcut:  To Redo Last Action (Multiple Levels) Windows shortcut Ctrl Y Tip Answer  a. I t

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to use Ctrl+Z Tip Quiz Do you know what is the keyboard shortcut for deleting any cell, row, column? What are the highlights you will learn from our article:. ➤  The shortcut key to undo the last action (Multiple levels) in your Excel worksheet. ➤  The figure shows all the step by step of the method. Many of Excel users, who want to perform the “ UNDO ” for the last action, are usually using the Undo on the Quick Access Toolbar by clicking on it. If you don’t prefer to use your PC mouse to click on the Undo. Through, in Excel program has allowed us to use a keyboard shortcut to figure it out instead. Shortcut method: • Press and hold the [Ctrl] key button. • Press the [Z] key button. • Release both key buttons. Benefit: To help you to proceed with the “UNDO” in your Excel spreadsheet alternately. Especially, you don’t need to us

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about: "[Ctrl] + [.](F ull stop or decimal point )" Learn how to use in our tips for today. The figure shows how it goes when pressing the Crtl+. (Period)  Tip Quiz What is the shortcut to select all the data in an Excel worksheet? You can use the keyboard shortcut key to move clockwise the selected cells from one to the next one at the square corner (A square corner is a right angle or a rectangle has four square corners. It is a 90-degree turn at the corner each.). If you have a large range selected and you want to see the four corners of the range this shortcut will take you there. It cycles around the four corners. Shortcut method consists of the following steps: Press and hold the [Ctrl] key button. Press the [.] (Full stop) key button. Release both key buttons. Excel shortcut key: To cycle around the four corners of the ce

What do you do if you want to extend the current active cells to another cell each side? Say about Excel program system, allow user to manage it simply by using shortcut key. Now, If you are selecting whether how many active cell in the worksheet. It doesn’t matter you can extend them(active cells) more to the four sides, left, right, upper, lower of adjacent active cells. Follow these steps: Press the [ Shift ] [ Left Arrow ] to extend the selection to the adjacent cell on the left. Press the [ Shift ] [ Right Arrow ] to expand the selection to the adjacent cell on the right. Press the [ Shift ] [ Up Arrow ] to extend the selection to the adjacent cell above. Press the [ Shift ] [ Down Arrow ] expending the selection to another underneath cell. Note: [Strathmore 100% Pure Cotton Stationery Paper 97, Wove Finish Watermarked 24 lb, 8.5 x 11 Inch, 500 Sheets/Ream - Sold as 1 Ream,bright Ultimate White Shade (318003)-Power by Amazon.com] You can select the number of the

Able to manage Excel workbook “Save As” function very quickly. To show the 2 methods of “Save As” that lead to save the new Excel spreadsheet. What are the differences between both proceedings? The common method: 1 To manage by using a mouse. 2 Taking two clicks totally. Amazon.com: MyGift Multipurpose Black Metal Mesh 6 Compartment Desk Organizer Office Supply Caddy by MyGift The keyboard shortcut key: 1 To discard the mouse. 2 Just the only one of “pressing”. Method shortcut key: Press the [F12] key button, which it locates between the [F11] and [PrtSc] buttons on the upper-right corner keyboard. Method by using a mouse: Move the mouse pointer to click on the [File] tab at the “Menu bar”. On the backstage, click the [Save As] button that it is underneath the [Save] button. Therefore, now just select either the common way or the shortcut key as much comfortable as possible; it is on your way. Function Key Result Description [F12] Displ

Hello there. My name is Michael. I'm glad to be here to share with you how to select the current and the next Excel worksheet. If you use an Excel office, stay with me to gain some acknowledge about Excel office used. Do you know In Excel workbook, there are many shortcut ways to navigate Excel worksheet(s)? Tip Quiz What is the way to move cursor clockwise to the next corner of the cell(s) selection? Today, I have picked one of them to tell all of you. It is the keyboard shortcut to navigate and select from the current worksheet as the starting sheet and go to the next, as many worksheets are required. The function key shortcut has the three keyboard letter keys as a combination. The following is the shortcut approach: Pressing the [Ctrl] key and keep it holds down. Then, to press another key [Shift] button and hold it down as well. Again, pressing onto the [Page Down] key button that it is usually immediate underneath the “Page Up” button or on the right side of a k

If you have many worksheets in your workbook, then you want to select the current sheet as a base sheet and go to any previous particular sheet. As far as I know, the common way is to use a mouse pointer clicking on the current worksheet, press the “ Ctrl ” key button, and then move a mouse pointer to click on the “ Sheet tabs ” of worksheet, as you need. However, Excel program has a trick that allows you to get the same thing as mentioning above. It is a shortcut way, which there are the three keys on the keyboard combine together for making it out. Shortcut key step by step: • Press the [ Ctrl ] key and hold down • Press the another key [ Shift ] button and hold down too • Press the [ Page Up ] key button • Release all the three key buttons That is alright. Does that help and meet to your sake? Benefit: Save time. Shorter way. Best for select from the first selected Excel worksheet and go to the previous worksheet consequently. There is No way to jump from one

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about the shortcut of: Shift+F4 Tip Quiz How do you redo the last action (Multiple levels) Excel with Excel shortcut key? When one is working on an Excel worksheet if he/she has used the “FIND & REPLACE” dialog box for finding any data entering in the worksheet. Then, if you want to know where is the last data entering into the active cell in the worksheet. Which are you have sought latest? There is an easy way to get to the "Last Find" by using the shortcut method below. Hereafter, the shortcut key can head you get to. Keyboard shortcut method: Press the [Shift] key and hold down. Again, press the [F4] key. Move your finger from both keys. Instantly, the particular “Last Find” cell, which you have engaged before, will be indicated by the square border box on your current  Excel  worksheet. Benefits: • End slavery of p.c. mouse

Do you know that we can move from the cells containing data to the next cells by using shortcut key? Sometimes we have filed data into cells of worksheet. However, not every cell we do put data inside it. Therefore, there are some cells might be empty. I have heralded the empty cells because it is significant for the shortcut key as we are going to explore it today. The shortcut key to move to the edge of the next region cells, which they have the data entered. Those the key buttons are [ Ctrl ] + [ Arrow Keys ]. Method: Press the [ Ctrl ] key button and hold down To push the [ Arrow Keys ] button down while keeping the ‘Ctrl’ key in freezing Keep pressing the ‘ Arrow Keys ’ to some cells as you needed Release the 2 keys Benefit: This shortcut helps you to navigate any cells quickly, which they have the data entering within inside. The empty cells will be skipped. Notice: Remember that the [Ctrl] key is the main button, to begin from it first, then just choos

What do you do to move the blinking cursor from current cell to the right or the left adjacent cell? Generally, you can use your mouse pointer by moving and clicking in the adjacent as needed. However, Excel office has function key shortcut to perform the same thing instead of using a mouse pointer. In a cell in worksheet of Excel office, after entering data into inside it. The cursor is still blinking in the current active cell of the worksheet. If you want to move the cursor from the present active cell to the adjacent cell on the right. Just press the “TAB” key button on the keyboard. On the other way, if you would rather to move the cursor from the current cell to the cell of the left side. Pressing the “SHIFT & TAB” key buttons to activate it. Please be noted: These 2 shortcut key functions, the direction will go from one cell at a time leading to the adjacent cell as per the route regardless as mentioned above. If you want to change the direction such as

Suppose we have input data into the cells in Excel lines of spreadsheet already. The problem to be fixed is how to fill out the respective contents/data automatically such as the 12 months of a year {Jan., Feb., Mar,.}. Also, one with the term of condition that in the cells of every other row has the empty rows(non- adjacent cell) between each of the row. Here we go together to tackle this kind of problem with the tip below: Fill out the first word of the respective data into the first cell. According to the upper illustrated image providing below, it has the word  “Jan”  in cell  “D2” . Next step input the secondary respective content into the active cell underneath next to the left-adjacent cell. In here the “Feb”  is in the cell  “D4” , see the illustrated picture shown below as well. Moving the cursor of your mouse to select the cell "D2" to "D5". Move the arrow cursor mouse to the  "Fill Handle" [a small black square symbol] at th

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to use the  "Fill Handle" to get the varies  6 results.   Tip Quiz Do you think which ribbon tap will be used for escape from the header and hooter function? What are the highlights you will learn from our article: ➤  The 6 methods of how to proceed and getting the returning result of an Excel. ➤  The figure shows all the step by step of the method. Do you know any trick for adding date, number; and so on with double click instead of copying and dragging? In Excel , we are able to input data into the entire column that they are in the same standard respectively with just only a double click such as: Number {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11...},  Day {Sunday, Tuesday,. Monday},  Month {January, February, March, ..December}  Year {2000, 2001, 2002, 2003..} Year {2000, 2002, 2004, 2006..} Year {2001, 2003, 2005, 2007