Monday, October 28, 2013

Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally

How do you move one cell diagonally by using shortcut key?

Suppose the cell pointer is in the [F10] active cell. We want to move to G9, H8, I7, etc. diagonally for an example.

I have the trick to get the task done moving diagonally one cell to the adjacent cell that you can follow the 4 moving ways as step below:
  • Enter the [Up Arrow] [Right Arrow] to move one cell pointer diagonally from F10 to G9
  • Enter the [Down Arrow] [Right Arrow] to move one cell pointer diagonally from F10 to G12
  • Enter the [Up Arrow] [Left Arrow]to move one cell pointer diagonally from F10 to E9
  • Enter the [Down Arrow] [Left Arrow] to move one cell pointer diagonally from F10 to E12



Hope this trick helps you for dealing Excel workload:

See you again.

Michael Leng is Thai, has a BA in Hotel management from Ramkhamhaeng University. He had worked for some hotels. Currently he works in logistics field, Bangkok, Thailand. Because of loving in English,  he has written some his own blogs in English-he really wants any feedback about his English he has posted.

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

Saturday, October 19, 2013

[Shift]+[Arrow Keys] Expanding The Current Cell To Another Active Cell

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]
  1. You can select the number of the cell beginning as many as you want. It is possible to select only one cell or more.
  2. Keep pressing the [Arrow Keys] continual again and again until meet the final cell you wanted, do this while pressing the [Shift] key first and hold it every time.
Function Key
Result Description
[Shift] [Left Arrow]
Expending the selection to the adjacent cell on the left.
[Shift] [Right Arrow]
To expand the selection to the adjacent cell on the right.
[Shift] [Up Arrow]
Extending the selection to the adjacent cell above
[Shift] [Down Arrow]
To extend the selection to another underneath cell.


Hope these shortcut ways help you a bit more organize your Excel spreadsheet workload.

See more shortcut:
You might like my another blogs:

Friday, October 11, 2013

[F12] Excel Shortcut Key Display The “Save As” Function Fastest Way

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 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 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]
Display the {Save As} dialog box instantly.

Benefits:

• A handy way, at one's fingertips.
• Save time. It does’ take more than a second.
• Done by without “Mouse”.
• It’s not clunky at all.

See more another tips:
You might like my another blogs:

Tuesday, October 8, 2013

[Ctrl]+[Shift]+[Page Down] Select The Current & Next Sheet In A Workbook

Do you know In Excel workbook, there are many shortcut ways to navigate Excel worksheet(s)?

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 of keyboard letter keys as a combination.

The following is the shortcut approach:
  1. Pressing the [Ctrl] key and keep it holds down
  2. Then, to press the another key [Shift] button and hold it down as well
  3. Again, pressing onto the [Page Down] key button that it is usually immediate underneath the “Page Up” button on the right side of a keyboard
  4. Move your fingers away from all the key buttons
That is finished the shortcut key.

What does the shortcut afford us?
  • Save time and shorter way.
  • Go respectively from the first worksheet through the next sheet(s) as desired when to stop.
  • Never skip from one Excel worksheet to another worksheet concerning Excel default elements.
Is there another choice to proceed instead of the only shortcut?

Yes, there is.

There is other alternative to use and respond as the same result. Hereafter is the method:
  1. To use the mouse pointer clicking on the “Sheet tabs” of the current worksheet
  2. Secondly, use your finger pressing the “Ctrl” key button
  3. The last thing to do is to move the mouse pointer and click onto the NEXT “Sheet tabs” of the worksheet(s)
Function Key
Result Description
[Ctrl]+[Shift]+[Page Down]
Select the current worksheet and the next worksheet in a workbook.

Monday, October 7, 2013

[Ctrl]+[Shift]+[Page Up] Select Current And Previous Sheet In Workbook

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 worksheet to another worksheet.

Please be noted that:
When this shortcut key works on the Excel worksheets, you can see the “Sheet tabs” being indicated by transparency.
Function Key
Result Description
[Ctrl]+[Shift]+[Page Up]
Excel Shortcut Key Select The Current And Previous Sheet In A Workbook.

See more tip:

Thursday, October 3, 2013

[Shift]+[F4] Excel Shortcut Key To Seek Easily The ‘Last Find’ Cell

When one is working on 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 is you have sought latest. There is an easy way get to the "Last Find" by using shortcut method below.

Hereafter, the shortcut key can head you getting to.

Keyboard shortcut method:
  1. Press the [Shift] key and hold down
  2. Again, press the [F4] key
  3. Move your finger from the 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 using
• More easier method
• Save your time

Function Key
Result Description
Shift + F4
To seek for the ‘Last Find’ cell 

See you again.

Michael Leng is Thai, has a BA in Hotel management from Ramkhamhaeng University. He had worked for some hotels. Currently he works in logistics field, Bangkok, Thailand. Because of loving in English,  he has written some his own blogs in English-he really wants any feedback about his English he has posted.

See more another tips:
You might like my another blogs:

Tuesday, October 1, 2013

[Ctrl]+[Arrow Keys] Move To The Edge Of Next Region Cells Data Entering

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 choose one of the four [Arrow Keys] set, Left; Right; Upper and Lower Arrow.

Function Key
Result Description
Ctrl + Arrow Left
Move to the edge of the next left region cells data entering
Ctrl + Arrow Right
Move to the edge of the next right region cells data entering
Ctrl + Arrow Up
Move to the edge of the next upper region cells data entering
Ctrl + Arrow Down
Move to the edge of the next lower region cells data entering

See more shortcut:

[Tab] Move One Cell To The Right / [Shift]+[Tab] Move To The Left-Excel

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 to the above or below cell, after you have done the shortcut way, then you can use the “ARROW ” key to move the cursor to wherever as YOU aspect.


Function Key
Result Description
TAB
To move one cell to the adjacent on the right 
SHIFT+TAB
To move one cell from the current active cell to the left  

Did this article help you?

I really hope it helps regardless of resolution for you.

See more tips:


You might interest my other blogs?