Skip to main content

Posts

Showing posts from July, 2013

Ctrl+F9 Shortcut Excel To Minimize The Current Entire Workbook Window(s) | Exceltip2day

Hello there. I'm Michael Leng. Today, in my blog  "Exceltip2day" , I'm going to talk about: A figure show of an example of the Excel shortcut Ctrl + F9. Tip Quiz What is the shortcut key for Erase The Selected Lines Border Of Cells in Excel worksheet? Tip of shortcut Excel to minimize all current workbook windows to an icon. Therefore, if there is more than the only one of Excel program, which is opening at the same time in your computer, just the only CURRENT workbook will be folded. The short way above is to fold the entire Excel workbook window to a small icon, which will minimize and stay at the below-left corner of the Excel workbook. This method uses the only two buttons of a letter on a keyboard for completion. Benefit: This shortcut will help an Excel office program users who do not want to minimize the entire Excel program window that they are open. Methods of minimizing workbook window(s): Press the button [Ctrl] and hold on. Pre

Paste Data into Selected Excel Column of Entire Range Only Single Click

Trick to copy formula, text, number and any data entering from the current active column to the next adjacent column whether it is on the left or right side. Please take note that this method is worked for the only column that has every cell through out it containing data entering. If there is any empty cell (blank cell) between them, this Excel trick will only work for until the last cell, which the adjacent column has the data entering inside the active cell then it will stop. If you want to resume the this method again for the rest cells. Just double click on the fill handle, the small black square again. Keep doing like this once encounter such as the same kind of problem. For example [see the image below], supposing we are going copy data from column “J” and then to paste into column “K” Trick methods how to copy and paste: Click in cell “K1” and fill out the “=”[equal] in it. Move cursor to click in cell “J1” and press the “Ctrl” and “Enter” buttons on your keyb

How To Find Data In A Range of Specific Cell Of Excel Spreadsheet

Let us say I am going to find a letter or number in an Excel spreadsheet. In addition, the data I am looking for have onto many activate cells within Excel spreadsheet, such as the number “296”. Nevertheless, the number as I have mentioned that is just filed into lots of cells. However, I just would like to find it only in the specific area, in the column “E” of the current active Excel spreadsheet. In order to resemble the topic above and the prepared image below very closely. I am going to tell everyone as the approach step by step as follow: Select the column, row or a range of cells as needed. {In here you should see that I have selected the “E” column} Press shortcut letter on keyboard “Ctrl + F”. Once, a “Find and Replace” function box display. Input what the specific data as purposed in the “Find” blank space. {I have filed out number “296”} Then, the number “296” will be marked with highlight. That’s all finished. Do you think it helps? See more tips:

What Does The [F8] Button Of Excel Keyboard Use As A Shortcut Way?

The keyboard key "F8" of Excel is very useful for cells extinction from the first selected one to the cells wherever in the spreadsheet as Microsoft Office Excel Program users wanted.

Shift+F11 Excel Shortcut Insert New Worksheet into Current Workbook | Exceltip2day

Hello everyone, I'm Michael, welcome to my  "Exceltip2day"  blog. Today I'm going to tell you how to use the shortcut keys to insert the new worksheet for Excel. We will use these two keys  Shift+F11 to perform it. What are these two keys making something easy for any Excel users? Let's see in the detail together with me now. What are the highlights you will learn from our article: ➤  The shortcut key to insert an Excel worksheet. ➤  The figure shows all the step by step of the method. Tip Quiz Do you know what is the shortcut key to insert the current date in any cell of a worksheet? Let's say that we are going to create a new Excel spreadsheet into the current workbook. In Excel, there are two alternatives to get it done. πŸ‘‰ The 1st method is to use the key button in keyboard [Shortcut way] πŸ‘‰   The 2nd method is to deal with mouse pointer [Common way] Shortcut way(Using the keyboard keys); Press the [Shift] key button down an