Skip to main content

Posts

Showing posts from June, 2019

New Article

How to SUM by matching partial text in Excel

How to Resize the Formula Bar in Excel

In Excel, when you are working with a large formula then you need to expand or increase the height of Formula Bar to examine the formula. It is very difficult to examine the 2 or more lines formula in Formula Bar without increasing the height of the Formula Bar. In this tutorial I will show you how can you increase the height of your Formula Bar in Excel in 3 different ways .   Method 1: Mouse Drag - Place your Mouse Pointer in between Formula Bar and Column Header . - This will change your Mouse Pointer to Up-Down Arrow . - Click and Hold your Left Mouse Key and then Drag it down. By this way you can also collapse or decrease the height of your Formula Bar. Method 2: Mouse Click - Place your Mouse Pointer on Formula Bar Down Arrow icon. - Click to increase the height of Formula Bar . By this way you can also collapse or decrease the height of your Formula Bar. Note: If not fully increased, then apply Mouse Drag after Clicking the Formula

How to Create A Checklist in MS Excel

This is 2019. You can use Mobile App in your Smart Phone to maintain a To Do List or Check List . But think you are in Office and you need to create a dynamic report in Microsoft Excel where a Check Box option should present. Or suppose you need to create a custom Check List before going to Office. You don't need to waste your time further if you found my article here. Image 1: Checklist in Excel What is a Check List? Check List is a good way to check your step by step process properly to complete the task. It is the best way of every single task to track or monitor that you are going to finish your task successfully. How to show or activate the Developer Tab? First of all you need to show or activate the Developer Tab in your Excel . To activate or show the Developer Tab , you need to follow below steps: Step 1: Click on Customize Quick Access Toolbar drop down icon and Select More Commands.. . Image 2: Customize Quick Access Toolbar drop down list