Friday, June 28, 2013

[Solved] "Turn Off" / "Turn On" Scroll Lock Excel Tip To Lock and Unlock On Keyboard | Exceltip2day Blog

[Turn Off] / [Turn On] - Scroll Lock

In Excel worksheet, you may touch it accidentally a [Scroll Lock] button. This would lock cursor stuck on the current cell. To undo it, do one of the following:

i] Press the Scroll Lock / ScrLk key on your keyboard.

Alternatively, if some keyboard does not have a Scroll Lock key, such as Notebook, Tablet and some other kind of PC. Just follow the step by step.

ii] (Window 7) Go to

-Start,
-All Programs,
-Accessories,
-Ease of Access,
-Then, just click on the "On-Screen Keyboard" line. When the "On-Screen Keyboard" appears on your screen, click the ScrLK button as shown on (In red round rectangle) the image below:

Function
Result
Turn Off / Turn On Scroll Lock
To lock / unlock Scroll Lock on keyboard



That should help you away out from a Scroll Lock stuck on!


Have a nice day!
See you again.
Michael Leng,

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 shortcuts:
You might like my other blogs:

[Ctrl + P] Shortcut Excel Keyboard Key Button to Order for PRINTING

How to get your printed paper(s) for Excel spreadsheet? In your current Excel spreadsheet which your are working in, if you would like to print it instantly. Here is the shortcut keyboard key method to get it printing.

Just follow step by step below:
  • Just only push down the "Ctrl" key on your keyboard and hold it down.
  • While keep doing as above, only press the "P" button on your keyboard.
Then, instantly, the page(s) will show the function of margin adjustment, printer selection, page number choosing, etc.
  • Adjust and set up printing style as you desired. If you have nothing to do so, skip it to the last step beneath that line. 
  • Click the "Print" button to finish your document(s) printing.
Function
Result
Ctrl + P
To print the documents of  "EXCEL" worksheet.


Alternatively, this tip is a shortcut of "Print" function on FILE tab in the Tool Bar Ribbon.

See more another Excel Shortcut:
  1. [F2] Shortcut To Edit The Active Cell With Cursor At End Of The Line
  2. [Ctrl]+[Delete] Excel Shortcut Deleting Text Between The Cursor And The End
  3. [Ctrl]+[Y] To Redo Last Action (Multiple Levels) Excel Shortcut Key
  4. [Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key
  5. [Ctrl] [.] (Period) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection
  6. Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally
  7. [Shift]+[Arrow Keys] Expanding The Current Cell To Another Active Cell
  8. [F12] Excel Shortcut Key Display The “Save As” Function Fastest Way
  9. [Ctrl]+[Shift]+[Page Down] Select The Current & Next Sheet In A Workbook
You might like to my another blogs:
  1. Learn Thai Free Online [LTFO] | Michael Leng
  2. Just Sing Along Blog | Song Lyrics In English-Thai Language
  3. [C+] Cell Phone and Accessory Review
  4. [1English-1Thai] English – Thai Dictionary Learning Blog

Thursday, June 20, 2013

[Ctrl + F] "Find" Shortcut Excel and Keyboard Key Tip | Exceltip2day

In Excel spreadsheet which is full with data in it. For some reason, if we want to look for the particular text, numbers, symbols, etc. in the spreadsheet. What should we simply do that?

Don't worry, Be happy.

Here below the step by step Keyboard Excel and Shortcut key:
  • To press and hold down the "Ctrl" key button.
  • While holding, just pressing the "F" button on your keyboard.
  • Then the "Find and Replace" box will appear instantly on your worksheet, typing whatever you want to see it and press the "Find All" or "Find Next" button to get the return.
Function
Result
Ctrl + F
To find what you are looking for in your "EXCEL" worksheet.

Someone may want to know about the normal function for "FIND". If one doesn't prefer to use keyboard key shortcut as shown above.

Here is how to use it:

In tab function ribbon,
  • Click "HOME" tab which is usually between "FILE" and "INSERT" tab. 
Then, looking for the binocular symbol for "Find and Select" function tab. This sub tab of HOME should locate at the farthest right hand. Then next thing to do is:
  • Click  "Find and Select" function tab.      
After you have clicked it. The other sub tab will display instantly.
  • Again click on "Find" tab.
Then you should see the Find and Replace function box showing at the middle of Excel spreadsheet.

Once you have got the "Find and Replace" box. In the Find what: box, fill your the specific words that you are looking for. then:

1] Click "Find All" suppose if you are looking for what you want the whole working spreadsheet.
Another choice.

2] If you would like to find your lost information just go one by one: Use "Find Next" button.

Additional:

The Replace function button is for replacing your new data that you would like re-write the current data immediately once you found what you look for.

The Option>>> function button is to narrow your finding scopes.

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

Wednesday, June 19, 2013

[Ctrl + X] Excel and Shortcut Keyboard Key To Cut The Selected Data From Active Cell(s)

Guessing many persons, who is using Excel program for daily life working in the office and/or for their own business, really want to use it more simpler.

One of Excel trick and keyboard key shortcut for CUT the data from active cells or the whole spreadsheets to paste at the place that it has been selected.

Step by step for Excel shortcut keyboard key.
  • Press onto the "Ctrl" button and hold it down.
  • Then, press the "X" button.
  • Release the both buttons on your keyboard.
Eventually, to paste it onto wherever as you wish onto your Excel spreadsheet.

Function
Result
Ctrl + X
To cut what you are selecting on particular cells or the whole data on work sheet. Then paste it wherever you wish.


This tip is an Excel keyboard key shortcut of "Cut" function that's on the HOME in the tool bar ribbon (Excel 2010). 

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

[Ctrl + C] Instantly Copy "Data Entered" - Excel Keyboard Shortcut Way | Exceltip2day

As we, MS Excel users, know that in Excel spreadsheet, which is having data entered in it. In case we want to use those data entered that we have added in spreadsheet to put them in another worksheet or active cells. We can do “COPY” the original data from spreadsheet or active cell(s) and “Paste” them at wherever we have decided.

Is there any keyboard key shortcut/trick of “COPY” for Excel?

Yes, of course. Using keyboard key for operating the PC, notebook, tablet, etc. is not bad idea. Because, definitely, it helps us to save time and not necessary to carry a PC mouse with us all the time to wherever we go.

Step by step of keyboard key Excel shortcut for Copying:
  • Selecting all particular data cell(s) or the whole data on the current spreadsheet, which is you want to do copying.
  • Pressing the “Ctrl” button key on keyboard and keeping hold it.
  • Then, just pressing the other key “C” button.
Function
Result
Ctrl + C
To copy what you are selecting on particular cells or the whole data on work sheet.
That’s all.

Next, go to anywhere that you would like to place it and then only do “Paste” function to complete your task.

This Excel tip and Excel shortcut key on keyboard is for Microsoft Office Excel version 2010 and also the other upper and lower version too.

You can find "Copy" function on "HOME" in the tool bar ribbon. (Excel 2010)

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

[Ctrl + Z] Shortcut To Undo the Last Action and Delete The Last Entered Data Entry

Tip for today about Excel shortcut keyboard is "Ctrl + Z". What is it beneficial you who are using an Excel program?

This is to CANCEL(UNDO) to reverse what you have just done for the latest command(last action) in the active cell(s) of your Excel spreadsheet and also to delete the last data entry such as text typing, formula calculating, columns insert, etc. that you have typed or felt out.

Method of keyboard key shortcut:
  • Pressing at "Ctrl" button and hold it down.
  • To press on the "Z" button.
  • Then release such the both buttons as mention above.
FunctionResult
Ctrl + Z
To undo the last action and delete the last entered data.

However, on the other way, you can also use the symbol below(the left back arrow) to perform the actions as same as the keyboard key shortcut previously by using your mouse to click on it(the left back arrow button).

Here below is the symbols of the left back arrow that you could add it into the "Quick Access Toolbar" for more convenience if you use more often.


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

Monday, June 17, 2013

List Of Excel Shortcut Key Begin With [Ctrl] And Follow With Another Keys

Do you have and Excel versions 2010 don’t you?

If yes, now you can find below the list of Excel Shortcut Keys that begin with "Ctrl" and plus with another keys in the keyboard such as:

1. Alphanumeric keys - letters and numbers
2. Punctuation keys - comma, period, semicolon and so on.
3. Special keys - arrow keys, Caps Lock key, control keys, function keys, and more.

Why should we use Excel keyboard shortcut key? What are the benefits of using them (shortcut keys & buttons) on your keyboard?

Benefits:
  • To say good-bye to your mouse, end slavery to it today. Why do we have to carry a mouse unless we don't have to?
  • Useful way to reach the result immediately.
  • More easing method. It is nonsense while your fingers usually type on the keyboard but you have to move your hand to hold mouse for dealing with any functions on the menu bar every time!
  • Save your time and energy. Not much moving your hand.
The Excel shortcut key will return the results displaying as in the table beneath:

Excel Shortcuts
Result
CTRL+ - Delete cell/row/column menu.
CTRL+' (APOSTROPHE) Fill cell formulas down and edit (copy above cell formulas).
CTRL+- WITH ROW / COLUMN SELECTED Delete row / delete column.
CTRL+" Fill cell values down and edit (copy above cell values).
CTRL+. (PERIOD) Move clockwise to the next corner of the selection.
CTRL+; (SEMICOLON) Insert current date.
CTRL+` (GRAVE ACCENT) Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.
CTRL+0 (ZERO) Hide the selected columns.
CTRL+1 Format cells dialog.
CTRL+1, THEN CTRL+ARROW RIGHT/ARROW LEFT Access border menu in 'format cell' dialog. Once border was selected, it will show up directly on the next ctrl+1.
CTRL+5 Apply or remove strikethrough formatting.
CTRL+6 Alternate between hiding and displaying objects.
CTRL+6 Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+8 Display or hides the outline symbols.
CTRL+9 Hide the selected rows.
CTRL+A Display formula window after typing formula name.
CTRL+A (OR CTRL+SHIFT+SPACEBAR) Select the entire worksheet or the data-containing area. Pressing  "ctrl+a" a second time then selects entire worksheet.
CTRL+ALT+ARROW RIGHT/CTRL+ALT+ARROW LEFT Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
CTRL+ALT+F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9 Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+ALT+V If data exists in clipboard: display the paste special dialog box.
CTRL+ARROW KEYS Move to the edge of next data region (cells that contains data).
CTRL+ARROW LEFT/CTRL+ARROW RIGHT Inside a cell: move one word to the left / to the right.
CTRL+B (OR CTRL+2) Apply or remove bold formatting.
CTRL+BACKSPACE Show active cell within selection.
CTRL+C Copy contents of selected cells.
CTRL+D Fill complete cell down (copy above cell).
CTRL+DELETE Delete text to the end of the line.
CTRL+END Move to the last cell with content on a worksheet.
CTRL+F Display the find and replace dialog box (with find selected).
CTRL+F1 Select the active tab of the ribbon and activate the access keys. Press either of these keys again to move back to the document and cancel the access keys. And then arrow left or arrow right.
CTRL+F10 Move workbook windows which are not maximized.
CTRL+F3 Create names from row and column labels.
CTRL+F4 Create a new blank workbook (excel file).
CTRL+F7 Perform size command for workbook windows which are not maximzed.
CTRL+F8 Close excel.
CTRL+F9 Maximize or restores the selected workbook window.
CTRL+G (OR F5) Display the 'go to' dialog box.
CTRL+H Display the find and replace dialog box (with replace selected).
CTRL+HOME Move to the beginning of a worksheet.
CTRL+I (OR CTRL+3) Apply or remove italic formatting.
CTRL+K Insert a hyperlink.
CTRL+L Insert a table (display create table dialog box).
CTRL+N Move to next / previous workbook window.
CTRL+O Save the active file with its current file name, location, and file format.
CTRL+P Display the excel help task pane.
CTRL+PAGE DOWN Move to the first record.
CTRL+PAGE DOWN/CTRL+PAGE UP Select the current and next sheet(s) / select and previous sheet(s).
CTRL+PAGE UP Move to the beginning / end of a field.
CTRL+R Fill complete cell to the right (copy cell from the left).
CTRL+S Display the save as dialog box.
CTRL+SHIFT+! Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+# Apply the date format with the day, month, and year.
CTRL+SHIFT+$ Apply the currency format with two decimal places.
CTRL+SHIFT+% Apply the percentage format with no decimal places.
CTRL+SHIFT+& Apply outline border from cell or selection.
CTRL+SHIFT+* (ASTERISK) Display the list for the current field in a pivottable report.
CTRL+SHIFT+* (ASTERISK) Select the current region around the active cell.
CTRL+SHIFT+: (COLON) Insert current time.
CTRL+SHIFT+@ Apply the time format with the hour and minute, and indicate a.m. Or p.m.
CTRL+SHIFT+[+] If data exists in clipboard: display the insert dialog box to insert blank cells.
CTRL+SHIFT+^ Apply the scientific number format with two decimal places.
CTRL+SHIFT+_ (UNDERSCORE) Remove outline borders from cell or selection.
CTRL+SHIFT+~ Apply the general number format..
CTRL+SHIFT+ Display order menu for insert cell/row and column.
CTRL+SHIFT+ WITH ROW SELECTED Insert row
CTRL+SHIFT+ WITH COLUMN SELECTED Insert column.
CTRL+SHIFT+0 (ZERO) Unhide any hidden columns within the selection*.
CTRL+SHIFT+9 Unhide any hidden rows within the selection.
CTRL+SHIFT+A Insert arguments in formula after typing formula name.
CTRL+SHIFT+ARROW KEY Extend the selection to the last cell with content in row or column.
CTRL+SHIFT+ARROW LEFT/CTRL+SHIFT+ARROW RIGHT Select or unselect one word to the left / to the right.
CTRL+SHIFT+END Extend the selection to the last used cell on the worksheet (lower-right corner).
CTRL+SHIFT+ENTER Enter a formula as an array formula.
CTRL+SHIFT+F Display the format cells with fonts tab active. Press tab 3x to get to font-size. Used to bectrl+shift+p, but that seems just get to the font tab in 2010.
CTRL+SHIFT+F3 Paste a defined name into a formula.
CTRL+SHIFT+HOME Extend the selection to the beginning of the worksheet.
CTRL+SHIFT+O Select all cells with comments.
CTRL+SHIFT+PAGE UP Select the current and previous sheet in a workbook.
CTRL+SHIFT+U Toggle expand or collapse formula bar.
CTRL+SPACE Select the entire column.
CTRL+TAB CTRL+SHIFT+TAB On a field button: select the area you want to move the selected field to.
CTRL+TAB/CTRL+SHIFT+TAB Display the control menu for main excel window.
CTRL+TAB/CTRL+SHIFT+TAB In a dialog box: perform the action for the selected button, or select/clear a check box.
CTRL+U (OR CTRL+4) Apply or remove an underline.
CTRL+V Paste content from clipboard into selected cell.
CTRL+X Cut contents of selected cells.
CTRL+Y Redo last action (multiple levels).
CTRL+Z Undo last action (multiple levels).

Do you find this article useful?

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

Sunday, June 16, 2013

[Ctrl + V] 1 Out Of 3 Methods Paste "Data Entered" - Excel Keyboard Shortcut Way

When you are cutting(Ctrl+X) or copying(Ctrl+C) some data in cell/cells, therefore you are going to paste it onto wherever you have desired. Well, I am going to talk about what you can paste your data entered/content with the most quickly way.

There are three ways. The very fastest way is the first method that I always have used it. The next method is the second method and the third, which they are taking more steps respectively.

Hereafter are the three methods of how to "Paste" data entered in Excel.

1] "Ctrl + V" shortcut keyboard (Recommended: Fastest paste method)
  • Press the "Ctrl" and hold down.
  • Press the other button "V" on the keyboard.
  • Then move your finger out of the two mentioned buttons. 
FunctionResult
[Ctrl] + [V]
To paste what you are copying onto particular area of cell(s) or worksheet.

Then, the content(s) will display instantly.

2] Click on the "Paste" button that it is in the Clipboard group on the "Home Tab" of the Ribbon Bar (Menus)

The second alternative is for who prefer mouse than typing keyboard.

3] The last method, using the "Format function box"
  • Right click your PC mouse on the cell(s) that you want to paste.
  • Click on the "Paste" square button where it is underneath the "Copy" button.

I hope that it would help you work with more ease.

See more another Excel Shortcuts:
You might like another blogs of mine:

Excel Solving "This Workbook Contains Links To Other Data Sources"

When opening an Excel file. Have you ever been annoyed by the message?

"This workbook contains links to other data sources.
  • If you update the links, Excel will attempt to retrieve the latest data.
  • If you don't update the links, Excel will use the previous information. 
Note that data links can be used to access and share confidential information without your permission and possibly perform other harmful actions. Do not update the links if you don't trust the source of this workbook."


Here after steps to do:

1) Select the "Data Tab" on the ribbon.

2) Click on "Edit Links" that it is a sub menu in Connections Group.

3) Click on "Startup Prompt" on the left below of the menu box.

4) Then just tick the option you want in the round box. If you choose "Don't display the alert and don't update automatic links" as shown below, this alert message will never display again.


5) Save it immediately.

All tasks are finished! Enjoy your work.

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 tips:
You might like my other blogs:

Saturday, June 15, 2013

My Excel File Is Too Big | How To ‘Reduce Excel Size’ To Become Smaller

Why does my excel file size too big?
Mmm, well, let us come to the three methods resolve the problem.

Delete un-necessary empty worksheet(s).

Because, some of the Excel workbooks have been setting to display empty worksheet(s) more than one worksheet by default with the sake not waste time to create the new spreadsheet every time when Excel user(s) want to use some more worksheets.

Therefore, if any of your Excel program has been settled by administration. It has some empty spreadsheets in a workbook as default. This is mentioned as above lines earlier. You just delete them.
Method:

1] Right click onto the spreadsheet name tab "Sheet 1, Sheet 2,"
2] Click the "Delete" function in the ribbon, which is displaying once you have done the "Right click" as line no.1 above right this line.

Delete un-hide sheet(s). 

If your file has just hided some spreadsheets and they have no any relevance with your workloads at all,-Delete them as a whole.
Method:

1] Right click onto any Excel spreadsheet name tab to bring out the functions ribbon.
2] Click the "Unhide" function in the ribbon, which is displaying once you have done the "Right click" as the line above.
3] To delete all the "Unhide" sheet that they do not have any relevance to your work data by repeating the step as shown as the method no.1.

Delete the un-used transparent data cells in the current workload sheets

To follow step by step below;
Method:

1] Click onto the end cell that retains data in it. It is usually at the farthest to the left cell of the column [A: bla bla].
2] Press the “Ctrl + Shift + End” buttons and then release.
3] Right click anywhere within the selected highlight cells.
4] Click “Delete” in the format function float ribbon.
5] Immediately, save the file.

That’s all done!

Note: 

Checking the un-wanted transparent data status whether it is gone by click the data ending cell and pressing the “Ctrl + Shift and End” buttons again. It should stop at the actual data-containing cell.

What are the un-seen data cells?

They happen while user clicking to that last cell and then delete data out, but excel will still keep memory on that weeds some place of cell that you have visited last time in spreadsheet.

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

Friday, June 14, 2013

4 Arrow Keys (Upper, Down, Left and Right Arrow) Shortcut Keyboard for Excel

What do you usually do for moving from one active cell to the other? Some people said, “Using mouse to point and click on the desired active cell”.

Well, here we are going on how to use the "4 Arrow Keys" to do it instead of using a mouse clicking.
  • Move UP: Just use your right hand finger press on the “Upper Arrow
  • Move Right: Just use your right hand finger press on the “Right Arrow
  • Move Left: Just do the same way as above, but you just press one the “Left Arrow
  • Move Down: Do the same thing again just press on the “Down Arrow
Note: This tip is beneficial to you for moving from one by one cell in the same spreadsheet.


See more another Excel Shortcut:
  1. [F2] Shortcut To Edit The Active Cell With Cursor At End Of The Line
  2. [Ctrl]+[Delete] Excel Shortcut Deleting Text Between The Cursor And The End
  3. [Ctrl]+[Y] To Redo Last Action (Multiple Levels) Excel Shortcut Key
  4. [Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key
  5. [Ctrl] [.] (Period) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection
  6. Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally
  7. [Shift]+[Arrow Keys] Expanding The Current Cell To Another Active Cell
  8. [F12] Excel Shortcut Key Display The “Save As” Function Fastest Way
  9. [Ctrl]+[Shift]+[Page Down] Select The Current & Next Sheet In A Workbook
You might like to see my another blogs:
  1. Learn Thai Free Online [LTFO] | Michael Leng
  2. Just Sing Along Blog | Song Lyrics In English-Thai Language
  3. [C+] Cell Phone and Accessory Review
  4. [1English-1Thai] English – Thai Dictionary Learning Blog

Sunday, June 9, 2013

[Ctrl] + [Tab] Excel Shortcut Key Switch To The Next Tab In Dialog Box

Do you know that In MS Excel Office Program, there are 2 ways for operating the keyboard shortcut of “Switch to the next tab in dialog box”?

The best answers are below.

Before we go there, we should to know what a dialog box in Excel looks like first.

A dialog box in Excel is a form attached and hidden within some groups of ribbon. It will be explored once the user clicking onto the launcher that commonly located at the bottom below right corner of tools command group.

In a dialog box, it has some different features and options that allow users to use it as aspect in the current worksheet.

Each option in dialog box can be selected by using mouse clicking on it directly. Additionally, there are 2 more alternatives of shortcut key to select it as well.

First Method of Switch the tab in dialog box;
  • Press the [Ctrl] and hold down it.
  • Press the [Tab]
All right, that’s done.

Second alternative method;
  • Press the [Ctrl] and hold down it.
  • Press the [Shift] button and hold it down too.
  • Press the [Tab].
Notify:

Continually pressing the key “Tab” until found the option what you want.

FunctionResult
Ctrl+Tab
Switch to the next current tab of options/features in a dialog box.
Ctrl+Shift+Tab
Same result as above state.
Look at the illustrated image describe the result of using shortcut key below. First result, the tab "Page" is activating, the "Margin" tab display secondly, follow by the "Header/Footer", and the last the "Sheet" option tab.  
 
 

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

Saturday, June 8, 2013

[Alt]+[Space Bar] Shortcut Key Display The Control Menu Main Excel Window

In Excel workbook has out the “Menu Main Excel Window” and allows users to call it out to display for using it. Menu inside the mentioned Excel window is containing the control functions as restore, move, size, minimize, maximize and close.

Generally, this window can be opened by clicking on the Excel symbol [X] on the farthest top left corner of Excel workbook.

Nevertheless, there is one more alternative method to display it too. It’s the shortcut key on the keyboard.

Here the step-by-step shortcut way;
  • Press the [Alt] key and hold down
  • Press the other key [Space Bar]
  • Release the two buttons
Finish.

Function
Result
Alt + Space Bar
Display the Control Menu for Main Excel Window.

Note: Press [ESC] button to escape from the control menu window.


See more tricks;
You might like my another blogs:

Friday, June 7, 2013

In Cell, How To Move A Blinking Cursor From The Left Of Data Entered To The Right?

The populated cell in an Excel spreadsheet, which is retaining data entered inside it. Nevertheless, sometimes if we want move the flickering cursor inside that cell from the left to the right of each word.

To do that, just follow the shortcut way as below:

• Press the [Ctrl] button and keep freezing.
• Then press the [Right Arrow] key button.

Notify:

The flickering cursor will move to the front of the word on the right. It will go from word by word as per the “Right Arrow” being hit. Doing that, remember, it always has to press the “Ctrl” and hold down. Then just keep pressing the “Right Arrow” to go to wherever you want.

Thursday, June 6, 2013

[Ctrl] [Arrow Left] Shortcut Key Move One Word To The Left [Inside A Cell]

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.