Skip to main content

Posts

Showing posts from December, 2013

F2 Shortcut Edit Active Cell And Positions The Insertion Point At The End Of The Data Entered | Exceltip2day

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

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

Ctrl+Y To Redo Last Action (Multiple Levels) Excel Shortcut Key | Exceltip2day

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

Ctrl+Z To Undo Last Action (Multiple Levels) Excel Shortcut Key | Exceltip2day

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

Ctrl+.(Full stop) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection | Exceltip2day

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