⌨️ 𝔼𝕩𝕔𝕖𝕝 𝕋𝕚𝕡𝕤 𝕋𝕣𝕚𝕔𝕜𝕤 𝕒𝕟𝕕 𝕊𝕙𝕠𝕣𝕥𝕔𝕦𝕥𝕤

Hello friends. I'm Michael. Welcome everyone to in my blog "Exceltip2day" ,  The tip for today is: " How to unlock the Scroll Lock" Tip Quiz Do you know what is the shortcut key(s) to Redo Last Action (Multiple Levels) in an Excel spreadsheet? Check the way [Turn Off] / [Turn On] - Scroll Lock down here. Excel worksheet, you may touch it accidentally a [Scroll Lock] button. This would lock cursor stuck on the current cell. To undo it, do one of the following: i] Press the Scroll Lock / ScrLk key on your keyboard. Alternatively, if some keyboard does not have a Scroll Lock key, such as Notebook, Tablet and some other kind of PC. Just follow the step by step. ii] (Window 7) Go to -Start, -All Programs, -Accessories, -Ease of Access, -Then, just click on the " On-Screen Keyboard " line. When the "On-Screen Keyboard" appears on your screen, click the ScrLK  button as shown on ( In red round rectangle ) the image be...

How to get your printed paper(s) for Excel spreadsheet? In your current Excel spreadsheet which your are working in, if you would like to print it instantly. Here is the shortcut keyboard key method to get it printing. Just follow step by step below: Just only push down the  "Ctrl"  key on your keyboard and hold it down. While keep doing as above, only press the  "P"  button on your keyboard. Then, instantly, the page(s) will show the function of margin adjustment, printer selection, page number choosing, etc. Adjust and set up printing style as you desired. If you have nothing to do so, skip it to the last step beneath that line.  Click the " Print " button to finish your document(s) printing. Function Result Ctrl + P To print the documents of  "EXCEL" worksheet. Alternatively, this tip is a shortcut of "Print" function on FILE tab in the Tool Bar Ribbon. See more another Excel Shortcut: [F2] Shortcu...

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about how to display the find and replace dialog box with the shortcut in your Excel worksheet. And these two-letter keys are the shortcut for today's tip. See more how to deal with them in the following paragraph. Ctrl + F Tip Quiz What is the formula to get the current date and time (varies) in an Excel spreadsheet? In Excel spreadsheet which is full of data in it. For some reason, if we want to look for the particular text, numbers, symbols, etc. in the spreadsheet. What should we simply do that? Don't worry, we're going to show you how to manage it. Figure no. 1 Show how to press the Ctrl + F key buttons. Here below the step by step Keyboard Excel and Shortcut key: To press and hold down the " Ctrl " key button. While holding, just pressing the " F " button on your keyboard. Then the " Find and Replace " dialog box wi...

Guessing many persons, who is using Excel program for daily life working in the office and/or for their own business, really want to use it more simpler. One of Excel trick and keyboard key shortcut for CUT the data from active cells or the whole spreadsheets to paste at the place that it has been selected. Step by step for Excel shortcut keyboard key. Press onto the "Ctrl" button and hold it down. Then, press the "X" button. Release the both buttons on your keyboard. Eventually, to paste it onto wherever as you wish onto your Excel spreadsheet. Function Result Ctrl + X To cut what you are selecting on particular cells or the whole data on work sheet. Then paste it wherever you wish. This tip is an Excel keyboard key shortcut of "Cut" function that's on the HOME in the tool bar ribbon (Excel 2010).  See more another tips: [Ctrl + F] "Find" Shortcut Excel and Keyboard key Tip Ctrl + H [Ctrl + H] ...

As we, MS Excel users, know that in Excel spreadsheet, which is having data entered in it. In case we want to use those data entered that we have added in spreadsheet to put them in another worksheet or active cells. We can do “COPY” the original data from spreadsheet or active cell(s) and “Paste” them at wherever we have decided. Is there any keyboard key shortcut/trick of “COPY” for Excel? Yes, of course. Using keyboard key for operating the PC, notebook, tablet, etc. is not bad idea. Because, definitely, it helps us to save time and not necessary to carry a PC mouse with us all the time to wherever we go. Step by step of keyboard key Excel shortcut for Copying: Selecting all particular data cell(s) or the whole data on the current spreadsheet, which is you want to do copying. Pressing the “Ctrl” button key on keyboard and keeping hold it. Then, just pressing the other key “C” button. Function Result Ctrl + C To copy what you are selecting on particular cel...

Tip for today about Excel shortcut keyboard is "Ctrl + Z" . What is it beneficial you who are using an Excel program? This is to CANCEL(UNDO) to reverse what you have just done for the latest command(last action) in the active cell(s) of your Excel spreadsheet and also to delete the last data entry such as text typing, formula calculating, columns insert, etc. that you have typed or felt out. Method of keyboard key shortcut: Pressing at " Ctrl " button and hold it down. To press on the " Z " button. Then release such the both buttons as mention above. Function Result Ctrl + Z To undo the last action and delete the last entered data. However, on the other way, you can also use the symbol below(the left back arrow) to perform the actions as same as the keyboard key shortcut previously by using your mouse to click on it(the left back arrow button). Here below is the symbols of the left back arrow that you could add it into the "Qui...

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to tell you about: Excel shortcut keys begin with "Ctrl"+ the others 89 Keys. Tip Quiz What is the shortcut to open the visual basic editor? Do you use an Excel office? If yes, now you can find below the list of Excel Shortcut Keys that begin with " Ctrl" and plus with other keys in the keyboard such as: 1. Alphanumeric keys - letters and numbers 2. Punctuation keys - comma, period, semicolon and so on. 3. Special keys - arrow keys, Caps Lock key, control keys, function keys, and more. Why should we use Excel keyboard shortcut key? What are the benefits of using them (shortcut keys & buttons) on your keyboard? Benefits: To say goodbye to your mouse, end slavery to it today. Why do we have to carry a mouse unless we don't have to? A useful way to reach the result immediately. More easing method. It is nonsense while your ...

When you are cutting (Ctrl+X)  or copying (Ctrl+C)  some data in cell/cells, therefore you are going to paste it onto wherever you have desired. Well, I am going to talk about what you can paste your data entered/content with the most quickly way. There are three ways. The very fastest way is the first method that I always have used it. The next method is the second method and the third, which they are taking more steps respectively. Hereafter are the three methods of how to  "Paste"  data entered in Excel. 1] " Ctrl + V " shortcut keyboard (Recommended: Fastest paste method) Press the "Ctrl" and hold down. Press the other button "V" on the keyboard. Then move your finger out of the two mentioned buttons.  Function Result [Ctrl] + [V] To paste what you are copying onto particular area of cell(s) or worksheet. Then, the content(s) will display instantly. 2] Click on the "Paste" button that it is in the Clipboard g...

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about how to solve the Excel problem like as follows: The Excel Worksheet display "This Workbook Contains Links To Other Data Sources" When opening an Excel file. Have you ever been annoyed by the message? " This workbook contains links to other data sources. If you update the links, Excel will attempt to retrieve the latest data. If you don't update the links, Excel will use the previous information.  Note that data links can be used to access and share confidential information without your permission and possibly perform other harmful actions. Do not update the links if you don't trust the source of this workbook. " Tip Quiz Do you know what is the shortcut for filling cell formula down from the adjacent cell above? Hereafter steps to do: 1) Select the "Data Tab" on the ribbon. 2) Click on "Edit Links...

Hello, I'm Michael Leng. Today, I'm going to tell you about how to reduce your Excel file size. Why does my excel file size too big? Mmm, well, let us come to the three methods resolve the problem. Let's start the 1st. part following: ↪Delete un-necessary empty worksheet(s) . Because, some of the Excel workbooks have been setting to display empty worksheet(s) more than one worksheet by default with the sake not waste time to create the new spreadsheet every time when Excel user(s) want to use some more worksheets. Therefore, if any of your Excel program has been settled by the administration. It has some empty spreadsheets in a workbook as default. This is mentioned as above lines earlier. You just delete them. Method: 1] Right click onto the spreadsheet name tab "Sheet 1, Sheet 2," 2] Click the "Delete" function in the ribbon, which is displayed once you have done the "Right click" as line no.1 above right this line. ...

What do you usually do for moving from one active cell to the other? Some people said, “Using mouse to point and click on the desired active cell”. Well, here we are going on how to use the " 4 Arrow Keys " to do it instead of using a mouse clicking. Move UP : Just use your right hand finger press on the “ Upper Arrow ” Move Right : Just use your right hand finger press on the “ Right Arrow ” Move Left : Just do the same way as above, but you just press one the “ Left Arrow ” Move Down : Do the same thing again just press on the “ Down Arrow ” Note: This tip is beneficial to you for moving from one by one cell in the same spreadsheet. See more another Excel Shortcut: [F2] Shortcut To Edit The Active Cell With Cursor At End Of The Line [Ctrl]+[Delete] Excel Shortcut Deleting Text Between The Cursor And The End [Ctrl]+[Y] To Redo Last Action (Multiple Levels) Excel Shortcut Key [Ctrl]+[Z] To Undo Last Action (Multiple Levels) Excel Shortcut Key [Ctrl] [.]...

Do you know that In MS Excel Office Program, there are 2 ways for operating the keyboard shortcut of “Switch to the next tab in dialog box”? The best answers are below. Before we go there, we should to know what a dialog box in Excel looks like first. A dialog box in Excel is a form attached and hidden within some groups of ribbon. It will be explored once the user clicking onto the launcher that commonly located at the bottom below right corner of tools command group. In a dialog box, it has some different features and options that allow users to use it as aspect in the current worksheet. Each option in dialog box can be selected by using mouse clicking on it directly. Additionally, there are 2 more alternatives of shortcut key to select it as well. First Method of Switch the tab in dialog box; Press the [Ctrl] and hold down it. Press the [Tab] All right, that’s done. Second alternative method; Press the [Ctrl] and hold down it. Press the [Shift] button and ...

In Excel workbook has out the “Menu Main Excel Window” and allows users to call it out to display for using it. Menu inside the mentioned Excel window is containing the control functions as restore, move, size, minimize, maximize and close. Generally, this window can be opened by clicking on the Excel symbol [ X ] on the farthest top left corner of Excel workbook. Nevertheless, there is one more alternative method to display it too. It’s the shortcut key on the keyboard. Here the step-by-step shortcut way; Press the [ Alt ] key and hold down Press the other key [ Space Bar ] Release the two buttons Finish. Function Result Alt + Space Bar Display the Control Menu for Main Excel Window. Note: Press [ ESC ] button to escape from the control menu window. See more tricks; Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally [F12] Excel Shortcut Key Display The “Save As” Function Fastest Way [Ctrl]+[Shift]+[Page Up] Select Current And Pre...

The populated cell in an Excel spreadsheet, which is retaining data entered inside it. Nevertheless, sometimes if we want move the flickering cursor inside that cell from the left to the right of each word. To do that, just follow the shortcut way as below: • Press the [ Ctrl ] button and keep freezing. • Then press the [ Right Arrow ] key button. Notify: The flickering cursor will move to the front of the word on the right. It will go from word by word as per the “Right Arrow” being hit. Doing that, remember, it always has to press the “Ctrl” and hold down. Then just keep pressing the “Right Arrow” to go to wherever you want. Function Result Ctrl + Arrow Right To move blinking cursor from left to right within the populated cell. Review more tip: 2 More Alternative Shortcut Tricks Minimize and Maximize Excel Workbook Shortcut Excel Minimize and Maximize all Spreadsheet in a Workbook How To Find Data In A Range of Specific Cell Of Excel Spreadsheet E...