Skip to main content

Posts

Showing posts from April, 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

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

Hello there. I'm Michael. Welcome, everyone. You know that in Excel having the shortcut to access the "FIND and REPLACE" function. Tip Quiz What is the shortcut to Redo Last Action (Multiple Levels) Excel? 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 is 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

[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: [Ctrl] + [F10] Shortcut E

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: [Ctrl] + [F10] Shortcut Excel To Maximize/Restore The Selected Workbook Window [Ctrl] + [F9] Shortcut Excel To Minimize The Current Entire Workbook Window(s) 2 More Alternative Shortcut Tricks Minimize and Maximize Excel Workbook Tricks Adding Number, Date, Letter, Etc. Excel Column with Double Click [Ctrl