Sunday, April 28, 2013

Trick Change Number In Excel From The Far Right To The Far Left Instead

Trick for today, suppose we have fill out the cells with some of the numbers and we want them returning in the opposite way.

The number we have typed in immediately went to the far right of the cells in a row. But we want to make the number go to the far left instead!

How are we able to do that in Excel?

I mean our original data like this;
1 2 3 4 5 6 7 8 9 10 ... and so on until end up at the number 100.

Moreover, we want it to be as below;
100 99 98 97 96 95 94 93 92 91 and so on ..3 2 1 0.

We have three ways to do it.

1] You use transpose paste function systematically below:
  • Transpose it to make it vertical (Copy / Paste Special and select transpose).
  • Sort the data set with the standard sorting function.
  • Select all active cells again and copy.
  • Paste with "Special Transpose" again.
It will look like this flow "Copy data from the horizontal active cells > Transpose Paste to vertical column cells > Sorting data as needed > Copy data from the vertical active cells again > Transpose Paste to horizontal row cells > Done."   

2] Suppose you put them by each number is in its individual cell and horizontally. In addition, the numbers are running up to 100. Starting from cell "A1" with number "1", "B1" with number "2", and so on until the last number "100" will be in cell "CV1"

Therefore, you just put the formula "=" in cell A2 as = CV1, cell B2 as "=CW1", and so on until the last cell in CW2.

The method no. 2 above can be applied and used as your permanent template too.

3] You simply enter the number "100" in cell "A1", "99" in "B1", select the two cells (A1&B1) and move the mouse cursor to lower right corner of the cell "B1", once the fill handle(black small square) appears, just click on the fill handle and drag thru the cells on the right side upon the end cell as needed.

See more tips:
You might like my other blogs:

Thursday, April 25, 2013

[Ctrl] [Shift] [*] (Asterisk) Excel Keyboard Shortcut Select Active Cells

Whenever, you fill out any data into cells in the Excel worksheet. In any reason, if you want to select all the active cells within it (Spreadsheet).

What is the method you are going to do? Do you have your own the "How-To" for handling it?

Whether you have one or have not. I am going to share you the three buttons shortcut way on keyboard of your PC, laptop, notebook, tablet; it is very simply to deal with it.

You just press these buttons “Ctrl + Shift + * (Asterisk)” on the keyboard. This shortcut will result in selecting the current active cells that region around. In case there is just only one empty row or column, it will abandon the other cells group that because the blank cells of the empty row or column will separate them apart.

Well, If you are going to select them all [To select all the active cells the whole spreadsheets], use “Ctrl + A” instead.
Function
Result
Ctrl + Shift + *
To select the current region around the active cells.

This symbol ' * ' is called Asterisk.

See more shortcuts:
You might like my other blogs:

Monday, April 22, 2013

[Ctrl+Shift+O(letter)] Select All Active Cells Insert Comment Shortcut Way With Key Button

In Excel spreadsheet, one of many functions that we use them for job operating, is the “Insert Comment” function. This function is for writing any comment that we don’t want to put on the lines in active cells of Excel spreadsheet.

The insert comment function can be used as of both show and hide of the data added within its box. The "Comment box" is great alternative way for keep data as much as needed and hide them in the particular cell that you want to remark.

Whenever you want to see it, only explore by clicking on the "Show Comment" button.

However, if you wish to find them all the "Insert Comment" in your Excel spreadsheet, you can do it with your fingertip, - by just press the keyboard shortcut keys as below. Then all the active cells that containing with comments will be displayed with the highlight.

Function
Result
Ctrl+Shift+O
To select all active cells with comments.

The above three buttons on keyboard need to be pressed together in the same time. Best way recommended is using your left hand finger press the "Ctrl" and follow with the "Shift" button, then with the pointer finger of your right hand pressing on the "O"(Letter).

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

Saturday, April 20, 2013

[Ctrl+G] Key Buttons Excel Shortcut Seek Out The "Go To" Dialog Box

I am not sure that anyone used to call out the "Go To" dialog box and take advantage to operate job(s) in the Excel Spreadsheet or not. Because this function box is very good for some particular task such as to find all blank cells in the sheet or just seek the blank cells in the range selected.

However, Today I am here to tell you all about on how to explore out the embedded "Go To" dialog box of Excel program. In Excel office program, if you have created name of cells in worksheets for whatever propose.

Whenever you reach the cell name lists. Just simply do it by pressing shortcut below.

Method of shortcut key:
  • Press "Ctrl" button and keep holding it. 
  • Press "G" button.
  • Release the both buttons.
Function
Result
Ctrl + G 
To pop up the 'Go To' dialog box and display cell name lists.


This task can be used "F5" alternatively too. It will produce the same result.

Hi, friends, before you leave from this page. I only want to tell you to open your Excel program and try to press the shortcut buttons as I have shared to as above, "Ctrl" and "G". I believe that you will discover more how excellence Excel is!

See more another Excel Shortcut:
  1. [Ctrl+Shift+O(letter)] Excel Insert Comment Shortcut Way With Key Button
  2. Ctrl + Shift + * (Asterisk) Excel Keyboard Shortcut Select Active Cells
  3. Trick Change Number In Excel From The Far Right To The Far Left Instead
  4. [Ctrl]+[Delete] Excel Shortcut Deleting Text Between The Cursor And The End
  5. [Ctrl]+[Y] To Redo Last Action (Multiple Levels) Excel Shortcut Key
  6. [Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key
  7. [Ctrl] [.] (Period) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection
You might like my another blogs:

Thursday, April 11, 2013

[Ctrl+F1] Excel Shortcut Key To Minimize / Restore Back Ribbon Bar In Workbook

On every Excel worksheet has the "Order Functions" on ribbon. They lay on the "Tabs Menu Bar".

The ribbon bar is containing and displaying the Excel order functions. The ribbon size is around two centimetres. It always takes some space of the spreadsheet area while it has been opening.

Today we are going to seek for the how-to unfold it, ribbon bar, when it is not accessory at a time to show Excel ribbon bar.

Therefore, you will have more space wider in your Excel worksheet to operate your contents in.

See and do repeat steps as below:
  • Pressing the "Ctrl" and keep freeze.
  • Another press onto the "F1"
  • Release both buttons.
That's done.

Function
Result
Ctrl + F1
To minimize or restore the Excel ribbon bar.


Once, considering to restore back the ribbon to show up again as it is used to be. Do the same as the ribbon hide method. Just re-do it by pressing the both shortcut key buttons again, [Ctrl] + [F1].

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

[Ctrl + F3] Shortcut Excel Display Name Manager Dialog Box Define Cell

Excel has various function for using. A worksheet[Excel 2007 and 2010] consists the maximum number of rows 16,384 cells which count from row A1 to XFD1, and columns from A1 to A1,048,576. That makes 17,179,869,184 cells all together in each Excel single sheet.

So, how to recognise a particular cells which you work with formula or some condition.

To define name of a cell is the solution. A name of cell which defining is a meaningful shorthand for Excel user to works it easier and recognise or find a cell reference, constant, formula, or table, each of which may be difficult to comprehend while configure it.

The following is one of many shortcuts for Excel for you to launch its function for define name of cells or dialog box.

Function
Result
Ctrl + F3
To pop up a "Name Manager" dialog box for define cells in spreadsheet

Method:
  • Pressing onto the [Ctrl] button and keep hold it.
  • Press the [F3] button.
Instantly, the "Name Manager" dialog box will pop up for future action.

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

Wednesday, April 10, 2013

[F11] Keyboard Shortcut Create And Insert Excel Chart With Data In Separate Chart Sheet

Thanks for Excel to help us handling lots of job, especially calculation. It is a really wonderwork for office's works.

One of many function of Excel is Chart. It is plotting data to use for presentation for comparing data in any period of time such sales amount, employees attendants, fertility rate, etc.

The "F11" on the top line of keyboard somewhere a bit on the right. Just press on it, then the empty template of "Chart" will come out instantly in the new spreadsheet, which is before the current one.

To repeat you again that this shortcut is best for plotting the data later on after the chart template is available in a worksheet. Moreover, it is in need of new sheet create and insert. Then you can select what type of chart, edit data, and label, which is you want to deal with it.

Function
Result
F11
Create and insert chart with data in current range in a separate Chart sheet.


Additional:

In case you don't want to use the shortcut key {F11}, another way to display the "Chart" is:

Clicking the "Insert" tab ribbon, then you will see the chart that it is commonly shown with the 7 types, column, line, pie, bar, area, scatter, and doughnut. Select one you like and proceed for plotting data entry.

If you want to see more the different kind of chart, simply click on the expanding arrow at the lower corner right down (Dialog box launcher) on the "Other Chart" command botton in the ribbon tab.

See more another Excel Shortcut:
  1. [Ctrl + F3] Shortcut Excel Define a Name or Dialog Box
  2. [Ctrl+F1] Excel To Minimize Or Restore The Excel Ribbon Bar
  3. [Ctrl]+[Delete] Excel Shortcut Deleting Text Between The Cursor And The End
  4. [Ctrl]+[Y] To Redo Last Action (Multiple Levels) Excel Shortcut Key
  5. [Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key
  6. [Ctrl] [.] (Period) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection
  7. Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally
  8. [Shift]+[Arrow Keys] Expanding The Current Cell To Another Active Cell
  9. [F12] Excel Shortcut Key Display The “Save As” Function Fastest Way
You might like my another blogs:

[Alt + F11] Excel Shortcut To Open Visual Basic Editor To Create Macro | "ExcelTip2Day"

Do you use Excel for your tasks?


In Excel Version 2010, There are as far as I know, 2 ways for display the "Visual Basic Editor" box for next proceeding the task in Excel program.

The first choice is recommended. Because it is very quick and easy. The shortcut is as following:
  • Press the "Alt" button and keep hold it down
  • Then also press the "F11" together as the same time
Then, "VBA" box is going to come out instantly as the image shown above.

Function
Result
Alt + F11
To open the Visual Basic Editor to create Macros.


Secondly, pertaining to the "VBA" is commonly located within the "Developer" ribbon tab. Moreover, the Developer tab does design for displaying for instantly use. Hence, we have to bring it out first-then we would see the "VBA" for application later on. Find on the "How To" below:

  • Seek the File tab on the left of Excel Workbook, there, choose the "Options" beneath the "Help"
  • Once the Options dialog box being shown, clicking "Customize Ribbon" on the left side of the dialog box which is under the "Advance" and upper the "Quick Access Toolbar".
  • Selecting the "Popular Commands" under the "Choose Commands From" which is on the left of the dialog box.
  • Under the "Customize The Ribbon" on the top farthest right side of the dialog box, select the "Main Tabs", then selecting the "Developer" check box which it is in a large square box.
  • Clicking "OK" button at the down below right side of the "Main Tabs" box.
  • Then the "Developer Tab" will display on the ribbon that it usually locates next to the "View" ribbon.
That's all the both Excel operation for Pop Out the Visual Basic Editor for Application.

At this stage, beside the "VBA" you can also just select the Macros, Record Macro, Macro Security,.. buttons on the tab too.
Bye,
Michael Leng

See more articles:
You might like my another blogs:

Tuesday, April 9, 2013

[Shift + F3] Microsoft Excel Shortcut Key for Call Out "Insert Function" Dialog Box Instantly

How many way can I call out a "Insert Function" dialog box?
There are 3 alternative methods to display the dialog box.

When should I use the box such as talking about above?
Whenever you want to use some useful formulas like "VLOOKUP, SUM, AVERAGE, IF, HYPERLINK, COUNT, MAX, MIN, SIN, SUMIF, PMT,.."

Monday, April 8, 2013

[Page Up] Excel Keyboard Key Button For Moving Up Screen One By One

As many Excel users may know that how to move current screen. Generally there are two methods to order the Excel program to change screen from one to another.

Firstly, I believe that there are many people use the scroll on the mouse for rolling the Excel worksheet up and down. That is worked well for the availability of a mouse.

However, just in case there is no any mouse for you to use it. Thus, how to keep your work goes on without any obstacle?

Let's see the solution right here. Look at your PC keyboard key on the right side. You will see the button with quote immediately right here, "Page Up", where commonly is on above the "Page Down" button. Just press the button "Page Up", which state previously for one time, the current active Excel worksheet will go up one for screen.

Keep doing(pressing) it if you want it to move up for more screen until you have been reaching to where you want.
    
Function
Result
Page Up
To move one page screen up Excel worksheet.

It tries to start from an Excel worksheet screen. The cursor, which is in the active cell, will move to the new screen, but stay at the same position.

Moreover, that's all I would like to share with you all for today.

See more tip:
You might like my another blogs:

[Page Down] Excel Keyboard Key Button For Moving Down Page Screen One By One

2 ways for moving Excel's screen down

To move the screen of the current spreadsheet you are working on it with keyboard. Instead of using a scroll down with a mouse, using the button "PAGE DOWN" seems more comfortable way.

Just in case wanting to move the active Excel spreadsheet goes down page by page. There are two ways to manage it.

1. Using the scroll wheel on your mouse to scroll the worksheet up and down. To roll backward or roll into users, the page will move up. On the other hand, to move the Excel worksheet or to move the page down, to roll the scroll forward.

Scroll wheel backward to move the page down 

2. This the alternative way for moving Excel spreadsheet or page down. Just press on the "Page Down" button where usually is at below the "Page Up" button on the right side of keyboard tray(see image attached below). In addition, to do the worksheet upward, you just only press onto the "Page Up" button.

Press the botton "PageDown" to move the page down

Function
Result
Page Down
To move one page screen down.


It will start from the current active worksheet and go screen one by one. The cursor, which is in the active cell, will move to the new screen but still stay at the same position area.

What does the difference between using the "Scroll Roller" and the "Page Down" botton?

The "Scroll Roller" is used for roll from one position starting to move and ending at anywhere once you stop rolling it, whereas the "Page Down" is best for moving from one page screen to the next screen. Keep pressing the button "Page Down" until get to your wherever as aspect.

Does it help?
Michael Leng

See more article:

    Sunday, April 7, 2013

    [Home] Excel Shortcut Move To The Beginning Of A Row In A Worksheet

    Well, what do you know! The [HOME] button in your desk top/laptop/tablet/mobile phone and many more devices, which is installed Microsoft Excel Office software, can do for the unexpected useful functions that you have never know before.

    I am glad to tell you what it, "Home Button", is able to ease the difficulty of your Excel office jobs. What and where to use the letter key shortcut button as I have mentioned  about previously.

    The two main shortcut ways are defined as below:

    1] To move the cursor from the cell in a row that the cursor is occupied to the farthest left cell the end of the same row in an Excel worksheet.


    2] Move the cursor from the current active cell data entry that the cursor is blinking inside to the beginning data entry in the same cell in a worksheet.


    These are all the two shortcut tips of "HOME" letter key. If you use Micro Soft Excel Office Program in your office as a routine job. Do not forget to use these shortcut methods to help you getting your job done faster than it used to be. After you press the shortcut button, then you can apply data validation to cell that is already activated.

    Function
    Result
    Home
    • Move to the beginning of a "ROW" in a worksheet.
    • Move to the beginning of a "CELL DATA ENTRY"[Inside a cell].
    See more another tips:

    Would you like to surf my other blogs?

    Saturday, April 6, 2013

    [Ctrl + Space Bar] Excel Shortcut Keyboard Selecting Entire Column(s)

    Today, let us discover how to select the columns(s) entirely in Excel worksheet with a few steps.

    Why do we have to select the entire columns?


    Because of columns are fundamental parts of any worksheet of Excel office program. They contain with cells that intersect with rows. Then the tips will help us to select all cells from top to down in the columns for any future proceeding such as deleting all entered data in the column(s), deleting or hiding column(s),

    See the 2 methods of how to select column(s) as below:

    1] Use mouse and clicking on the column heading letter as shown as image underneath. Example click on "D" letter on the top of the column.  


    2] Use shortcut letter key.
    • Move cursor to any cell(s) wherever as desired to select. For example as image below, selecting the cells "B7-C7"
    • Press [Ctrl]+[Space Bar] buttons on the keyboard.
    Click the cells B7-C7

    Press [Ctrl] and [Space Bar]
    That's finished.

    The entire cells in the column(s) are selected.

    Function
    Result
    Ctrl + Space Bar
    Select the entire column which cell(s) have been occupying currently.

    Additional : It will work for any column(s) wherever as you want to proceed, just only one single column or more...can do.

    This shortcut is giving the same result if we use the basic method; moving mouse cursor to the head top of some column we want to select. For example, if we would like to select column "B" to "F", just use mouse clicking on the letter "B" to "F" of the top head of the columns.

    See more another tips:
    Would you like to surf my other blogs?

    Friday, April 5, 2013

    [Ctrl + N] Keyboard Shortcut Way Create New Excel Blank WorkBook Instantly

    How to create a new more Excel workbook while the current one still open. In Excel 2010, there are two methods as below:

    1] Create manually.
    • Click on "File" tab that it is on the top left of workbook.
    • Click on "New" tab, which it is usually underneath the recent tab.
    • Then again, click on the "Create" square button on the far right of screen under a portrait transparent new Blank workbook.     
     2] Create a new empty workbook by using Shortcut Keyboard.
    • Press on the "Ctrl" button and keep holding down it.
    • Press another button "N" on the keyboard.
    • Move your fingers out from the both buttons.
    That is all done! If there is nothing mistake. The blank Excel Workbook should show up immediately. Keep pressing the two shortcut buttons repeatedly for create another new more workbook.

    Function
    Result
    Ctrl + N
    Create a new blank workbook instantly. 

    Additional :  Look at the number of workbook in the top middle of the page and select which one wanted to use.

    See more another tips:

    Would you like to surf my other blogs?

    [Ctrl] + [Tab] Move From One Workbook Window To The Next, Next and Next...As You Desire

    In Excel, if you open the workbook of Excel office program more than the only workbook. Suppose, if you want to switch the Excel workbook window from the current window to the others.

    To do that very quickly, there is the shortcut keyboard key for handling it as step by step below:
    • Pressing the “Ctrl” button and hold it 
    • Plus together with the “Tab” button 
    In case of you are opening the workbooks more than 2 windows, and want to move forward to the next and next… Just press the “Ctrl” button and keep holding it while pressing down on the “Tab” button and release it, then to repeat pressing on the “Tab” button again and again until you reach to wherever the Excel Workbook Window as you expect.
    Function
    Result
    Ctrl + Tab
    Move to next / previous current workbook window.


    See more another Excel Shortcut:
    1. [Ctrl]+[Delete] Excel Shortcut Deleting Text Between The Cursor And The End
    2. [Ctrl]+[Y] To Redo Last Action (Multiple Levels) Excel Shortcut Key
    3. [Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key
    4. [Ctrl] [.] (Period) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection
    5. Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally
    6. [Shift]+[Arrow Keys] Expanding The Current Cell To Another Active Cell
    7. [F12] Excel Shortcut Key Display The “Save As” Function Fastest Way
    8. [Ctrl]+[Shift]+[Page Down] Select The Current & Next Sheet In A Workbook
    You might like 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

    [Ctrl + Page Down]/[Ctrl + Page Up] Excel Shortcut Moving Worksheet From One To Another

    I believe in that many Excel users used to use the mouse clicking on the sheet name tab for moving from one worksheet to another within the Excel workbooks.

    Well, in the same way, you can do that by just using your keyboard shortcut as well.

    See here below the method : Move from current worksheet to the next one (Forward).
    • Press the "Ctrl" button and keep hold it down
    • Push down the "Page Down" button
    See here below the method : Move from current worksheet to the previous one (Backward).
    • Press the "Ctrl" button and keep hold it down
    • Press down the "Page Up" button
    Function
    Result
    Ctrl + Page Down/ Ctrl + Page Up
    Move from current worksheet to the next / Move from the current worksheet back to the previous worksheet.

    See more another Excel Shortcut:
    1. [Ctrl]+[Delete] Excel Shortcut Deleting Text Between The Cursor And The End
    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
    You might like 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

    [Ctrl]+[Shift]+[Home] Excel Shortcut Extend The Selected Cells To The Beginning Of The Worksheet

    In Excel workbook, if we want to select the active cells to the beginning of first active cell(a1), which is starting from the current active cell. It’s very simply get that kind of thing done by using the keyboard keys for shortcut it as the method below:
    1. Press the “Ctrl” key button and keep it hold down 
    2. Press the “Shift” button and keep it hold down as well 
    3. Press the “Home” button 
    Then, just move your fingers out of them.

    Function
    Result
    Ctrl + Shift + Home
    Extend the selection of current cell to the beginning of the worksheet (Cell "A1").


    See more another Excel Shortcut:
    1. [Ctrl + P] Shortcut Excel Keyboard Key Button to Order for PRINTING
    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
    You might like my another blogs:

    Thursday, April 4, 2013

    [Ctrl + End] Excel Shortcut Easy Find End Cell Has Ever Entered Data

    How do you find the end active cell in Excel you have entered data?

    Excel is ordinary keeping the end cell data entered of the worksheets, whether that active cell will have any data inside it or not, it will remember. Even you have deleted all the data entered, cleared content, formatted. You see the cell is empty, transparent, and blank.

    Although, it will remember the last cell that has ever contained data or formatted before. That is the nature of Excel program default.

    Short method to the end cell has ever activated.
    Click to see Kindle Fire HDX 7-inches power by Amazon.com

    Follow these steps:
    1. Press the [Ctrl] key button and keep hold it.
    2. Press the other key button [End] on your keyboard.
    3. Release the both key buttons.
    Well done! Wherever your current mouse cursor is, it is going to jump to the last end cell of the worksheet.

    Now you can see where the exactly end active cell of the spreadsheet that you have ever input data into it. Then, you next take any action as you want.

    Function
    Result
    Ctrl + End
    To jump to the last end cell data entered in the worksheet.

    Additional : 

    This will help you to save time and instantly go through the last end cell that has ever entered data previously. To use this shortcut instead of scroll down function. You can apply to use in another program like Word, Blog, Power point, etc. It may work as the same way.

    Oh, this is my tip that I would to share to you who are interesting in Excel conduct.

    See more tip:

    Would you like to surf my other blogs?

    Wednesday, April 3, 2013

    [Alt + F4] Excel Shortcut Key Closing Active Excel Program Window | Exceltip2day Blog

    How do you usually close your Excel program window?

    The answer is to click the 'Close' button the small square upper-right corner of the 'Excel Title Bar' immediate above the 'Close Window' button of Excel 'Menu Bar'. All right, that is a common way that the most every Excel users do it.

    However, there is another alternative for closing the Excel office by using letter keys on keyboard. The two keys are ‘Alt’ and ‘F4’, which they are to use as the shortcut way closing Excel window.

    Here is the hint how to perform the shortcut:
    • Press the “Alt” key and hold down.
    • To press the “F4” button while still keep holding the “Alt” key
    • Release the both keys
    Notify:

    The both Excel closing methods, clicking on ‘Close Window ” button and pressing the ‘Alt’ and ‘F4’ key buttons, will close the only current opened Excel window, the whole workbook will be closed. If there is more than one of Excel window opening. The only particular active window will be closed.

    Additional:

    This will help you to save time for closing the workbook window you have been working on it as a whole.

    You can apply to use for another programs like Word, Blog, Power point, etc.

    Be sure, you will have to save your workbook file prior press "Alt + F4" or otherwise you will lose every data that you have just updated onto your Excel workbook.

    Do not be confused between "Alt + F4" and "Crtl + F4". They are different. Think twice before if you are going to use one of them.

    Function
    Result
    Alt + F4
    Closing active Excel program window. 

    See more:
    1. [Ctrl + S] Excel Shortcut Save Current File Name, File Format & Folder
    2. [Shift+Ctrl+End] Excel Shortcut Extend Selection Cell To Last Used Cell
    3. [Ctrl + A] Selecting Whole Active Cells In Excel Spreadsheet | Shortcut
    4. [Ctrl]+[Y] To Redo Last Action (Multiple Levels) Excel Shortcut Key
    5. [Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key
    6. [Ctrl] [.] (Period) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection
    7. Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally
    8. [Shift]+[Arrow Keys] Expanding The Current Cell To Another Active Cell
    9. [F12] Excel Shortcut Key Display The “Save As” Function Fastest Way
    10. [Ctrl]+[Shift]+[Page Down] Select The Current & Next Sheet In A Workbook
    11. [Ctrl]+[Shift]+[Page Up] Select Current And Previous Sheet In Workbook
    You might like 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

    [Ctrl + S] Excel Shortcut Save Current File Name, File Format & Folder

    You know that in Excel we can save the active file with its latest updated current file name, location(folder), and file format by using the two letter keys on keyboard.

    Actually, I think, we should not say to ‘Save’. I would rather say to ‘Re-Save’ instead. Because this shortcut function is to re-save the Excel file that, you have been created it and then you just want to update some data entry. Instead you have to click on the “Save” icon you can use the shortcut key as given below.

    Here is shortcut the step by step to save (re-save):
    • Press the [Ctrl] button on your keyboard
    • Press the [S] button
    • Release your hand form the both buttons.
    This shortcut is beneficial for saving Excel file very easy. PC mouse is not necessary for this tip.

    Notify:

    Before using this shortcut, please make sure the current workload in the spreadsheet is a final for the sake. Because you cannot restore to the earlier data. It means the ‘Undo’ button cannot activate to recover the previous data.

    What is the common way to save if I do not want to use the shortcut?

    [In Excel Version 2010], move the cursor to the "FILE" tab at the top left of the worksheet corner and click. You will see the ‘SAVE’ button immediate underneath the ‘FILE’ tab.

    Function
    Result
    Ctrl + S
    Latest updated current file name, location, and file format. The worksheet will be saved immediately.

    This tip is a shortcut of "SAVE" function under the 'FILE' tab in the tool bar ribbon (Excel 2010).

    Did you find this article useful?

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

    Tuesday, April 2, 2013

    [Ctrl] + [F4] Shortcut Excel Closing Active Multiple Document That Open Simultaneously


    Do you want to close Excel Multiple Documents Interface (MDI) within fingertips?

    Sometimes, we want to close just only the Excel workbook window that it is opening. With this function, we want the Excel program still not closing from the screen monitor.

    Therefore, we will be able to open the other new empty workbooks, recent workbooks, any Excel workbooks in the folder, etc.

    Using the 2 buttons [Ctrl] & [F4] keyboard to shortcut and totally close all documents that open simultaneously.

    Here below the shortcut step by step:
    • Pressing the [Ctrl] key button and keep it halt. 
    • Then, pressing the [F4] key button on the keyboard. 
    • Then, release the TWO (2) buttons. 
    Immediately, it will result closing the whole active documents workbook window that open simultaneously as the image shown underneath this line.

    Function Key
    Result Description
    [Ctrl] [F4]
    Close the active document in Excel programs that open simultaneously

    Additional:

    This will help you to save time for closing the Multiple Document Interface (MDI) you have been working on it.

    You can also apply the mentioned method above to use in another program like Word, Blog, Power point, etc.
    Before pressing shortcut
    After pressing shortcut
    Notify:

    Be sure, you will have to save your work prior press "Ctrl + F4" or otherwise you will lose all of your data entered that YOU have just only updated on your Excel workbook.

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