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

Functions

This category is dedicated to covering all the functions and formulas of Excel.

Circular Reference in Excel

All About Circular Reference in Excel

Many a time, while entering any formula in excel, you may have come across an error that says something about “Circular Reference”. In this blog,… Read Article
Transpose Function in Excel

2 Ways to Use Transpose Function in Excel

Have you wondered how to convert the rows into columns and columns into rows in Excel? This is what is called the “Transpose” function in… Read Article
How to Sort Table from Left to Right

Sort Rows in Excel – Sort from Left to Right

Generally, tables in Excel have headings on the top (i.e. column headings). In that case, it is very easy to sort the data from top… Read Article
How to Sort Data or Table in Excel

How to Sort a Table or Data in Excel

In this tutorial, we would learn one of the most important features of Excel that allows you to organize your Excel data table. The feature… Read Article
How to Create a Drop Down List in Excel

How to Create a Drop-Down List in Excel

In this blog, we would learn how to create a drop-down list in excel. This tool is a very user-friendly tool and helps us in… 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 one… 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

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
Post navigation
Newer posts
← Previous Page1 … Page18 Page19
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 298 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 (226)
  • Templates (0)
  • Tips and Tricks (59)
  • Uncategorized (2)

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