CTRL + SHIFT +L: Do you know what is the use of this shortcut? If you know this then write your reply in the comment box. It is related to filter in excel. It can be difficult to find information quickly if your worksheet contains a lot of content. Excel Filter, is used to narrow […]
In this article, we will learn about various ways to use excel filter shortcuts. Like how to apply filter, how to open the drop-down menu in excel filter etc. so let’s start… 1. How to apply Filter in Excel? In the below-given example, we will take data from a list of top billionaires. Friends when […]
Top 10 Excel Shortcut for formatting: In this article we will see the top 10 excel shortcut that is used in formatting, with the help of shortcut you can speed up the excel tasks… so let’s start.. ALT H O I It will feel frustrating when you open the excel workbook but you can not […]
Suppose you are working in the excel and you came to the situation that you want to sum cell based on certain specific criteria. So to solve this, you can use SUMIF function of excel so let’s explore that…….. What is Excel SUMIF Function SUMIF function to sum the values in a range that meet […]
Copy Folder Names in Excel In excel you can learn every day something new. Today I’m sharing that I learned from the problem that I faced in excel. I got data from my team on OneDrive that contains folder names with clients bank account number, so I want that number in excel as shown below: […]