Friday, June 28, 2013

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

"How to unlock the Scroll Lock"

Check the way [Turn Off] / [Turn On] - Scroll Lock down here...

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


-All Programs,


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

Turn Off / Turn On Scroll Lock
To lock and unlock Scroll Lock on a keyboard

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

Excel office is the real great invention for all over the operation and administration offices, I believe. It’s very good for working with figures in various types of tasks.

Therefore, let’s say it is necessary to have it in the office if you want to run whatever job or business. And of course, it’s nothing at all if you only buy and install it in your working place but you have no one be able to use it.

Even you have your staff(s) who is able to handle it well about the Excel functions. Never forget that Excel is invented by the computer engineer specialist. There are a lot of constraints inside the program. We, the general user, cannot understand everything about how they work.

Meantime, it seems you should have to hire one more staff who know the way fixing your office program.

Ah! Some may say

“I have just begun running my own business, if some overheads could be saved, I would do”

Yes, all of the problems always have the way out.

There are several solutions to help you find out how to save your money and on the other way, supporting you I.T.’s burden such as Word, PowerPoint… and especially, Excel office as well.

For example, guessing you have visited this article due to you have got the problem of your Excel scroll is locked, am I right?

After you have followed what I have shown you how to solve the scroll lock, then if you could fix it out,… so that this is one of your answer(s).

I mean you can fix some of your problems about Excel office by yourself, few slight bugs you just searching advise via the internet which is written by the blogger(s) who has his/her own individual skill for the particular stuff.

They, Excel office experts, just await you visiting their weblogs/websites.

Instead of spending money to hire your staffs or consuming your time for searching the knowledge from bloggers or many other websites, you can buy Excel books for regular users or an advance from professional authors too.

For me, I do it both, bought several Excel user guidebooks and also look it out from the internet.

Now! It’s your turn. Make it your own way, then you would know that Excel office’s problems like an “Excel scroll lock” for the example, is too hard to cope it at all.

Are you agree?

Let me know if you have some opinions that you would like to share with me on this blog. Simply leave your thoughts in the comment square box immediately underneath this article.

Thanks for your reading my post.

Please keep in touch with through this blog, I would very happy to hear some voice from you there.

Please don’t forget to share my blog(s) with your friends for anyone that you think this is worth for them than none at all.

Have a present day!

See you again.

Thanks for reading.

Posted by: Michael Leng

I've known, then I've grown.

See more shortcuts:

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


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.

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

Thanks for reading.

Posted by:Michael Leng

I've known, then I've grown.

See more another Excel Shortcuts:

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?

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

Hello, I'm Michael Leng. Today, I'm going to tell you about how to reduce your Excel file size.

Why does my excel file size too big?

Mmm, well, let us come to the three methods resolve the problem.

Let's start the 1st. part following:

↪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 the administration. It has some empty spreadsheets in a workbook as default. This is mentioned as above lines earlier. You just delete them.

    1] Right click onto the spreadsheet name tab "Sheet 1, Sheet 2,"

    2] Click the "Delete" function in the ribbon, which is displayed once you have done the "Right click" as line no.1 above right this line.

    Now, we come to the 2nd part:

    ↪Delete un-hide sheet(s).

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

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

      Here we go the last part for today article:

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

      To follow step by step below;

        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!


        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 is the un-seen data cells?

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

        That's the end of my today's ExcelTips post's article.
        Thank you for your kind attention and keep in touch.

        Michael Leng,

        See more tips:

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

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

        Switch to the next current tab of options/features in a dialog box.
        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

        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.


        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.

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