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

Tips and Tricks

This category is dedicated to covering all the tips and tricks of Excel.

infographics lock the cells containing formulas in excel

How to Lock the Cells containing Formulas in Excel?

Today, we are going to learn a beneficial thing which is to lock the cells containing Formulas in a workbook so that no co-worker or… Read Article
infographics how to hide cell content in excel

Hide or Unhide Cell Content in Excel

Excel is a potent tool where we can maintain our data. Today, we would learn about how to hide or unhide the cell content or… Read Article
infographics making a calendar in excel

Make a Calendar using the SEQUENCE Function

It is elementary to design a calendar in excel in just three steps. We can make the calendar using the SEQUENCE Function. We would use… Read Article
infographics change column headings from numbers to alphabets

Column Headings from Numbers to Letters

When working with excel spreadsheets, there are times when we see that the column headers are named using numbers and not letters. This actually makes… Read Article
infographics remove blank rows

How to Delete Blank Rows in Excel Spreadsheet?

When we import data from other sources, then it is not necessary that it is in a clean format. Removing blank rows or cells from… Read Article
infographics DATA BARS – MIN MAX VALUE, FORMULA BASED

Data Bars Excel – Min Max Value, Formula Based Bars

The previous article covered the basics of adding and customizing Data Bars. Today we will learn how to define the min and max values of… Read Article
infographics data bars

Data Bars in Excel – Add and Customize

Previously we have learned the basics of conditional formatting. Today we would learn an important part of conditional formatting. Data Bars in Excel are very… Read Article
infographics MANAGE CONDITIONAL FORMATTING RULES

Manage Conditional Formatting Rule – Edit, Delete, Reorder and Copy

In the previous article, we learned the implemented fundamentals of Conditional Formatting and how to use color scales. Today, we will learn how to manage… Read Article
infographics multiple conditional formatting rules

Multiple Conditional Formatting Rules

In the previous blog, we learned the basics of conditional formatting. Today we would learn how to apply multiple conditional formatting rules on the same… Read Article
infographics conditional formatting in excel

What is Excel Conditional Formatting?

Conditional Formatting is a very fascinating topic in excel. It might seem confusing to some people but is one of the straightforward things to learn.… Read Article
color scale infographics

Conditional Formatting using Color Scales

Today, we are going to learn a very interesting topic. Conditional Formatting is used to format the cells based on some condition. Color Scales are… Read Article
infographics count the duration of hours between two dates

How to Count Duration in Hours Between Two Dates?

The Date and time in Excel are stored as decimal numbers. There are times when we need to calculate the total number of hours between… Read Article
Older posts
Page1 Page2 … Page7 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