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 […]
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: […]
Excel Sum Only Numbers ignore #N/A While working in excel you may have faced this issue that you want to do sum of column or row that contain “#N/A” due to this you can’t apply sum formula because it will throw error. Here we will understand this and solve this issue with example. Let’s Understand […]
Convert Excel file to PDF Nowadays the PDF (Portable Document Format) file is more secure and safe to share instead of your original excel file. So to do that you only need to convert the excel file into PDF. Here we will learn how we can convert excel into PDF. To do that first launch […]