Find Duplicate
EXCEL TRICKS

Find Duplicates in Excel

Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to Find and Remove duplicates. So you may watch my detailed video on “Complete Guide for Handling Duplicates” Here I will be explaining one …

Read More
42.5 Remove Duplicates
EXCEL TRICKS

Remove Duplicates in Single Column

When you see duplicate data in single column, you may follow this article to remove these duplicates with few clicks. If you see below screenshot, I have duplicates available in my Column A which are highlighted in yellow: Highlight/Select the Column A, similar to shown in below screenshot: Go To …

Read More
EXCEL TRICKS

Few Simple Excel Tips – Excel Learner Should Know

1. Change Direction When You Press Enter Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very simple. Do you want to change the direction? So let’s do it Click on below highlighted button “File”: …

Read More
EXCEL TRICKS

Impress your Clients by Hiding these Simple Features

While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and Formula Bar. This can give WOW experience to your bosses, clients because after hiding these features, you excel sheet looks like a software …

Read More
EXCEL TRICKS

Lock Cells to avoid editing, Hide Formulas

Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and prevent users to make any editing via “Protect Workbook” Option However you need an additional feature along with the “Protect Sheet” to …

Read More
EXCEL TRICKS

Protect Sheets, Share Workbook, Protect Workbook

Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to make unnecessary editing because it can change calculations, sheets and sometimes, finish the essence of the project So here we are talking …

Read More
EXCEL TRICKS

Hide Excel Sheet/Tab – Complete Guide

When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any changes on it. So I found very awesome feature to hide an excel tab: Though there are multiple ways to hide the excel sheet tab: 1. …

Read More
EXCEL TRICKS

TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?

You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use this amazing excel formula to remove these spaces: Excel Formula: =Trim(text)   Below is an …

Read More
EXCEL TRICKS

VBA Code to Add New Sheet at Beginning or End of Excel File

In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet at the end of Excel file Worksheets.Add After:=Worksheets(Worksheets.Count)   If you want to add the new worksheet at the beginning of …

Read More
EXCEL TRICKS

How to Create dropdown List in Excel – Basic Excel Tip

Excel is an awesome Microsoft utility which most of the professionals are using for their day to day office use as Excel is blood of our daily office lives. Hence it has lots of amazing feature which can ease our data gathering requirements in excel. So here will be talking …

Read More
EXCEL TRICKS

Create Dynamic Data Validation List – Offset Function Method

When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation” technique where I want a smart data validation to avoid all blank cells and keep adding and deleting the values from drop down dynamically. Here we want to talk …

Read More