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    


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

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

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.

Step by step shortcut method:
  • Press "Ctrl" key and hold it on.
  • Press "H" key button on your keyboard as well.
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"
Function
Result
Ctrl + H
To find the unwanted data and replace with the other information in your "EXCEL" worksheet.
 

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

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