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
How to Add Zeros Before Number in Excel

How to Add Zero in Front of Number in Excel

Many a time, you may have a long list of numbers in Excel and you may wish to add zero before the number. Do you… Read Article
How to remove first character from Cells in Excel

How to Remove the First Character from cells in Excel

Many a time, you may have a dataset in excel wherein there is one additional character at the beginning of the dataset and you wish… Read Article
How to Highlight every Alternate Row in Excel

How to Highlight Every Alternate Row in Excel

Have you ever faced with a need to make your excel dataset table banded? By branded table, I mean that every second, third, fourth, etc.… Read Article
How to Wrap Text in Excel

How to Wrap Text in Excel Cell

Do you know how to wrap a text in an excel cell? What is the purpose of Wrap text function in excel?… Read Article
How to Move Rows or Column in Excel

How to Move Row or Column in Excel

Have you ever wondered how we can move a row or a column in excel quickly without using copy and paste functionality? Let us take… Read Article
How to Remove Middle Name from Full Name in Excel

How to Remove Middle Name from Full Name in Excel

Do you know how to remove the middle name from the full name? In this blog, we would learn different ways that can be used… Read Article
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
Post navigation
Newer posts
← Previous Page1 … Page30 Page31
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 303 other subscribers

Recent Comments

  • Parth Gupta on Show Negative Numbers in Bracket and in Red Color
  • Shailesh on Sparkline in Excel – Insert, Edit and Delete
  • Dhrunil Bhatt on Stack Data from One Column into Multiple Columns

Archives

Categories

  • Charts (67)
  • Functions (243)
  • Tips and Tricks (59)
  • Uncategorized (3)

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.

  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ Excelunlocked.com 2022