Skip to main content

Posts

Showing posts from October, 2013

[Shift]+[Arrow Keys] Expanding The Current Cell To Another Active Cell

What do you do if you want to extend the current active cells to another cell each side? Say about Excel program system, allow user to manage it simply by using shortcut key. Now, If you are selecting whether how many active cell in the worksheet. It doesn’t matter you can extend them(active cells) more to the four sides, left, right, upper, lower of adjacent active cells. Follow these steps: Press the [ Shift ] [ Left Arrow ] to extend the selection to the adjacent cell on the left. Press the [ Shift ] [ Right Arrow ] to expand the selection to the adjacent cell on the right. Press the [ Shift ] [ Up Arrow ] to extend the selection to the adjacent cell above. Press the [ Shift ] [ Down Arrow ] expending the selection to another underneath cell. Note: [Strathmore 100% Pure Cotton Stationery Paper 97, Wove Finish Watermarked 24 lb, 8.5 x 11 Inch, 500 Sheets/Ream - Sold as 1 Ream,bright Ultimate White Shade (318003)-Power by Amazon.com] You can select the number of the

[F12] Excel Shortcut Key Display The “Save As” Function Fastest Way

Able to manage Excel workbook “Save As” function very quickly. To show the 2 methods of “Save As” that lead to save the new Excel spreadsheet. What are the differences between both proceedings? The common method: 1 To manage by using a mouse. 2 Taking two clicks totally. Amazon.com: MyGift Multipurpose Black Metal Mesh 6 Compartment Desk Organizer Office Supply Caddy by MyGift The keyboard shortcut key: 1 To discard the mouse. 2 Just the only one of “pressing”. Method shortcut key: Press the [F12] key button, which it locates between the [F11] and [PrtSc] buttons on the upper-right corner keyboard. Method by using a mouse: Move the mouse pointer to click on the [File] tab at the “Menu bar”. On the backstage, click the [Save As] button that it is underneath the [Save] button. Therefore, now just select either the common way or the shortcut key as much comfortable as possible; it is on your way. Function Key Result Description [F12] Displ

Ctrl+Shift+Page - Down Select The Current & Next Sheet In A Workbook | Exceltip2day

Hello there. My name is Michael. I'm glad to be here to share with you how to select the current and the next Excel worksheet. If you use an Excel office, stay with me to gain some acknowledge about Excel office used. Do you know In Excel workbook, there are many shortcut ways to navigate Excel worksheet(s)? Tip Quiz What is the way to move cursor clockwise to the next corner of the cell(s) selection? Today, I have picked one of them to tell all of you. It is the keyboard shortcut to navigate and select from the current worksheet as the starting sheet and go to the next, as many worksheets are required. The function key shortcut has the three keyboard letter keys as a combination. The following is the shortcut approach: Pressing the [Ctrl] key and keep it holds down. Then, to press another key [Shift] button and hold it down as well. Again, pressing onto the [Page Down] key button that it is usually immediate underneath the “Page Up” button or on the right side of a k

[Ctrl]+[Shift]+[Page Up] Select Current And Previous Sheet In Workbook

If you have many worksheets in your workbook, then you want to select the current sheet as a base sheet and go to any previous particular sheet. As far as I know, the common way is to use a mouse pointer clicking on the current worksheet, press the “ Ctrl ” key button, and then move a mouse pointer to click on the “ Sheet tabs ” of worksheet, as you need. However, Excel program has a trick that allows you to get the same thing as mentioning above. It is a shortcut way, which there are the three keys on the keyboard combine together for making it out. Shortcut key step by step: • Press the [ Ctrl ] key and hold down • Press the another key [ Shift ] button and hold down too • Press the [ Page Up ] key button • Release all the three key buttons That is alright. Does that help and meet to your sake? Benefit: Save time. Shorter way. Best for select from the first selected Excel worksheet and go to the previous worksheet consequently. There is No way to jump from one

Shift+F4 Excel Shortcut Key To Seek Easily The ‘Last Find’ Cell | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about the shortcut of: Shift+F4 Tip Quiz How do you redo the last action (Multiple levels) Excel with Excel shortcut key? When one is working on an Excel worksheet if he/she has used the “FIND & REPLACE” dialog box for finding any data entering in the worksheet. Then, if you want to know where is the last data entering into the active cell in the worksheet. Which are you have sought latest? There is an easy way to get to the "Last Find" by using the shortcut method below. Hereafter, the shortcut key can head you get to. Keyboard shortcut method: Press the [Shift] key and hold down. Again, press the [F4] key. Move your finger from both keys. Instantly, the particular “Last Find” cell, which you have engaged before, will be indicated by the square border box on your current  Excel  worksheet. Benefits: • End slavery of p.c. mouse

[Ctrl]+[Arrow Keys] Move To The Edge Of Next Region Cells Data Entering

Do you know that we can move from the cells containing data to the next cells by using shortcut key? Sometimes we have filed data into cells of worksheet. However, not every cell we do put data inside it. Therefore, there are some cells might be empty. I have heralded the empty cells because it is significant for the shortcut key as we are going to explore it today. The shortcut key to move to the edge of the next region cells, which they have the data entered. Those the key buttons are [ Ctrl ] + [ Arrow Keys ]. Method: Press the [ Ctrl ] key button and hold down To push the [ Arrow Keys ] button down while keeping the ‘Ctrl’ key in freezing Keep pressing the ‘ Arrow Keys ’ to some cells as you needed Release the 2 keys Benefit: This shortcut helps you to navigate any cells quickly, which they have the data entering within inside. The empty cells will be skipped. Notice: Remember that the [Ctrl] key is the main button, to begin from it first, then just choos

[Tab] Move One Cell To The Right / [Shift]+[Tab] Move To The Left-Excel

What do you do to move the blinking cursor from current cell to the right or the left adjacent cell? Generally, you can use your mouse pointer by moving and clicking in the adjacent as needed. However, Excel office has function key shortcut to perform the same thing instead of using a mouse pointer. In a cell in worksheet of Excel office, after entering data into inside it. The cursor is still blinking in the current active cell of the worksheet. If you want to move the cursor from the present active cell to the adjacent cell on the right. Just press the “TAB” key button on the keyboard. On the other way, if you would rather to move the cursor from the current cell to the cell of the left side. Pressing the “SHIFT & TAB” key buttons to activate it. Please be noted: These 2 shortcut key functions, the direction will go from one cell at a time leading to the adjacent cell as per the route regardless as mentioned above. If you want to change the direction such as