Skip to main content

Posts

Showing posts from April, 2013

Trick Change Number In Excel From The Far Right To The Far Left Instead | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to c hange the number the far right to the left. Tip Quiz Do you know what is the shortcut Excel to display the Find and Replace Dialog Box? The trick for today, suppose we have to fill out the cells with some of the numbers and we want them returning in the opposite way. The number we have typed in immediately went to the far right of the cells in a row. But we want to make the number go to the far left instead! How are we able to do that in Excel ? I mean our original data like this; 1 2 3 4 5 6 7 8 9 10 ... and so on until end up at the number 100. Moreover, we want it to be as below; 100 99 98 97 96 95 94 93 92 91 and so on ..3 2 1 0. We have three ways to do it. πŸ‘‰  1] You use transpose paste function systematically below: Transpose it to make it vertical (Copy / Paste Special and select transpose). Sort the data set with the standard

Ctrl+Shift+*(Asterisk) - Excel Keyboard Shortcut Select Active Cells | Exceltip2day

"Ctrl+ Shift+ *(Asterisk)"  What are these keys beneficial for any Excel office user? Hello, everyone. I'm Michael. Welcome you to my Excel tip blog. Today, I'm going to give you the 3 key buttons to select the current region, which are around the cell(s) in the Excel worksheet. Tip Quiz What's the shortcut keys extending the selection to the first cell in an Excel worksheet? Whenever you fill out any data into cells in the Excel worksheet. For any reason, if you want to select all the active cells within it (Spreadsheet). What is the method you are going to do? Do you have your own the "How-To" for handling it? Whether you have one or have not. I am going to share you the three key buttons, shortcut way on a keyboard of your PC, laptop, notebook, tablet ; it is very simple to deal with it. You just press these buttons “Ctrl + Shift + * (Asterisk)” on the keyboard. This shortcut will result in selecting the current active cells th

[Ctrl+Shift+O(letter)] Select All Active Cells Insert Comment Shortcut Way With Key Button

In Excel spreadsheet, one of many functions that we use them for job operating, is the “ Insert Comment ” function. This function is for writing any comment that we don’t want to put on the lines in active cells of Excel spreadsheet. The insert comment function can be used as of both show and hide of the data added within its box. The "Comment box" is great alternative way for keep data as much as needed and hide them in the particular cell that you want to remark. Whenever you want to see it, only explore by clicking on the " Show Comment " button. However, if you wish to find them all the "Insert Comment"  in your Excel spreadsheet, you can do it with your fingertip, - by just press the keyboard shortcut keys as below. Then all the active cells that containing with comments will be displayed with the highlight. Function Result Ctrl+Shift+O To select all active cells with comments. The above three buttons on keyboard need to be

[Ctrl+G] Key Buttons Excel Shortcut Seek Out The "Go To" Dialog Box

I am not sure that anyone used to call out the "Go To" dialog box and take advantage to operate job(s) in the Excel Spreadsheet or not. Because this function box is very good for some particular task such as to find all blank cells in the sheet or just seek the blank cells in the range selected. However, Today I am here to tell you all about how to explore out the embedded "Go To" dialog box of Excel program. In Excel office program, if you have created a name of cells in worksheets for whatever propose. Whenever you reach the cell name lists. Just simply do it by pressing shortcut below. Method of shortcut key: Press "Ctrl" button and keep holding it.  Press "G" button. Release both buttons. Function Result Ctrl + G  To pop up the 'Go To' dialog box and display cell name lists. This task can be used "F5"  alternatively too. It will produce the same result. Hi, friends, before you leave th

Ctrl+F1 Excel Shortcut Key To Minimize / Restore Back Ribbon Bar In Workbook | Exceltip2day

Hello again everyone. I'm Michael. In this article, I'm going to talk about what is the Excel shortcut: "Ctrl+F1" been proceeding for. Tip Quiz What is an Excel shortcut to open a dialog box menu? On every Excel worksheet has the "Order Functions" on a ribbon. They lay on the "Tabs Menu Bar". The ribbon bar is containing and displaying the Excel order functions. The ribbon size is around two centimeters. It always takes some space in the spreadsheet area while it has been opening. Today we are going to seek for the how-to unfold it, ribbon bar, when it is not accessory at a time to show Excel ribbon bar. Therefore, you will have more space wider in your Excel worksheet to operate your contents in. See and do repeat steps as below: Pressing the "Ctrl" and keep freeze. Another press onto the "F1" Release both buttons. That's done. Shortcut:  To minimize or restore the Excel ribbon bar. Wind

Ctrl + F3 Shortcut Excel Display Name Manager Dialog Box Define Cell | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: Ctrl + F3 Excel shortcut Tip Quiz What is the shortcut for selecting all active cells in a range of Excel spreadsheets? Excel has various functions of using. A worksheet[Excel 2007 and 2010] consists of the maximum number of rows 16,384 cells which count from row A1 to XFD1, and columns from A1 to A1,048,576. That makes 17,179,869,184 cells all together in each Excel single sheet. So, how to recognize particular cells in which you work with formula or some condition. To define the name of a cell is the solution. The name of the cell which definitely is a meaningful shorthand for Excel users to work it easier and recognize or find a cell reference, constant, formula, or a table, each of which may be difficult to comprehend while configuring it. The following is one of many shortcuts for Excel for you to launch its function for defining the name of cells or dia

F11 Keyboard Shortcut Create And Insert Excel Chart With Data In Separate Chart Sheet | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to use "F11" as an Excel shortcut. Tip Quiz How do you minimize the current entire Excel workbook window(s)? Thanks for Excel to help us handle lots of jobs, especially calculation. It is a real wonder work for office's works. One of the many functions of Excel is Chart. It is plotting data to use for presentation for comparing data in any period of time such sales amount, employees attendants, fertility rate, etc. The "F11" on the top line of keyboard somewhere a bit on the right. Just press on it, then the empty template of "Chart" will come out instantly in the new spreadsheet, which is before the current one. To repeat you again that this shortcut is best for plotting the data later on after the chart template is available in a worksheet. Moreover, it is in need of new sheet create and insert. Then you can se

Alt+F11 Excel Shortcut To Open Visual Basic Editor To Create Macro | ExcelTip2Day

Hello everyone. I'm Michael. Welcome you all to my blog "Exceltip2day". I'm going to talk about what and how to use an Excel shortcut key as this highlight as follows: "ALT" + "F11" keyboard shortcut to open a visual basic editor. Tip Quiz What is the shortcut to reverse the screen upside down? Do you use Excel for your daily work? I'm Michael Leng, I work for a company in Thailand. In my working office, we usually use Excel to handle our tasks. Therefore, I would like to share with you all through my blog the simple tips about Excel. In Excel Version 2010, There are, as far as I know, 2 ways to display the "Visual Basic Editor" box for the next proceeding the task in Excel program. The first choice is recommended. Because it is very quick and easy. The shortcut is as follows: Press the "Alt" button and keep hold it down Then also press the "F11" together at the same time Keyboard

Shift+F3 Microsoft Excel Shortcut Key for Call Out "Insert Function" Dialog Box Instantly | Exceltip2day

How many ways can I call out an "Insert Function" dialog box? There are 3 alternative methods to display the dialog box. When should I use the box such as talking about above? Whenever you want to use some useful formulas like "VLOOKUP, SUM, AVERAGE, IF, HYPERLINK, COUNT, MAX, MIN, SIN, SUMIF, PMT,.." Hereafter the methods: 1. Use the keyboard shortcut key. Pressing the "Shift" button and keep freezing it. Pressing the other button "F3" on a keyboard. Function Result Shift + F3 To return the insert a function into a formula template. Such as If, Average, Sum,. Figure show the Insert dialog box. 2. The secondalternative is: Clicking the button that looks like as " fx " symbol on the "Function" button on the "Formula Tab" that it is usually located at lowest row underneath the "Formula Tab" of the Ribbon but above the ABC..columns category. 3. Last method tha

Page Up-Excel Keyboard Key Button For Moving Up Screen One By One | Exceltip2day Weblog

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: Page Up Tip Quiz What is the shortcut Excel Keyboard key for "FIND and REPLACE"? What are the highlights you will learn from our article: ➤  The shortcut key to move up screen one by one. ➤  The figure shows all the step by step of the method. As many Excel users may know that how to move the current screen. Generally, there are two methods to order the Excel program to change the screen from one to another. Firstly, I believe that there are many people use the scroll on the mouse for rolling the Excel worksheet up and down. That works well for the availability of a mouse. However, just in case there is no any mouse for you to use it. Thus, how to keep your work goes on without any obstacle? Let's see the solution right here. Look at your PC keyboard key on the right side. You will see the button with the quote immediately right

Page Down Excel Keyboard Key Button For Moving Down Page Screen One By One | Exceltip2day

Hello there. I'm Michael, welcome you to my blog. Today I'm going to talk about: The 2 ways of moving Excel's screen down. My article consists of how to move the screen of the current spreadsheet you are working on it with the keyboard. Instead of using a scroll down with a mouse, using the button "PAGE DOWN"  keyboard seems more comfortable way. Tab:  Learn Pure Thai FB Tab:  E n  Numbers In Words By the way, you can choose which one is fit for you. Ctrl+0(Zero) Excel Shortcut Key To Hide The Selected Column | ExcelTip2Day Tip Quiz What is the shortcut to close your an Excel workbook instantly? Let's come to the point. Just in case wanting to move the active Excel spreadsheet goes down the page by page. There are two ways to manage it. πŸ‘‰  1st method:  Using the scroll wheel On your mouse to scroll the worksheet up and down. To roll back or roll into users, the page will move up. On the other hand, to move the Excel worksheet or to m

Ctrl+Home | Excel Shortcut Move To The Beginning Of A Row In A Worksheet | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about how to use what the shortcut key to get your cursor to the first cell in the same line. They are as below: "Ctrl" + " Home" Don't leave us if you use Excel office in your working life! Well, what you may know the Ctrl and  Home  button on your desktop/laptop/tablet/mobile phone and many more devices. But today, we are going to learn the "Home" key button in program  Microsoft Excel Office software. It can do more for the unexpected useful functions that you might have never known before. I am glad to tell you what it, "Home Button", is able to ease the difficulty of your Excel office jobs. What and where to use the letter key shortcut button as I have mentioned previously. Tip Quiz Do you know the shortcut for how to copy and paste the entry data? The two main shortcut ways are defined as below: 1] To move t