Monday, April 28, 2014

[Shift+Ctrl+End] Excel Shortcut Extend Selection Cell To Last Used Cell

This is the powerful Excel shortcut key. I have written this article for helping some Excel program users who may seek for an Excel shortcut like this one, “How Extend Selection Cell from One To The Last Used Cell”.

Now here I am going to tell you shortcut key to extend the selection from any first selected active cell and cover to the last used cell in the Excel worksheet. The selection will array from the started cell to the last used cell in a square form. All active cells within the square frame, they will be highlighted by dim background.

Benefit:

1] To search for the last worked cell in the worksheet quickly.

2] To identify the range of cells between the first selected cell and the last used cell.

Methods:
  • Press the “Shift” button and keep hold it.
  • Press the second button key “Ctrl” and hold as well.
  • Again, press down the “End” button key.
Then, release the three buttons as mentioning above lines.
    That is all done.

    Function
    Result
    Shift + Ctrl + End
    To extend the selected cell to the last worked cell in the Excel worksheet 



    I wish the shortcut of Excel to extend the cell selection which was used later will be benefited for you.

    Please keep intouch and leave any comment(s) that we will use it for our improvement.

    Bye,
    Michael Leng

    See more tips:

    Sunday, April 27, 2014

    [Ctrl]+[Shift]+[&] Excel Shortcut Apply Border The Selected Cell Outline

    In Microsoft Excel Office Program, it's very simple to be made a quick square border to the selected cell(s) in Excel spreadsheet.

    Method:
    • Select the active cell(s) where you want to apply the border (e.g. as the image below is B3 : D6) 
    • Press the "Ctrl" button on your keyboard and keep holding it.
    • Press the "Shift" button and keep holding it as well.
    • Then press the "&" button.
    Then release all the three buttons.

    Instantly, the square outline border of the current selected cells is going to be displayed.

    Note: 

    This shortcut will help you to make the only single one square border. If you select the active cell more than one cell, it will work for outline border.

    Function
    Result
    Ctrl + Shift + &
    Apply the outline border lines on to the selected cells in Excel spreadsheet.



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

    Saturday, April 26, 2014

    [Ctrl + H] Shortcut Excel Keyboard Key "FIND and REPLACE" | Exceltip2day

    Good evening. Today, I'm going to talk about:

    Press the buttons "Ctrl" and "H" to access the "FIND and REPLACE" function for Excel.


    My name is Michael Leng. My article consists of 2 parts. In the first part, I'll describe the "Step by step shortcut method". I'll show you the figure of how the "Find and Replace" work.

    This function very similar to the "FIND" function. They are both in the same order dialog menu box. But this "Ctrl+H" keyboard key Excel shortcut is for calling out the "Find and Replace" dialog menu box instantly.

    Let's start with the 1st part;

    Step by step shortcut method:


    • Press "Ctrl" key and hold it on.
    • Press "H" key button on your keyboard.
    Then, the "Find and Replace" dialog box will appear instantly on your current worksheet.

    • Then just type whatever you want to REPLACE into the "Replace" blank space and don't forget to fill out data which is being replaced into the "Find" blank space too.
    • Press the "Replace" button to get the outcome which is the new data entered (text/numbers...) will replace the unwanted data one by one cell. In case if you want to replace them all, the whole worksheet, just click on the "Replace All"
    Now, I move on to the 2nd part; the how the "Find and Replace" dialog menu box look like.
    Function
    Result
    Ctrl + H
    To find the unwanted data and replace with the other information in your "EXCEL" worksheet.


    This figure brought out by press "Ctrl" & "H" in Excel


    That bring me to the end of my posting.

    I really hope my today's post I have shared with you all will help you to work on your Excel office more easier.

    Thank you for your kind attention to my posting about shortcut key button to call out the "FIND and REPLACE" box .

    Bye,
    Michael Leng

    See more another Excel Shortcut:

    [Ctrl + Home] Excel Shortcut Go To Cell "A1" Of The Current Spreadsheet | ExcelTip2day blog

    Sometimes, when we are typing data onto an Excel spreadsheet with too many data entered, then our current cursor are at wherever in the spreadsheet, if we decide to get back to first top of that spreadsheet, I mean back to cell "A1".

    What is the method for such that operation?

    Here is the shortcut keyboard:

    • Press on the "Ctrl" button and hold down.
    • Then follow by pressing down the "Home" button.

    That's finished.

    It will come out with the current cursor occupying on the cell [A1], the current spreadsheet.  

    Function
    Result
    Ctrl + Home
    To go to the cell "A1" of the current spreadsheet. 


    Additional : 

    This will help you to save time for back to the first cell of Excel worksheet you have been working on it. You can apply to use in another program like Word, Blog, Power point, etc. It may work as the same way.

    Enjoy your daily office working!

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

    Friday, April 25, 2014

    Fast Method of Deleting Excel Multiple Worksheets with A Simple Way


    I am going to tell you all Excel users on "Method of deleting Excel multiple worksheets with a simple way"

    It doesn't matter how many Excel worksheets you have created them. If you have decided not to use eventually, you can delete them with the following method below;

    Step by step deleting Excel multiple worksheets
    • Press "Ctrl" and keep hold it on
    • Use mouse to click where the sheet name tab for deleting (e.g. sheet 1, 2, 3 and 4 as per image above)
    • Right click on mouse, then the "Function Dialog Box" will immediately appear
    • Click on "Delete" tab on the "Function Dialog Box" 
    See more another Excel Shortcut:
    You might like my another blogs: