Monday, December 23, 2013

[F2] Shortcut Edit Active Cell And Positions The Insertion Point At The End Of The Data Entered.

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.

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.

See more another Excel Shortcut:
You might like my another blogs:

Tuesday, December 17, 2013

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

In 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 keyboard shortcut to make it out instead of using the “Redo” square button as well.

Shortcut method step by step:

• Press and hold the [Ctrl] key button.
• Press the [Y] key button.
• Release the both key buttons.

Benefit:
  • To help us to accomplish the “REDO” task our Excel worksheet easily.
  • To handle it without PC mouse.
Function Key
Result Description
[Ctrl] + [Y]To Redo Last Action (Multiple Levels)


See more another Excel Shortcut:
You might like my another blogs:

Friday, December 13, 2013

[Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key.

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 keyboard shortcut to figure it out instead.

Shortcut method:

• Press and hold the [Ctrl] key button.
• Press the [Z] key button.
• Release the both key buttons.

Benefit:

To help you to proceed the “UNDO” in your Excel spreadsheet alternately. Especially, you don’t need to use PC mouse while doing the shortcut.

Function Key
Result Description
[Ctrl] [Z]To Undo Last Action (Multiple Levels)

Wednesday, December 11, 2013

[Ctrl] [.] (Period) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection

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

Shortcut method consists of the following steps:
  • Press and hold the [Ctrl] key button.
  • Press the [.](Period) key button.
  • Release the both key buttons.
Benefit:

Help you to access the cell aims (targets) easily at the corner of the selecting cells.

Function Key
Result Description
[Ctrl] + [.](Period)
Move clockwise to the next corner of the selection.


See more another Excel Shortcut: