Skip to content
Excel Unlocked

Let's Unlock the Power of Excel for You

  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us
Excel Unlocked
  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us
Using =VLOOKUP() function for Partial Match in Excel

Using =VLOOKUP() Function for Partial Match in Excel

Many times you have excel data where you want to do a partial match of the data. To perform a partial match of data in… Read Article
Excel Fill Handle Tool

How to use Excel Fill Handle Tool

You might have heard about an amazing Excel Fill Handle Tool? Do you know what exactly is this Excel Fill Handle Tool? What benefit does… Read Article
Select Cells that contain Data Validation

How to Select Cells Containing Data Validation

Do you know how to find and select the cells in an excel worksheet that contain data validation? In this blog we would learn how… Read Article
Creating Dynamic Drop Down List

How to Create a Dynamic Drop Down List in Excel

Do you know that you can even define a dynamic drop-down list in Excel? The excel data validation rule along with =OFFSET() formula would help… Read Article

How to Hide or Unhide Row or Column in Excel

This is a quick guide on how to hide and unhide a row or column in Excel. In this blog, you will unlock several ways… Read Article
Remove Leading Spaces in Excel

How to Remove Leading Spaces in Excel

Has it happened with you that you export some data from some system and there are unwanted spaces before a number, text in Excel? Removing… Read Article
Newer posts
← Previous Page1 … Page39 Page40
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • wout on How to Insert Picture or Image in Excel Comment
  • ALAMIN ABUBAKAR ZARMA on TRUE and FALSE Function in Excel
  • Matthias Lüpke on How to Send Email From Excel Automatically

Archives

Categories

  • Charts (69)
  • Functions (280)
  • Tips and Tricks (73)
  • VBA and Macro (52)

Mission

ExcelUnlocked is dedicated to unlocking the power of Excel for professionals, students and all others who use Excel in their day to day activity.

Excel Unlocked
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2023