Excel Tips, Tricks, and Shortcuts

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

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

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

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

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about how to use the shortcut: Ctrl + F10 Tip Quiz Do you know what is the Excel shortcut extend the selected cells to the beginning of the worksheet? My name is Michael Leng. I love blogging very much. It's my second thing that I have been spending my time besides my main job in the company. Well, today, I'm going to tell you the shortcut way to minimize and restore the entire Excel workbook window. This function will reduce an  Excel window's size to only half of its full-size screen window. In my article, I'll divide it into two parts. In the first part, I'm going to tell you about how to use the letters in the keyboard for minimizing and restore your workbook window. After that, I will take you to my image and benefit of the task as I have mentioned prior. 1] Hereafter is the shortcut method: Methods of minimizing/Restore workbook ...

Hello there. Welcome everyone, I'm Michael. Today, I'm going to talk about how to use the key: F2 to operate Excel worksheet. In any active cell, which has the data entered inside it. If you want to edit the data entered in the cell mentioned. There is a shortcut way for getting your work done as shown below. Shortcut for: Shortcut to access inside the cell and edit any data entered   Windows shortcut F2 Hereafter is the method: 1. Click mouse pointer onto the active cell that you want to edit it. 2. Press the [F2] keyboard key. Then the insertion pointer will be inserted and blinked at the end of the line in the active cell. Addition: Shortcut [F2]   also can use for moving the insertion point into the Formula Bar when editing in a cell is turned off too. Thanks for reading. Bye, Posted by: Michael Leng I've known, then I've grown. See more articles: [Ctrl]+[Delete] Excel Shortcut Deleting Text Between The Cursor And The End...

When you have felt out the data entered to the active cell. Then, if you want to delete just the only some character of the data entered in that cell. You are able use the keyboard shortcut key to achieve your job being done. Particularly, to delete all the text in the active cell between the cursor and the end of the current line. Shortcut method step by step: • Press and hold the [ Ctrl ] key button. • Press the [ Delete ] key button. • Release the both key buttons. Benefit: To help you to delete the unwanted text in the cell simply. Of course, free PC mouse to proceed your shortcut. Function Key Result Description [Ctrl] [Delete] To delete text between the cursor and the end. See more another Excel Shortcut: [Ctrl]+[Y] To Redo Last Action (Multiple Levels) Excel Shortcut Key [Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key [Ctrl] [.] (Period) Excel Trick Move Cursor Clockwise To The Next Corner Of The Selection Excel Trick ...