Faysal Easy Excel

To Reset the Quick Access Toolbar in Default mode, you need to follow the below process: Step 1: Click on File | Options | Quick Access Toolbar and Click on Reset button. Image 1: Reset QAT Step 2: This will show 2 new options. Click on what you wish. In this case I would like to Click on Reset only Quick Access Toolbar . Step 3: Click on Ok .

Many times it is seen that, MIS Executives need to Export or Import their customized QAT or Ribbon settings because of their Laptop or PC changing. In my case, I've got a new laptop :) with newly installed MS Excel 2013. I have few custom commands in my QAT and also in Ribbon. It is time costing issue to customize them again. So, I've to choose Import them all in my newly installed Excel 2013. But before I do it, I need to do Export QAT or Ribbons first from my old Laptop. So, let's see how in details for you. Export customized QAT or Ribbons: Step 1: Open a New MS Excel Workbook in old Laptop. Step 2: Click on File | Options to open the Excel Options dialog box. Step 3: Click on Quick Access Toolbar option and Select the Export all customization from Customizations option. Image 1: Export QAT Step 4: After selecting this option, you will see a File Save dialog box. Now locate a location (example: Desktop) and Click on Save button. Make sur...

In many case, in our professional life, we need to do Copy and Value Paste or Copy and Formula Paste in all most always. Those employees, who works under MIS Department, have to do it lots of time in a single day to prepare reports. It is very time costing task in Office. Many of us use Excel Menubar to do it, others are using Keyboard Shortcut by pressing ALT key (like for Value Paste Press ALT+H+V+V and for Formula Paste Press ALT+H+V+F ). But did you noticed that, these two ways strongly need your attention to do this task. More clearly, if you choose Value Paste from Menubar , then what you need to do? First you should take the mouse in Hand Wheel the mouse in Home menu Then Click on Paste Then you pressure your eyes to find the Value Paste icon And then Click on it to paste it These all steps can take more than 1 second. Am I right? Below is an image of this process: Image 1: Value Paste from Home Menu On the other hand, if you choose the shortcut f...

Camera tool works like original DSL Camera but difference is it is Live. You can shoot a photo and develop it and frame it inside your worksheet anywhere and watch the changing result. Assume that, you have hanged a TV on wall and watching it. How to add it to Quick Access Toolbar (QAT)? To add this tool into your Quick Access Toolbar of your MS Excel, just follow the below steps: Step 1: Click on Customize Quick Access Toolbar down arrow as shown in picture below: Step 2: Click on More commands. Step 3: Excel Options dialog box will appear. Select Quick Access Toolbar from left side navigation bar. Then choose All Commands from Choose commands from drop down list. And then select Camera and Click on Add button and Click on Ok button. Image 1: Adding the Camera tool in Quick Access Toolbar Step 4: Now the tool will show in you Quick Access Toolbar. Select some cells and Click on it to shoot a photo. After Clicking on Camera Tool, your mouse will looks like a '...

Can MS Excel talk like Talking Tom android games? The Answer is YES. You can hear what you have got from a single cell after typing and pressing enter. What is Speak Cells? Well, it is a small tool button named Speak Cells. Under this Speak Cells group you will find 5 different types of command tools. 1) Speak Cells 2) Speak Cells - Stop Speaking Cells 3) Speak Cells by Columns 4) Speak Cells by Rows 5) Speak Cells on Enter How to add it to "Quick Access Toolbar" (QAT)? To add this tool into your Quick Access Toolbar of your MS Excel, just follow the below steps: Step 1: Click on Customize Quick Access Toolbar down arrow as shown in picture below:  Image 1: Customize Quick Access Toolbar Step 2: Excel Options dialog box will appear. Select Quick Access Toolbar from left side navigation bar. Then choose All Commands from Choose commands from drop down list. And then select Speak Cells and Click on Add button and Click on ...