Skip to content
Excel Unlocked

Let's Unlock the Power of Excel for You

  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
Excel Unlocked
  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
How to Find Unique Values from Dataset in Excel

How to Find Unique Values from Dataset In Excel

Have you ever wondered how to find only unique values from a dataset in Excel? In this blog, we would unlock the technique to find… Read Article
Find Cells that Contain Formula

Three Ways to Find Formula Cells in Excel

Many a time, it may have happened with you that you have a lot many formulas in your excel worksheet and you want to find… 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 Sum the Values in Range Based on Criteria

How to Sum Values Based on Criteria

In this blog, we would unlock the technique to sum the values in the range based on the criteria. It means that the excel would… Read Article
Highlight Rows that Contain Blank Cells

How to Highlight Row that Contains Blank Cells

Do you know, how to highlight the row that contains blank cells? In this blog, we would unlock the technique to highlight the complete row… Read Article
How to Add Same Cells in Multiple Worksheets at one Go in Excel

Add Same Cells in Multiple Worksheets at One Go

Have you faced with the situation wherein you have data in multiple worksheets and you want to add the same cells in multiple worksheets at… Read Article
How to Delete Multiple Worksheets at One Go

How to Delete Multiple Worksheets at One Go in Excel

Have you ever wondered how can we delete multiple worksheets in a workbook at one go? If not, then you are on the right blog.… Read Article
How to Insert Date and Timestamp in Excel

How to Insert Date and Timestamp in Excel

Do you know how to add or insert the date and the timestamp in Excel? In this blog, we would unlock multiple ways to insert… Read Article
Multiple Ways to Change Tab Color in Excel

How to Change Tab Color in Excel

Do you know how to change the tab color in Excel? In today’s blog, we would learn multiple ways to change the worksheet tab color… 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 Dependent Drop Down List in Excel

How to Create a Dependent Drop-Down list in Excel

Do you know how to create a dependent drop-down list in an Excel worksheet? At the end of this blog, you would be able to… Read Article
Older posts
Newer posts
← Previous Page1 … Page39 Page40 Page41 Page42 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • Nilesh Patel on Excel DATEDIF Function – Find Difference Between Dates
  • daniel on Excel XNPV Function – NPV With Irregular Cash Flows
  • wout on How to Insert Picture or Image in Excel Comment

Archives

Categories

  • Charts (69)
  • Functions (281)
  • Tips and Tricks (73)
  • VBA and Macro (73)
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2025